I have been banging my head against this for a while.
I am trying to create a report that scans for the absence of a custom registry value.
I can run the report for the registry value I am scanning for directly from the scan reg/file screen and see which PCs have it. And I have a report that shows the value of the key.
But I want to setup a deployment that will do some stuff and set this custom reg value. Then run the deployment against this report of PCs missing the registry value.
I was able to do this for a custom file scan but for the life of me cant get it going for this registry key.
OK I found it and will set it under Reports Completed. Man I think I just needed more sleep....
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tsysOS.OSname,
tsysOS.Image As icon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.AssetID Not In (Select tblRegistry.AssetID From tblRegistry
Where tblRegistry.Regkey Like 'HKEY_LOCAL_MACHINE\SOFTWARE\CustomSubKey' And
tblRegistry.Valuename = 'CustomKeyName') And tblAssetCustom.State = 1
Order By tblAssets.AssetName
