Software Installed and Missing Reg Value

[spencerwaller22]

HI, I want to deploy a reg key and value to all machines that have Google Chrome installed.   I can create a report that shows if the value is missing but this will give me all machines even if Chrome isn't installed. 

Is there a report I can create that pulls all the machines that have Google Chrome installed AND the value is missing ?

That value that i need to check for that is missing is - HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Google\Update AutoUpdateCheckPeriodMinutes

[francisswest]

So you've already got the registry scanning enabled and pointed to that key, right?  If so, give this a shot:

SELECT tblAssets.AssetID,
       tblAssets.AssetName,
       tblAssets.Domain,
       tblSoftwareUni.softwareName,
       tblRegistry.Regkey
FROM tblAssets
INNER JOIN tblSoftwareUni ON tblAssets.AssetID = tblSoftwareUni.AssetID
LEFT JOIN tblRegistry ON tblAssets.AssetID = tblRegistry.AssetID
WHERE tblSoftwareUni.softwareName LIKE '%Google Chrome%'
AND (tblRegistry.Regkey IS NULL OR tblRegistry.Regkey NOT LIKE 'HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Google\Update AutoUpdateCheckPeriodMinutes')
ORDER BY tblAssets.AssetName;