Windows: unauthorized Internet Explorer Extensions (Built-in)

[Daniel_B]

Old name: IE: unauthorized IE Extensions

The report below gives back a list of computers with Internet Explorer Extensions installed which are not marked as authorized under Configuration\Allowed Active-X

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

• The asset is set to the 'Active'
  
• The asset is a Windows computer
  
• The asset has been successfully scanned at least once
  
• The asset has IE Extensions installed
  
• The asset is not as authorized under Configuration\Allowed Active-X

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,
 tblIEExtensions.Control, 
 tblIEExtensions.Buttontext
From tblAssets
 Inner Join tblIEExtensions ON tblIEExtensions.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 tblIEExtensions.Control Not In (SELECT tblsafeguids.guid FROM tblsafeguids) And tblState.Statename = 'Active' 
Order By tblAssets.Domain, tblAssets.AssetName