List all your Intel Driver installations and their version with our custom audit report. Use this audit to get an overview of your vulnerable Intel drivers and their versions to quickly identify outdated Intel versions so that you can start the update process as soon as possible. Prevent possible security issues by ensuring your Intel drivers are always updated. The report is based on the official Intel build numbers. The report can be easily modified to check for the latest Intel driver versions. Have a look at our Intel vulnerability blog for more information.
Intel Driver Flaws Query
Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tblVideoController.Caption,
tblVideoController.DriverVersion,
Case
When (tblVideoController.Caption Like '%Intel%Graphics%' And
Left(IntelAssets.DriverVersion,2) = 27 and IntelAssets.DriverVersion < 27201008587) Then 'Vulnerable'
When (tblVideoController.Caption Like '%Intel%Graphics%' And
Left(IntelAssets.DriverVersion,2) = 26 and IntelAssets.DriverVersion < 26201008476) Then 'Vulnerable'
When (tblVideoController.Caption Like '%Intel%Graphics%' And
Left(IntelAssets.DriverVersion,4) = 1540 and IntelAssets.DriverVersion < 1540475166) Then 'Vulnerable'
When (tblVideoController.Caption Like '%Intel%Graphics%' And
Left(IntelAssets.DriverVersion,4) = 1545 and IntelAssets.DriverVersion < 1545335164) Then 'Vulnerable'
When (tblVideoController.Caption Like '%Intel%Graphics%' And
Left(IntelAssets.DriverVersion,4) = 1533 and IntelAssets.DriverVersion < 1533535161) Then 'Vulnerable'
When (tblVideoController.Caption Like '%Intel%Graphics%' And
Left(IntelAssets.DriverVersion,4) = 1536 and IntelAssets.DriverVersion < 1536405162) Then 'Vulnerable'
Else 'Safe'
End As [Vulnerable/Safe],
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When (tblVideoController.Caption Like '%Intel%Graphics%' And
Left(IntelAssets.DriverVersion,2) = 27 and IntelAssets.DriverVersion < 27201008587) Then '#ffadad'
When (tblVideoController.Caption Like '%Intel%Graphics%' And
Left(IntelAssets.DriverVersion,2) = 26 and IntelAssets.DriverVersion < 26201008476) Then '#ffadad'
When (tblVideoController.Caption Like '%Intel%Graphics%' And
Left(IntelAssets.DriverVersion,4) = 1540 and IntelAssets.DriverVersion < 1540475166) Then '#ffadad'
When (tblVideoController.Caption Like '%Intel%Graphics%' And
Left(IntelAssets.DriverVersion,4) = 1545 and IntelAssets.DriverVersion < 1545335164) Then '#ffadad'
When (tblVideoController.Caption Like '%Intel%Graphics%' And
Left(IntelAssets.DriverVersion,4) = 1533 and IntelAssets.DriverVersion < 1533535161) Then '#ffadad'
When (tblVideoController.Caption Like '%Intel%Graphics%' And
Left(IntelAssets.DriverVersion,4) = 1536 and IntelAssets.DriverVersion < 1536405162) Then '#ffadad'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
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
Inner Join tblVideoController On
tblAssets.AssetID = tblVideoController.AssetID
Left Join (Select Top 1000000 tblAssets.AssetID,
Convert(bigint,Replace(tblVideoController.DriverVersion, '.',
'')) As DriverVersion,
tblVideoController.Caption
From tblAssets
Inner Join tblVideoController On tblAssets.AssetID =
tblVideoController.AssetID
Where tblVideoController.Caption Like '%Intel%Graphics%') As IntelAssets On
IntelAssets.AssetID = tblAssets.AssetID
Where tblVideoController.Caption Like '%Intel%Graphics%' And tblVideoController.DriverVersion Is Not Null And
tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName