Created a report to cover the models publish by HP that may be impacted by CVE-2023-1707 which scores a 9.1 out of 10 using the CVSS v3.1. Feedback welcome
Title: Device: Printer HP Enterprise LaserJet CVE-2023-1707
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Printerstatus As Status,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model As [Device model],
tblAssets.description,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Where (tblAssetCustom.Manufacturer Like '%Hewlett-Packard%' And
tblAssets.assettype Like 'printer' And tblAssetCustom.model Like '%E40040%')
Or
(tblAssetCustom.model Like '%E42540%') Or
(tblAssetCustom.model Like '%E45028%') Or
(tblAssetCustom.model Like '%E47528%') Or
(tblAssetCustom.model Like '%E730%') Or
(tblAssetCustom.model Like '%E73025%') Or
(tblAssetCustom.model Like '%E73030%') Or
(tblAssetCustom.model Like '%E731%') Or
(tblAssetCustom.model Like '%E73130%') Or
(tblAssetCustom.model Like '%E78523%') Or
(tblAssetCustom.model Like '%E78528%') Or
(tblAssetCustom.model Like '%E785dn%') Or
(tblAssetCustom.model Like '%E786%') Or
(tblAssetCustom.model Like '%E786%') Or
(tblAssetCustom.model Like '%E78625%') Or
(tblAssetCustom.model Like '%E826dn%') Or
(tblAssetCustom.model Like '%E826z%') Or
(tblAssetCustom.model Like '%E877%') Or
(tblAssetCustom.model Like '%E87740%') Or
(tblAssetCustom.model Like '%M406%') Or
(tblAssetCustom.model Like '%M407%') Or
(tblAssetCustom.model Like '%M430%') Or
(tblAssetCustom.model Like '%M431%') Or
(tblAssetCustom.model Like '%M455%') Or
(tblAssetCustom.model Like '%M480%') Or
(tblAssetCustom.model Like '%E82650%')
Order By tblAssets.AssetName
