Printer Out Of Paper

[Niko0]

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.