cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Cerona
Engaged Sweeper
Hello,

We need a report for all copiers / printers.

Is it possible to get a report with the following information:

- Name of the hard disk
- Hard disk serial number
- Size of the hard disk

Eventually:

- Serial number of the printer / copier
- counter of the printer / copier

Thanks in advance!
1 REPLY 1
RCorbeil
Honored Sweeper II
I can't speak to the printers' hard drives, but for the second part, here's the heart of a report I use for serial numbers, page counts, etc. I've made the IP address field a hyperlink to make it simple to open each printer's web interface.
Select Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
'http://' + tblAssets.IPAddress As [hyperlink_IP Address],
tblAssets.IPAddress As [hyperlink_name_IP Address],
tblAssets.IPNumeric As [IP (sortable)],
tblAssets.Mac As [MAC Address],
tblAssets.Lastseen,
tblAssetCustom.Location,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblAssetCustom.Printedpages,
tblAssetCustom.PrintedColorPages,
tblAssetCustom.PrintedMonoPages,
tblAssetCustom.Printerstatus,
tblAssets.Description
From
tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where
tsysAssetTypes.AssetTypename = 'Printer'
Order By
tblAssetCustom.Manufacturer,
tblAssets.AssetName