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 Printer 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.
Printer Drivers Chart Query
Select Top 1000000 Concat(pdu.Name, ' - ', pd.DriverVersion) as Driver,
Count(a.AssetID) as Assets
From tblAssets a
Left Join tblAssetCustom ac On ac.AssetID = a.AssetID
Join tblPrinterDrivers pd On a.AssetID = pd.AssetID
Join tblPrinterDriversUni pdu On pd.PrinterDriverUniID =
pdu.PrinterDriverUniID
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'
group by pd.DriverVersion,
pdu.Name
order by assets desc
