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