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
  • 8 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
Ext.Custom Date 1
h_custom_ext_date1
 Extended Custom Date 1
Type DATETIME
Nullable true
Ext.Custom Date 2
h_custom_ext_date2
 Extended Custom Date 2
Type DATETIME
Nullable true
Ext.Custom Date 3
h_custom_ext_date3
 Extended Custom Date 3
Type DATETIME
Nullable true
Ext.Custom Date 4
h_custom_ext_date4
 Extended Custom Date 4
Type DATETIME
Nullable true
Ext.Custom Date 5
h_custom_ext_date5
 Extended Custom Date 5
Type DATETIME
Nullable true
Ext.Custom Date 6
h_custom_ext_date6
 Extended Custom Date 6
Type DATETIME
Nullable true
Ext.Custom Date 7
h_custom_ext_date7
 Extended Custom Date 7
Type DATETIME
Nullable true
Ext.Custom Date 8
h_custom_ext_date8
 Extended Custom Date 8
Type DATETIME
Nullable true
Ext.Custom Decimal 1
h_custom_ext_dec1
 Extended Custom Decimal 1 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 2
h_custom_ext_dec2
 Extended Custom Decimal 2 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 3
h_custom_ext_dec3
 Extended Custom Decimal 3 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 4
h_custom_ext_dec4
 Extended Custom Decimal 4 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 5
h_custom_ext_dec5
 Extended Custom Decimal 5 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 6
h_custom_ext_dec6
 Extended Custom Decimal 6 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 7
h_custom_ext_dec7
 Extended Custom Decimal 7 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 8
h_custom_ext_dec8
 Extended Custom Decimal 8 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Integer 1
h_custom_ext_int1
 Extended Custom Integer 1
Type INTEGER
Nullable true
Ext.Custom Integer 2
h_custom_ext_int2
 Extended Custom Integer 2
Type INTEGER
Nullable true
Ext.Custom Integer 3
h_custom_ext_int3
 Extended Custom Integer 3
Type INTEGER
Nullable true
Ext.Custom Integer 4
h_custom_ext_int4
 Extended Custom Integer 4
Type INTEGER
Nullable true
Ext.Custom Integer 5
h_custom_ext_int5
 Extended Custom Integer 5
Type INTEGER
Nullable true
Ext.Custom Integer 6
h_custom_ext_int6
 Extended Custom Integer 6
Type INTEGER
Nullable true
Ext.Custom Integer 7
h_custom_ext_int7
 Extended Custom Integer 7
Type INTEGER
Nullable true
Ext.Custom Integer 8
h_custom_ext_int8
 Extended Custom Integer 8
Type INTEGER
Nullable true
Ext.Custom Text 1
h_custom_ext_text1
 Extended Custom Text 1
Type LONGTEXT
Nullable true
Ext.Custom Text 2
h_custom_ext_text2
 Extended Custom Text 2
Type LONGTEXT
Nullable true
Ext.Custom Text 3
h_custom_ext_text3
 Extended Custom Text 3
Type LONGTEXT
Nullable true
Ext.Custom Text 4
h_custom_ext_text4
 Extended Custom Text 4
Type LONGTEXT
Nullable true
Ext.Custom Varchar 1
h_custom_ext_char1
 Extended Custom Varchar 1
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 2
h_custom_ext_char2
 Extended Custom Varchar 2
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 3
h_custom_ext_char3
 Extended Custom Varchar 3
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 4
h_custom_ext_char4
 Extended Custom Varchar 4
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 5
h_custom_ext_char5
 Extended Custom Varchar 5
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 6
h_custom_ext_char6
 Extended Custom Varchar 6
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 7
h_custom_ext_char7
 Extended Custom Varchar 7
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 8
h_custom_ext_char8
 Extended Custom Varchar 8
Type VARCHAR
Size 255
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