Lexmark CVE-2023-23560 Vulnerability Audit

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 tblAssets.assettype like 'printer' and
tblAssetCustom.Manufacturer Like '%Lexmark%' and
tblassetcustom.model like '%CX944%' or
tblassetcustom.model like '%XC9335%' or
tblassetcustom.model like '%XC9445%' or
tblassetcustom.model like '%XC9455%' or
tblassetcustom.model like '%XC9465%' or
tblassetcustom.model like '%MX432%' or
tblassetcustom.model like '%XM3142%' or
tblassetcustom.model like '%MX931%' or
tblassetcustom.model like '%XC4342%' or
tblassetcustom.model like '%XC4352%' or
tblassetcustom.model like '%B2236%' or
tblassetcustom.model like '%MB2236%' or
tblassetcustom.model like '%MS331%' or
tblassetcustom.model like '%MS431%' or
tblassetcustom.model like '%M1342%' or
tblassetcustom.model like '%B3442%' or
tblassetcustom.model like '%B3340%' or
tblassetcustom.model like '%XM1342%' or
tblassetcustom.model like '%MX331%' or
tblassetcustom.model like '%MX431%' or
tblassetcustom.model like '%MB3442%' or
tblassetcustom.model like '%MS321%' or
tblassetcustom.model like '%MS421%' or
tblassetcustom.model like '%MS521%' or
tblassetcustom.model like '%MS621%' or
tblassetcustom.model like '%M1242%' or
tblassetcustom.model like '%M1246%' or
tblassetcustom.model like '%B2338%' or
tblassetcustom.model like '%B2442%' or
tblassetcustom.model like '%B2546%' or
tblassetcustom.model like '%B2650%' or
tblassetcustom.model like '%MS622%' or
tblassetcustom.model like '%M3250%' or
tblassetcustom.model like '%MX321%' or
tblassetcustom.model like '%MB2338%' or
tblassetcustom.model like '%MX421%' or
tblassetcustom.model like '%MX521%' or
tblassetcustom.model like '%MX522%' or
tblassetcustom.model like '%MX622%' or
tblassetcustom.model like '%XM1242%' or
tblassetcustom.model like '%XM1246%' or
tblassetcustom.model like '%XM3250%' or
tblassetcustom.model like '%MB2442%' or
tblassetcustom.model like '%MB2546%' or
tblassetcustom.model like '%MB2650%' or
tblassetcustom.model like '%MS725%' or
tblassetcustom.model like '%MS821%' or
tblassetcustom.model like '%MS823%' or
tblassetcustom.model like '%MS825%' or
tblassetcustom.model like '%B2865%' or
tblassetcustom.model like '%MS822%' or
tblassetcustom.model like '%MS826%' or
tblassetcustom.model like '%M5255%' or
tblassetcustom.model like '%M5270%' or
tblassetcustom.model like '%MX721%' or
tblassetcustom.model like '%MX722%' or
tblassetcustom.model like '%MX822%' or
tblassetcustom.model like '%MX826%' or
tblassetcustom.model like '%XM5365%' or
tblassetcustom.model like '%XM7355%' or
tblassetcustom.model like '%XM7370%' or
tblassetcustom.model like '%MB2770%' or
tblassetcustom.model like '%C3426%' or
tblassetcustom.model like '%CS431%' or
tblassetcustom.model like '%CS439%' or
tblassetcustom.model like '%CS331%' or
tblassetcustom.model like '%C3224%' or
tblassetcustom.model like '%C3326%' or
tblassetcustom.model like '%C2326%' or
tblassetcustom.model like '%MC3426%' or
tblassetcustom.model like '%CX431%' or
tblassetcustom.model like '%XC2326%' or
tblassetcustom.model like '%MC3426%' or
tblassetcustom.model like '%MC3224%' or
tblassetcustom.model like '%MC3326%' or
tblassetcustom.model like '%CX331%' or
tblassetcustom.model like '%CS622%' or
tblassetcustom.model like '%C2240%' or
tblassetcustom.model like '%CS421%' or
tblassetcustom.model like '%CS521%' or
tblassetcustom.model like '%C2325%' or
tblassetcustom.model like '%C2425%' or
tblassetcustom.model like '%C2535%' or
tblassetcustom.model like '%CX522%' or
tblassetcustom.model like '%CX622%' or
tblassetcustom.model like '%CX625%' or
tblassetcustom.model like '%XC2235%' or
tblassetcustom.model like '%XC4240%' or
tblassetcustom.model like '%MC2535%' or
tblassetcustom.model like '%MC2640%' or
tblassetcustom.model like '%CX421%' or
tblassetcustom.model like '%MC2325%' or
tblassetcustom.model like '%MC2425%' or
tblassetcustom.model like '%CX820%' or
tblassetcustom.model like '%CX825%' or
tblassetcustom.model like '%CS827%' or
tblassetcustom.model like '%CX860%' or
tblassetcustom.model like '%XC6152%' or
tblassetcustom.model like '%XC6153%' or
tblassetcustom.model like '%XC8155%' or
tblassetcustom.model like '%XC8160%' or
tblassetcustom.model like '%XC8163%' or
tblassetcustom.model like '%CS820%' or
tblassetcustom.model like '%CS827%' or
tblassetcustom.model like '%C6160%' or
tblassetcustom.model like '%CS720%' or
tblassetcustom.model like '%CS725%' or
tblassetcustom.model like '%CS727%' or
tblassetcustom.model like '%CS728%' or
tblassetcustom.model like '%C4150%' or
tblassetcustom.model like '%CX725%' or
tblassetcustom.model like '%CX727%' or
tblassetcustom.model like '%XC4140%' or
tblassetcustom.model like '%XC4143%' or
tblassetcustom.model like '%XC4150%' or
tblassetcustom.model like '%XC4153%' or
tblassetcustom.model like '%CS921%' or
tblassetcustom.model like '%CS923%' or
tblassetcustom.model like '%CS927%' or
tblassetcustom.model like '%C9235%' or
tblassetcustom.model like '%CX920%' or
tblassetcustom.model like '%CX921%'
Order By tblAssets.AssetName