uBlock Origin Light Chrome Compliance Chart

Select
Case 
when SubQuery3.Value like 'ddkjiahejlhfcafbddmgiahcphecmpfh%' and SubQuery3.Value not like 'cjpalhdlnbpafiamejdnhcphjbkeiagm%' and SubQuery4.Value = 'cjpalhdlnbpafiamejdnhcphjbkeiagm'
and SubQuery2.Valuename = 'disableFirstRunPage' and SubQuery2.Value = '1' 
Then 'Yes' else 'No'
end as [Setup Complete],
Count(Distinct tblassets.AssetID) as Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
Inner Join tblComputerSystem On tblComputerSystem.AssetID = tblAssets.AssetID
Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblRegistry
Where
tblRegistry.Regkey Like '%SOFTWARE\Policies\Google\Chromerdparty\Extensions\ddkjiahejlhfcafbddmgiahcphecmpfh\policy' and tblRegistry.Valuename = 'disableFirstRunPage') as SubQuery2
On SubQuery2.AssetID = tblAssets.AssetID

Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblRegistry
Where
(tblRegistry.Regkey Like '%Software\Policies\Google\Chrome\ExtensionInstallForcelist' And
(tblRegistry.Value like 'ddkjiahejlhfcafbddmgiahcphecmpfh%' Or
tblRegistry.Value like 'cjpalhdlnbpafiamejdnhcphjbkeiagm%'))
) as SubQuery3
On SubQuery3.AssetID = tblAssets.AssetID

Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblRegistry
Where
(tblRegistry.Regkey Like '%Software\Policies\Google\Chrome\ExtensionInstallBlocklist' And
(tblRegistry.Value = 'cjpalhdlnbpafiamejdnhcphjbkeiagm'))
) as SubQuery4
On SubQuery4.AssetID = tblAssets.AssetID

Where tblAssetCustom.State = 1 And TsysWaittime.CFGname = 'registry' and tblComputersystem.Domainrole <= 1
Group by SubQuery3.Value, SubQuery4.Value, SubQuery2.Valuename, SubQuery2.Value