Windows: Internet Explorer unauthorized ActiveX control (Built-in)

[Daniel_B]

Old name: IE: unauthorized ActiveX control (Built-in)

The report below lists Windows assets with installed ActiveX controls that 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 state is set to "active".
  
• The asset has been successfully scanned at least once.
  
• The asset is a Windows computer.
  
• Not allowed ActiveX control installed (exception: Java console)

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,
 tblIEActiveX.Control, 
 tblIEActiveX.CodeBase
FROM tblAssets 
 Inner Join tblIEActiveX ON tblIEActiveX.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  tblIEActiveX.Control Not In (SELECT tblsafeguids.guid FROM tblsafeguids) 
 And tblIEActiveX.Control not Like '{CAFEEFAC-00%'
 ANd tblState.Statename = 'Active' 
Order By tblAssets.Domain, tblAssets.AssetName