IE: unauthorized IE BHOs Report

[tech4him]

Yet another person who has accidentally over-written a stock report. Anyone able to provide the SQL for the IE: unauthorized IE BHOs report please.

Maybe LanSweeper.com can keep a library of Stock Reports AND allow submission of custom reports by the community that is more easily categorized searchable than the forums. (Just a thought)

Thank-you.

[tech4him]

Thank-YOU!

[Hemoco · Accepted solution]

Please use the SQL query below.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblIEBHO.Control,
tblIEBHO.Lastchanged,
tsysOS.Image As icon
From tblIEBHO
Inner Join tblAssets On tblIEBHO.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where (Not (tblIEBHO.Control In (Select tblSafeguids.guid
From tblSafeguids)) And Not (tblIEBHO.Control Like '{CAFEEFAC-00%'))
And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblIEBHO.Lastchanged