Need Help Creating Query

[ja3hawk]

I need to pull a list of computer names that DO NOT have a certain piece of software installed searching by softwarename?

How do I do this. I tried a modified version of the post below mine but was unable to get the proper results.

[Hemoco]

Normally they are bound to report.

[Hemoco]

could you post an extract from "select * from tblFileVersions"

[KRH]

Lansweeper wrote:
could you post an extract from "select * from tblFileVersions"

This seems to work:

Select tblFileVersions.Computername, tblFileVersions.FilePathfull,
  tblFileVersions.Found
From tblFileVersions
Where tblFileVersions.FilePathfull Like '%file.exe%' And tblFileVersions.Found <>
  ''

Btw. how i can delete those 'web30rep*' things from reportbuilder?

[Hemoco]

KRH wrote:



Btw. how i can delete those 'web30rep*' things from reportbuilder?

Right click on the report/delete

[KRH]

Lansweeper wrote:

KRH wrote:



Btw. how i can delete those 'web30rep*' things from reportbuilder?

Right click on the report/delete

I mean these:

[KRH]

I tried to create custom report.

Added one file to scanned files list (C:\Folder\file.exe). Then created following query:

SELECT
  tblFileVersions.Computername,
  tblFileVersions.FilePathfull
FROM
  tblFileVersions
WHERE
  tblFileVersions.FilePathfull LIKE '%file.exe%'

Report shows that this file has been found on many computers that doesn't have it. What's wrong with this report?

[ja3hawk]

Thanks. That helped out.. It was just a tad different but nesting the select was key.

[Hemoco]

should be something like

SELECT computername FROM tblcomputer where computername not in (select computername from tblsoftware WHERE softwarename
 = 'Trend Micro Client/Server Security Agent')

[ja3hawk]

SELECT DISTINCT TOP 100 PERCENT
tblsoftware.computername
FROM
tblsoftware
WHERE
NOT softwarename = 'Trend Micro Client/Server Security Agent'




This just brings back all of the computer names. There should be about 10-15 that don't have this software.