EOL Asset DB – Printers

The IT Assets Database was replaced by the IT Admins CMDB and is EOL / End of Life, no further development will be done on this project.

Printers depend on the printer models. You can define a printer name that should be unique, and additional SAP name – or simply secondary name for the same printer if needed, select the model and define the location of the printer.

Further can printers be attached to a contract that you chose from your expenses, assuming it is a leased or serviced printer.

Due to the fact that you can add multiple MAC addresses, you can assign IP addresses in the IPAM for e.g. a wired and wireless interface, those would show up here. If you have IP addresses showing up, you can actually double click it to have the web-interface opened in your web browser.

Further can you add some basic meter read information, in case you want to track them based on POs or Invoices. This does not tie back to anything, but allows you to keep some track and the information possibly could be used to generate some graphs later on.

Incidents show up for the device, if an incident was added to a printer you could see what happened or was serviced on the device.

You can even use the PRINT ASSET LABEL button to quickly print information for the asset and attach the print-out to e.g. an workstation that is sitting on a shelf while it is available. This label will hold the most important information like the Asset Tag, Deployment Status, basic hardware information and serial number. This helps a lot to identify systems on the shelf while seeing the most important information right away.

Data field and reference overview

  • Asset Tag
  • Printer name and SAP Printer name – printers often have very specific SAP names independent from the regular printer name (might apply to more then just SAP, though)
  • Printer Model
    • define printer models in a sub-table
    • add supplies to the printer model and see them directly in the printer-config
  • Department and Employee 
  • Location and Status Notes
  • Deployment Status
  • Contract / Expense reference 
  • Contract Service ID – this might be simply the asset reference needed by the vendor in order to send out a supporter or new toners
  • Serial Number
  • Purchase Date, PO and Ticket information  as well as retirement information
  • IP Address references and MAC addresses
  • Confirm it exists as an ongoing inventory (every time you touch this, this helps to determine when it was last seen)
  • SNMP community and OIDs in order to automatically read the current copy and print-out statistics
  • manual meter reads for invoices in order to document them
  • Incidents
  • Notes and Tags
  • Checklists in order to deploy and retire a printer etc.

Usage statistics

While you can as well engage checklists to e.g. deploy and retire printers as well as adding notes and tags to them, you can further define a SNMP community and SNMP strings to query the various page counts from the printer, such as total print outs, color and black and white print outs as well as copies. Configuring this, a instance of the database will engage an SNMP query tool that actually will collect the data from the printer and write it back to the database.

This collected data can be viewed RAW as the total value that was collected – but way more important – the database can show you the data relative as a monthly or daily graph. This allows you to quickly see over time how heavy a printer was used in the past or that the usage e.g. increased. You as well get an idea of the overall usage of the printer / copier and you can draw conclusions if the chosen model is sufficient at this location. This helps to decide if e.g. a request for a higher end model is really justified or if the current model is good enough or even oversize.

 

SNMPGet tool

In order to use this feature you will need an additional external DOS program, that will collect the data. I was able to use SNMPGet from SNMPSoft. Be aware, you need to adhere to their license restrictions and I am not responsible or affiliated in any way for this tool nor with this company/source. I only provide the information on what you can use – other tools might need an adjustment to the code.

The path to the tool is to be defined in the SysConfig under SNMPGet – Path.

If you want to use another tool, you might need to adjust the code in the module mdlSNMP – as this module currently executes a command line with those parameters:

The SNMP queries will be executed by any user that has the LDAPSync Enabled flag set in the user config and the database open of course. As mentioned in other sections, it is to recommend in some situations that you determine a single user account that has the sole purpose to LDAP sync. and execute the SNMP queries on a dedicated system / VM. This avoids that you get interrupted or any of your users with those executions and you can improve in this case the SNMP security if you want to.

SNMP configuration

