uBlock Origin Light Edge Compliance Audit

SELECT * FROM (
    SELECT DISTINCT TOP 1000000 
        tsysOS.Image AS icon,
        tblAssets.AssetID,
        tblAssets.AssetName,
        tblAssets.Domain,
        tblAssets.Username,
        tblAssets.Userdomain,
        tblAssets.IPAddress,
        CASE 
            WHEN SubQuery3.Value LIKE 'cimighlppcgcoapaliogpjjdehbnofhn%' 
                 AND SubQuery3.Value NOT LIKE 'odfafepnkmbhccpbejgmiehpchacaeak%' 
                 AND SubQuery4.Value = 'odfafepnkmbhccpbejgmiehpchacaeak'
                 AND SubQuery2.Valuename = 'disableFirstRunPage' 
                 AND SubQuery2.Value = '1' 
            THEN 'Yes' 
            ELSE 'No' 
        END AS [Setup Complete],
        SubQuery2.Valuename AS Policy,
        SubQuery2.Value AS [Policy Value],
        CASE 
            WHEN SubQuery3.Value LIKE 'cimighlppcgcoapaliogpjjdehbnofhn%' THEN 'uBlock Origin Lite'
            WHEN SubQuery3.Value LIKE 'odfafepnkmbhccpbejgmiehpchacaeak%' THEN 'uBlock Origin'
            ELSE SubQuery3.Value 
        END AS ExtensionInstallForcelist,
        CASE 
            WHEN SubQuery4.Value = 'cimighlppcgcoapaliogpjjdehbnofhn' THEN 'uBlock Origin Lite'
            WHEN SubQuery4.Value = 'odfafepnkmbhccpbejgmiehpchacaeak' THEN 'uBlock Origin'
            ELSE SubQuery4.Value 
        END AS ExtensionInstallBlocklist,
        CASE
            WHEN TsysLastscan.Lasttime < GETDATE() - 1 THEN 
                'Last registry scan more than 24 hours ago! Scanned registry information may not be up-to-date. Try rescanning this machine.'
        END AS Comment,
        tblAssets.Lastseen,
        tblAssets.Lasttried,
        TsysLastscan.Lasttime AS LastRegistryScan
    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\Microsoft\Edge\3rdparty\Extensions\cimighlppcgcoapaliogpjjdehbnofhn\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\Microsoft\Edge\ExtensionInstallForcelist' 
              AND (tblRegistry.Value LIKE 'cimighlppcgcoapaliogpjjdehbnofhn%' 
                   OR tblRegistry.Value LIKE 'odfafepnkmbhccpbejgmiehpchacaeak%')
    ) 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\Microsoft\Edge\ExtensionInstallBlocklist' 
              AND tblRegistry.Value = 'odfafepnkmbhccpbejgmiehpchacaeak'
    ) AS SubQuery4 ON SubQuery4.AssetID = tblAssets.AssetID
    WHERE tblAssetCustom.State = 1 
          AND TsysWaittime.CFGname = 'registry'
		  AND tblComputersystem.Domainrole <= 1
) AS SubQueryMain
WHERE [Setup Complete] = 'No'
ORDER BY SubQueryMain.Domain, SubQueryMain.AssetName