Trying or edit a report for Windows drivers error on Query screen. Windows: Installed PNP drivers

[jasonlalanne]

I'm working to use the Windows: Installed PNP drivers report and want to use it as a template to find Intel WIFI driver versions DSA-2024-272: Security Update for Dell Client Platform for Intel® PROSet/Wireless WiFi and Intel® Wi....  Is there a fix for this or another report I can use to do this? The main report works so it would be great to just modify this.  

[jasonlalanne]

This is the code from the default report that is built in.  I'm just trying to edit it to find specific drivers.  

SELECT TOP 1000000

a.AssetID,

a.AssetName,

a.Domain,

a.Username,

a.Userdomain,

Coalesce(os.Image, [at].AssetTypeIcon10) AS [icon],

a.IPAddress,

ipl.IPLocation,

ac.Manufacturer,

ac.Model,

os.OSname AS [OS],

a.SP,

a.Lastseen AS [Last successful scan],

a.Lasttried AS [Last scan attempt],

pnpdu.DeviceName,

pnpdu.Description,

pnpd.FriendlyName,

pnpdu.DeviceClass,

pnpdu.DriverProviderName,

pnpd.DriverVersion,

pnpd.HardwareID,

pnpd.PDO,

pnpd.DeviceID

FROM tblAssets a

LEFT JOIN tblAssetCustom ac ON ac.AssetID = a.AssetID

JOIN tblPnPSignedDrivers pnpd ON a.AssetID = pnpd.AssetID

JOIN tblPnPSignedDriversUni pnpdu ON pnpd.PnPSignedDriverUniID = pnpdu.PnPSignedDriverUniID

LEFT JOIN tsysAssetTypes at ON [at].AssetType = a.Assettype

LEFT JOIN tsysIPLocations ipl ON a.IPAddress = ipl.IPLocation

LEFT JOIN tsysOS os ON os.OScode = a.OScode

LEFT JOIN tblState st ON st.State = ac.State

WHERE LOWER(st.Statename) = 'active'

AND pnpd.PDO IS NOT NULL

AND pnpd.PDO <> ''

ORDER BY a.Domain, a.AssetName, pnpdu.DeviceClass, pnpdu.DeviceName

[FrankSc]

Hello Jasonlalanne,

We assume you have a syntax error in the generated code. 
Can you share the SQL Query? 
Alternatively you can also send this to Lansweeper Support. They should be also able to show you the mistake in the code.