In order to help you – here are some SNMP community strings that worked for me – it is a bit of a hassle with some printers to get them right. In general it is hard to find the correct SNMP strings, you might need to play around with it, engage Internet Search engines etc. and eventually use a test-tool – like the Paessler SNMP Tester – what can be a huge help. Unfortunately some vendors stick to some standards while others don’t, meaning there simply is no generic answer and worse do the most of the time not make the SNMP MIBs or OIDs publicly available.

  • Brother
    • 2270DW
      • Total: 1.3.6.1.3.6.1.2.1.43.10.2.1.4.1.1
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • MFC 7860DW
      • Total: 1.3.6.1.2.1.43.10.2.1.4.1.1
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
  • Hewlett Packard
    • Color LaserJet M452DN
      • Total: 1.3.6.1.2.1.43.10.2.1.4.1.1
      • Printouts – b/w: 1.3.6.1.4.1.11.2.3.9.4.2.1.4.1.2.6.0
      • Printouts – color: 1.3.6.1.4.1.11.2.3.9.4.2.1.4.1.2.7.0
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • Color LaserJet Pro M452dw
      • Total: 1.3.6.1.2.1.43.10.2.1.4.1.1
      • Printouts – b/w: 1.3.6.1.4.1.11.2.3.9.4.2.1.4.1.2.6.0
      • Printouts – color: 1.3.6.1.4.1.11.2.3.9.4.2.1.4.1.2.7.0
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • DesignJet T830
      • Total: 1.3.6.1.2.1.43.10.2.1.4.1.1
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • LaserJet 4250
      • Total: 1.3.6.1.4.1.18334.1.1.1.5.7.2.1.1.0
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • LaserJet 600 M602
      • Total: 1.3.6.1.2.1.43.10.2.1.4.1.1
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • LaserJet MFP M426FDW
      • Total: 1.3.6.1.2.1.43.10.2.1.4.1.1
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • LaserJet P2055DN
      • Total: 1.3.6.1.4.1.18334.1.1.1.5.7.2.1.1.0
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • LaserJet P3005
      • Total: 1.3.6.1.2.1.43.10.2.1.4.1.1
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • LaserJet Pro M401dw
      • Total: 1.3.6.1.2.1.43.10.2.1.4.1.1
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • LaserJet Pro M402N
      • Total: 1.3.6.1.2.1.43.10.2.1.4.1.1
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • PageWide Pro 477DW MFP
      • Total: 1.3.6.1.2.1.43.10.2.1.4.1.1
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
  • Konica
    • Bizhub 4750
      • Total: 1.3.6.1.4.1.18334.1.1.1.5.7.2.1.1.0
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • Bizhub 4752
      • Total: 1.3.6.1.4.1.18334.1.1.1.5.7.2.1.1.0
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • Bizhub C458 (color)
      • Total: 1.3.6.1.4.1.18334.1.1.1.5.7.2.1.1.0
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
  • Kyocera
    • FS-C5200DN KX
      • Total: 1.3.6.1.4.1.18334.1.1.1.5.7.2.1.1.0
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
  • Ricoh
    • Aficio MP5002
      • Total: 1.3.6.1.4.1.18334.1.1.1.5.7.2.1.1.0
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • Aficio MP5054
      • Total: 1.3.6.1.2.1.43.10.2.1.4.1.1
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
    • MP C2503
      • Total: 1.3.6.1.2.1.43.10.2.1.4.1.1
      • Printouts – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.2
      • Printouts – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.2
      • Copies – b/w: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.1.1
      • Copies – color: 1.3.6.1.4.1.18334.1.1.1.5.7.2.2.1.5.2.1
  • Zebra Technologies
    • 110Xi4
      • Total: 1.3.6.1.4.1.10642.200.17.3.0
      • Printouts – b/w: 1.3
      • Printouts – color: 1.3
      • Copies – b/w: 1.3
      • Copies – color: 1.3
    • ZD620
      • Total: 1.3.6.1.4.1.10642.200.17.3.0
      • Printouts – b/w: 1.3
      • Printouts – color: 1.3
      • Copies – b/w: 1.3
      • Copies – color: 1.3
    • ZT610
      • Total: 1.3.6.1.4.1.10642.200.17.3.0
      • Printouts – b/w: 1.3
      • Printouts – color: 1.3
      • Copies – b/w: 1.3
      • Copies – color: 1.3
    • ZTC GK420t
      • Total: 1.3.6.1.4.1.10642.200.17.3.0
      • Printouts – b/w: 1.3
      • Printouts – color: 1.3
      • Copies – b/w: 1.3
      • Copies – color: 1.3