→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
05-08-2024 01:23 PM
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
05-10-2024 07:36 PM
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;
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now