Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper II
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.
Lansweeper Alumni
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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now