Notification

Icon
Error

Report Hard Disk Copiers - Report for all Copiers

Posted: Monday, September 23, 2019 3:11:41 PM(UTC)
Cerona

Cerona

Member Original PosterPosts: 1
0
Like
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!
RC62N
#1RC62N Member Posts: 455  
posted: 9/24/2019 5:57:32 PM(UTC)
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.
Code:
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

Active Discussions

Lansweeper Count of each browser installed
by  AllSeeingEye   Go to last post Go to first unread
Last post: Yesterday at 2:44:48 PM(UTC)
Lansweeper Custom Reports Email Question
by  muffintopman  
Go to last post Go to first unread
Last post: Yesterday at 1:57:58 PM(UTC)
Lansweeper Windows Update Setting Report
by  Brandon   Go to last post Go to first unread
Last post: 8/11/2020 5:11:45 PM(UTC)
Lansweeper Customized Printer Toner Report
by  Cripple.Zero  
Go to last post Go to first unread
Last post: 8/10/2020 9:08:00 PM(UTC)
Lansweeper Pages printed in the last 30 days
by  RC62N   Go to last post Go to first unread
Last post: 8/10/2020 5:18:05 PM(UTC)
Lansweeper Report for a percentage of calls closed within SLA
by  mouaad  
Go to last post Go to first unread
Last post: 8/10/2020 3:45:58 PM(UTC)
Lansweeper Report for tickets closed per agent last week
by  MLeman   Go to last post Go to first unread
Last post: 8/10/2020 9:55:39 AM(UTC)
Lansweeper Software List by Computer/Server Name
by  nnewton  
Go to last post Go to first unread
Last post: 8/7/2020 6:56:47 AM(UTC)