Documentation
    {{docApp.userSession.userId}}
    {{docApp.userSession.userName}}
    {{docApp.userSession.email}}
    Issuer : {{docApp.userSession.issuerInstance}}
    Expires : {{new Date(docApp.userSession.validUntil).toLocaleDateString()}}

{{docApp.title}}

{{docApp.description}}

How can we help?

{{docApp.searchError}}
{{product.name}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

{{group.title || group.id}}

{{group.description}}

  1. {{book.title}}

{{group.title}}

{{book.title}}
More...

CMDB Printer Assets

  • Article
  • 4 minutes to read

Details

Table ID: h_cmdb_assets_printer

Stores information about assets in the 'Printer' asset class in the CMDB

Table Attributes

Name Value
Primary Key h_pk_asset_id

Columns

Name & ID Description Column Attributes Relationships
Asset ID
h_pk_asset_id
 Unique record identifier. AutoVal: itsmAssetId keyed to h_itsm_assets.h_pk_asset_id
Type VARCHAR
Size 32
Nullable false
Primary Key true
One to One
Asset
h_cmdb_assets.h_pk_asset_id
Average Pages Per Minute
h_average_pages_per_minute
 The description for this asset (mapped to h_itsm_assets.h_description)
Type VARCHAR
Size 8
Nullable true
Discovery Configuration Fingerprint
h_dsc_cf_fingerprint
 The MD5 fingerprint of the overall asset configuration
Type VARCHAR
Size 32
Nullable true
Discovery Hardware Fingerprint
h_dsc_hw_fingerprint
 The MD5 fingerprint of the hardware configuration
Type VARCHAR
Size 32
Nullable true
Discovery Network Fingerprint
h_dsc_net_fingerprint
 The MD5 fingerprint of the network configuration
Type VARCHAR
Size 32
Nullable true
Discovery SIID
h_dsc_siid
 The ID of the Site Integration Server that last discovered this asset
Type INTEGER
Nullable true
Discovery Software Fingerprint
h_dsc_sw_fingerprint
 The MD5 fingerprint of the installed software configuration
Type VARCHAR
Size 32
Nullable true
Discovery Source
h_dsc_source
 The id of the discovery profile used to discover this asset
Type INTEGER
Nullable true
First Discovered
h_dsc_first_discovered
 The date/time the asset was first discovered
Type DATETIME
Nullable true
Horizontal Resolution
h_horizontal_resolution
 The horizontal resolution of the asset
Type VARCHAR
Size 32
Nullable true
Image Fuser
h_image_fuser
 The status of the Image Fuser in the printer (e.g. OK, Replace, etc)
Type VARCHAR
Size 64
Nullable true
Image Transfer Roller
h_image_transfer_roller
 The status of the Image Transfer Roller in the printer (e.g. OK, Replace, etc)
Type VARCHAR
Size 64
Nullable true
Languages
h_languages
 The operational languages available for the asset
Type VARCHAR
Size 64
Nullable true
Last Changed
h_dsc_last_changed
 The date/time the asset configuration was last detected
Type DATETIME
Nullable true
Last Discovered
h_dsc_last_discovered
 The date/time the asset was last discovered
Type DATETIME
Nullable true
Manufacturer
h_manufacturer
 The company that makes this asset
Type VARCHAR
Size 64
Nullable true
Marking Technology
h_marking_technology
 The marking technology of the asset (laser, inkjet etc)
Type VARCHAR
Size 64
Nullable true
Model
h_model
 The model number/name of this asset
Type VARCHAR
Size 64
Nullable true
Network IP Address
h_net_ip_address
 The ip address(es) of this asset
Type VARCHAR
Size 128
Nullable true
Network MAC Address
h_net_mac_address
 The MAC address of this asset
Type VARCHAR
Size 32
Nullable true
Network wMAC Address
h_wmac_address
 The wMAC address of this asset
Type VARCHAR
Size 32
Nullable true
Number of Trays
h_number_of_trays
 The number of input trays that the asset has
Type INTEGER
Nullable true
Paper Sizes
h_paper_sizes
 The paper sizes that are accepted by the asset
Type VARCHAR
Size 32
Nullable true
Port
h_port
 The port of the asset
Type VARCHAR
Size 16
Nullable true
Printer Capabilities
h_printer_capabilities
 The capabilities of this asset
Type VARCHAR
Size 64
Nullable true
Quantity in stock of Toner or Ink
h_quantity_in_stock_black
 The quantity in stock of Toner or Ink - Black
Type VARCHAR
Size 32
Nullable true
Quantity in stock of Toner or Ink
h_quantity_in_stock_cyan
 The quantity in stock of Toner or Ink - Cyan
Type VARCHAR
Size 32
Nullable true
Quantity in stock of Toner or Ink
h_quantity_in_stock_magenta
 The quantity in stock of Toner or Ink - Magenta
Type VARCHAR
Size 32
Nullable true
Quantity in stock of Toner or Ink
h_quantity_in_stock_yellow
 The quantity in stock of Toner or Ink - Yellow
Type VARCHAR
Size 32
Nullable true
Serial Number
h_serial_number
 The serial number/tagID number of this asset
Type VARCHAR
Size 128
Nullable true
Toner or Ink code
h_toner_code_black
 The Toner or Ink code - Black
Type VARCHAR
Size 64
Nullable true
Toner or Ink code
h_toner_code_cyan
 The Toner or Ink code - Cyan
Type VARCHAR
Size 64
Nullable true
Toner or Ink code
h_toner_code_magenta
 The Toner or Ink code - Magenta
Type VARCHAR
Size 64
Nullable true
Toner or Ink code
h_toner_code_yellow
 The Toner or Ink code - Yellow
Type VARCHAR
Size 64
Nullable true
Toner or Ink level
h_toner_level_black
 The current level of Toner or Ink in the printer - Black
Type VARCHAR
Size 32
Nullable true
Toner or Ink level
h_toner_level_cyan
 The current level of Toner or Ink in the printer - Cyan
Type VARCHAR
Size 32
Nullable true
Toner or Ink level
h_toner_level_magenta
 The current level of Toner or Ink in the printer - Magenta
Type VARCHAR
Size 32
Nullable true
Toner or Ink level
h_toner_level_yellow
 The current level of Toner or Ink in the printer - Yellow
Type VARCHAR
Size 32
Nullable true
Vertical Resolution
h_vertical_resolution
 The vertical resolution of the asset
Type VARCHAR
Size 32
Nullable true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document