New report - missing *.exe

[sisman]

Hi,
how can I make report to see on which computers file C:\Windows\System32\DriveLock.exe is MISSING?
Report should also have Username, Displayname, Computer.

[Hemoco]

First make sure that you have added the specified file for scanning, as shown in the attached image.

If you immediately wish to scan for this file, perform a "Full Rescan" of the computers you need.


Use the following SQL code for your report:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, tblADusers.Username, tblADusers.Displayname, tblFileVersions.FilePathfull As [Attempted To Scan], tblFileVersions.Found, tblFileVersions.FileVersion, tblFileVersions.Filesize, tblFileVersions.CompanyName From tblComputers Inner Join tblFileVersions On tblComputers.Computername = tblFileVersions.Computername Left Join tblADusers On tblADusers.Username = tblComputers.Username And tblADusers.Userdomain = tblComputers.Userdomain Where tblFileVersions.FilePathfull = 'C:\Windows\System32\DriveLock.exe' And tblFileVersions.Found = 0 Order By tblComputers.Computername