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 Network Device Assets

Details

Table ID: h_cmdb_assets_network_device

Stores information about assets in the 'Network Device' 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
Backed Up
h_backed_up
Backed Up
Type VARCHAR
Size 4
Nullable true
Indexed true
Description
h_description
The description for this asset (mapped to h_itsm_assets.h_description)
Type VARCHAR
Size 255
Nullable true
Discovery Fingerprint
h_dsc_fingerprint
The MD5 fingerprint of the overall item
Type VARCHAR
Size 32
Nullable true
HTTP Enabled
h_http_enabled
HTTP Enabled
Type VARCHAR
Size 4
Nullable true
Indexed 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 device
Type VARCHAR
Size 64
Nullable true
Model
h_model
The model number/name of this asset
Type VARCHAR
Size 64
Nullable true
Indexed true
Network IP Address
h_net_ip_address
The ip address(es) of this device
Type VARCHAR
Size 128
Nullable true
Physical Cores
h_physical_cores
The number of physical cores
Type INTEGER
Nullable true
Indexed true
Physical CPUs
h_physical_cpus
The number of physical CPUs
Type INTEGER
Nullable true
Indexed true
Physical Disk Size
h_physical_disk_size
The Physical disk Size for this device
Type VARCHAR
Size 16
Nullable true
Power Supply Count
h_power_supply_count
The power supply count for the asset
Type INTEGER
Nullable true
Indexed true
Serial Number
h_serial_number
The serial number for this asset
Type VARCHAR
Size 128
Nullable true
SSH Enabled
h_ssh_enabled
SSH Enabled
Type VARCHAR
Size 4
Nullable true
Indexed true
Telnet Enabled
h_telnet_enabled
Telnet Enabled
Type VARCHAR
Size 4
Nullable true
Indexed true
The device version
h_net_device_version
The device version
Type VARCHAR
Size 64
Nullable true
Indexed true
Username
h_username
Username
Type VARCHAR
Size 32
Nullable true
Indexed true
Watts
h_watts
Watts
Type VARCHAR
Size 16
Nullable true
Indexed true
Weight
h_weight
The asset weight
Type VARCHAR
Size 32
Nullable true
Indexed true
In This Document