How to Scan computers for a specific file and create a report to show the results

[PierreM]

I want to scan all computers for a file called zebrabarcode.ttf in %windir%\system32.

Can you please provide detailed instructions on how to scan PCs for this and the SQL statement(s) to build this custom report.

thanks

[Cobra7]

There are lots of posts about this. If you do a search you will find what your looking for.

As far as how to scan for a file this is in the manual.

The SQL code you may want is something like:

SELECT 
  tblComputers.Computername,
  tblComputers.Username,
  tblFileVersions.FileVersion
FROM
  tblFileVersions
  INNER JOIN tblComputers ON (tblFileVersions.Computername = tblComputers.Computername)
WHERE
  tblFileVersions.FilePathfull LIKE '%zebrabarcode.ttf'