Windows: Unauthorized Internet Explorer bars (Built-in)

[Daniel_B]

Old name: IE: unauthorized IE Bars (Built-in)

The report lists Windows assets with Internet Explorer menu bars that are not marked as allowed under Configuration\Allowed Active-X

The report will only list assets that meet all of the following criteria:

• The asset state is set to "active".
  
• The asset has been successfully scanned at least once.
  
• The asset is a Windows computer.
  
• The asset has not allowed IE menu bar installed.

Select Top 1000000 tblAssets.AssetID,
 tblAssets.AssetName,
 tblAssets.Domain,
 tblAssets.Username,
 tblAssets.Userdomain,
 Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
 tblAssets.IPAddress,
 tsysIPLocations.IPLocation,
 tblAssetCustom.Manufacturer,
 tblAssetCustom.Model,
 tsysOS.OSname As OS,
 tblAssets.SP,
 tblAssets.Lastseen,
 tblAssets.Lasttried,
 tblIEBars.Control 
FROM tblAssets 
 Inner Join tblIEBars ON tblIEBars.AssetID = tblAssets.AssetID
 Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
 Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
 Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID 
 Inner Join tblState On tblState.State = tblAssetCustom.State
 Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
WHERE tblIEBars.Control Not In (SELECT tblsafeguids.guid FROM tblsafeguids)
 And tblIEBars.Control Not Like '{CAFEEFAC-00%' 
 And tblState.Statename = 'Active' 
Order By tblAssets.Domain, tblAssets.AssetName