cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Niko0
Engaged Sweeper III
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssetCustom.Printerstatus As Status,
tblAssetCustom.Printedpages As [Printed Pages],
tblAssets.Lastseen,
tblAssets.AssetID,
tblAssets.IPAddress,
tblAssetCustom.Location,
tblAssets.LastChanged,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tblAssets.AssetName Not Like 'rn%' And tblAssetCustom.Printerstatus Like
'%Out of paper%'
Order By tblAssets.AssetName


Change "Out of paper" to the status message your printer shows when it is out of paper.

Check the inbuilt report "Device: Printer status" to find the status message which says that your printer is out of paper.
0 REPLIES 0