Lansweeper is able to scan three different types of drivers, Plug and Play (PnP) drivers, System drivers, and Printer drivers along with all the related details like their version, date, state, and more. Using chart reports, you’ll be able to get a better overview of the current status of your drivers. The report below provides you with an overview of how many PnP drivers you have along with their versions. You can read more about using driver data in the Pro Tips blog post.
To use this in a chart widget, prefix the report name with «Chart:» and select it in the chart report widget found on a dashboard.
PnP Drivers Chart Query
Select Top 1000000 Concat(pnpdu.Description, ' - ', pnpd.DriverVersion) as Driver,
count(a.AssetID) as Assets
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 tblState st On st.State = ac.State
Where pnpd.PDO Is Not Null And pnpd.PDO <> '' And Lower(st.Statename) = 'active'
group By pnpdu.Description,
pnpd.DriverVersion
order by assets desc
