Get an Overview of Your Printer Drivers
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.
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