I've got a report as below to find computers with the following registry key. I can't seem to figure out how to create a report to find computers without the registry key. Can I get some help with this?
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblRegistry.Regkey Like '%SOFTWARE\Safend\Protector' And
tblRegistry.Valuename = 'InstallDir'
Order By tblAssets.AssetUnique