→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
tech4him
Engaged Sweeper II
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
tech4him
Engaged Sweeper II
Thank-YOU!
Hemoco
Lansweeper Alumni
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