
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-22-2011 03:30 PM
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.
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.
Labels:
- Labels:
-
Archive
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-22-2011 04:54 PM
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
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
