Documentation

{{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}}

CMDB Telecoms Assets

Details

Table ID: h_cmdb_assets_telecoms

Stores information about assets in the 'Telecoms' 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
h_cmdb_assets.h_pk_asset_id
Discovery Fingerprint
h_dsc_fingerprint
The MD5 fingerprint of the overall item
Type VARCHAR
Size 32
Nullable true
Extension
h_extension
The extension
Type VARCHAR
Size 16
Nullable true
Indexed true
IP Address
h_ip_address
The ip address for this asset
Type VARCHAR
Size 128
Nullable true
MAC Address
h_mac_address
The MAC address for this asset
Type VARCHAR
Size 32
Nullable true
Manufacturer
h_manufacturer
The manufacturer for this asset
Type VARCHAR
Size 64
Nullable true
Model
h_model
The Model for this asset
Type VARCHAR
Size 128
Nullable true
Indexed true
Phone Number
h_phone_number
The phone number
Type VARCHAR
Size 32
Nullable true
Indexed true
The Serial Number
h_serial_number
The Serial Number for this asset
Type VARCHAR
Size 128
Nullable true
Indexed true
wMAC Address
h_wmac_address
The wMAC address for this asset
Type VARCHAR
Size 32
Nullable true
Indexed true
In This Document