How to create Custom report for Registry key that i scan ?

[ronenu]

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.

[Hemoco]

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')