Find All Printers on Your Network and Their Status
Get an overview of your printers’ status and find potential problems. Printers will always be the bane of IT’s existence, with this report you can get started on printer troubleshooting before the complaints come in. The report shows printers and their status, along with additional details like the number of printed pages and model.
Printer Status Query
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssetCustom.Printerstatus As Status,
tblAssetCustom.Printedpages As [Printed Pages],
tblAssetCustom.Model As [Device model],
tblAssets.Lastseen,
tblAssets.AssetID
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tblAssetCustom.Printedpages Is Not Null And tblAssetCustom.State = 1
Order By tblAssets.AssetName
