cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ronenu
Engaged Sweeper
Hi

I just upgraded my Lansweeper to version 3.5
i added a coustome "Scanned registy key" that scan HKEY_LOCAL_MACHINE SYSTEM\CurrentControlSet\Services\USBSTOR
and looking for regvalue "Start"

Under Configuration Browser >> registry keys , i see this key that im scanning.


my problem is that i want to build custom report that will show me all the computers in the domain and the value of this key for every computer.
i dont know how to do this


need help please.

Ronen.
1 REPLY 1
Hemoco
Lansweeper Alumni
Should be something like this:

SELECT     dbo.tblComputers.Computername, dbo.tblRegistry.Valuename, dbo.tblRegistry.Value, dbo.tblRegistry.Lastchanged
FROM dbo.tblRegistry INNER JOIN
dbo.tblComputers ON dbo.tblRegistry.Computername = dbo.tblComputers.Computername
WHERE (dbo.tblRegistry.Valuename = 'Start')