We have an application that needs regular updates, and we want to track what PC's have to updates and which ones don't. I have a RegKey setup to be scanned by LS. LS appears to be picking up the RegKey right. Now I want a report that will check if the app is installed then check for the existance of these the RegKey. If the Key is not there then display in the report.
When I run the report I get all the PC's in LS. I select to see the "Value" in the report and I see all the scanned RegKey values that are being scanned. So I guess the report is correctly working but it isn't working how I want. I want it to only return info for PC's with the Corp Application installed, and doesnt' have the RegKey Value in it. Hopefully that explained it well enough.
Here is some sample SQL query:
SELECT DISTINCT
tblComputers.Computername
FROM
tblComputers
INNER JOIN tblRegistry ON (tblComputers.Computername = tblRegistry.Computername)
INNER JOIN tblSoftware ON (tblRegistry.Computername = tblSoftware.ComputerName)
WHERE
tblSoftware.softwareName = 'Corp Application' AND
tblRegistry.Value <> '{RegKey Value}'
