10-31-2024 12:23 PM
Hi all,
I have a report that shows machines with a specific registry added, which allows some legacy (but business-critical) software to run correctly. I would like to show machines without this registry key so I can target them after scanning to deploy the registry key fix
The report is below. Can anyone help?
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetCustom.State,
tblRegistry.regkey,
tblRegistry.Valuename,
tblRegistry.Value
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblAssetCustom.State = 1 And
tblRegistry.regkey =
'HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\General'
Solved! Go to Solution.