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

Connect an AI assistant

Your AI assistant can read this documentation directly, so it answers from the current content instead of guessing. Add one of the servers below to your client — they use the Model Context Protocol (MCP). Each one covers a different body of content, so add the one you need.

The catalog did not load. Refresh the page to try again.

Loading…

How can we help?

{{docApp.searchError}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

 {{docApp.currentResultsSearchText}}  in {{docApp.searchFilterBySpecificBookTitle}}
Found {{docApp.searchResponse.totalResultsAvailable}} matches. Showing the top {{docApp.searchResponse.results ? docApp.searchResponse.results.length : 0}}. Use a more specific search to further narrow down the results.
No documentation pages match this search, so all content types are shown. Most matches are in {{docApp.searchDocTypeRescue.best.name}}.
There is no book with the ID "{{docApp.searchBookRescue.bid}}", so the book filter from this link was ignored and results from all books are shown.

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

  • {{resultItem.title}} {{resultItem.matchedBy === 'semantic' ? 'semantic' : (resultItem.matchedBy === 'both' ? 'keyword + semantic' : 'keyword')}}

    {{resultItem.url}}

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

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

CMDB Computer Assets

  • Article
  • 9 minutes to read

Details

Table ID: h_cmdb_assets_computer

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

Table Attributes

Name Value
Primary Key h_pk_asset_id

Columns

Name & ID Description Column Attributes Relationships
Assset 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
BIOS Manufacturer
h_bios_manufacturer
 The BIOS manufacturer
Type VARCHAR
Size 64
Nullable true
Indexed true
BIOS Name
h_bios_name
 The BIOS name
Type VARCHAR
Size 64
Nullable true
BIOS Release Date
h_bios_release_date
 The BIOS release date
Type DATETIME
Nullable true
BIOS Serial Number
h_bios_serial_number
 The BIOS serial number
Type VARCHAR
Size 128
Nullable true
Indexed true
BIOS Version
h_bios_version
 The BIOS version
Type VARCHAR
Size 32
Nullable true
CPU Clock Speed
h_cpu_clock_speed
 The CPU Clock speed
Type VARCHAR
Size 32
Nullable true
CPU Information
h_cpu_info
 Informaiton about the CPU in this computer
Type VARCHAR
Size 64
Nullable true
Disaster Recovery
h_disaster_recovery
 There is a disaster recovery system for the asset (Yes, No)
Type VARCHAR
Size 4
Nullable true
Indexed true
Discovery Configuration Fingerprint
h_dsc_cf_fingerprint
 The MD5 fingerprint of the overall computer configuration
Type VARCHAR
Size 32
Nullable true
Discovery First Discovered
h_dsc_first_discovered
 The date/time the computer was first discovered
Type DATETIME
Nullable true
Discovery Hardware Fingerprint
h_dsc_hw_fingerprint
 The MD5 fingerprint of the hardware configuraiton
Type VARCHAR
Size 32
Nullable true
Discovery Last Changed
h_dsc_last_changed
 The date/time the computer configuration was last detected
Type DATETIME
Nullable true
Indexed true
Discovery Last Discovered
h_dsc_last_discovered
 The date/time the computer was last discovered
Type DATETIME
Nullable true
Discovery Network Fingerprint
h_dsc_net_fingerprint
 The MD5 fingerprint of the network configuraiton
Type VARCHAR
Size 32
Nullable true
Discovery OS Fingerprint
h_dsc_os_fingerprint
 The MD5 fingerprint of the operating system configuraiton
Type VARCHAR
Size 32
Nullable true
Discovery SIID
h_dsc_siid
 The ID of the Site Integration Server that last discovered this computer
Type INTEGER
Nullable true
Indexed 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 computer
Type INTEGER
Nullable true
Indexed true
Environment
h_environment
 The asset environment (Live, Test, Development, Production)
Type VARCHAR
Size 64
Nullable true
Indexed 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 10
h_custom_ext_char10
 Extended Custom Varchar 10
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 11
h_custom_ext_char11
 Extended Custom Varchar 11
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 12
h_custom_ext_char12
 Extended Custom Varchar 12
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 13
h_custom_ext_char13
 Extended Custom Varchar 13
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 14
h_custom_ext_char14
 Extended Custom Varchar 14
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 15
h_custom_ext_char15
 Extended Custom Varchar 15
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 16
h_custom_ext_char16
 Extended Custom Varchar 16
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 17
h_custom_ext_char17
 Extended Custom Varchar 17
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 18
h_custom_ext_char18
 Extended Custom Varchar 18
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 19
h_custom_ext_char19
 Extended Custom Varchar 19
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 20
h_custom_ext_char20
 Extended Custom Varchar 20
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
Ext.Custom Varchar 9
h_custom_ext_char9
 Extended Custom Varchar 9
Type VARCHAR
Size 255
Nullable true
Last Logged On
h_last_logged_on
 The date/time the computer was used by someone to log on to the network
Type DATETIME
Nullable true
Last Logged On User
h_last_logged_on_user
 The user who last logged onto the computer
Type VARCHAR
Size 100
Nullable true
Last Patch Date
h_last_patch_date
 The last patch date
Type DATETIME
Nullable true
Indexed true
Last Sync
h_last_sync
 Last Sync
Type DATETIME
Nullable true
Indexed true
Logical CPUs
h_logical_cpus
 The number of logical CPUs
Type INTEGER
Nullable true
MAC Address
h_mac_address
 The MAC Address for this computer
Type VARCHAR
Size 32
Nullable true
Indexed true
Manufacturer
h_manufacturer
 The company that makes this computer
Type VARCHAR
Size 64
Nullable true
Max Memory Capacity
h_max_memory_capacity
 The BIOS memory capacity
Type VARCHAR
Size 32
Nullable true
Memory Info
h_memory_info
 Information about the memory in this computer
Type VARCHAR
Size 64
Nullable true
Model
h_model
 The model number/name of this computer
Type VARCHAR
Size 64
Nullable true
Monitoring
h_monitoring
 There is a monitoring system for the asset (Yes, No)
Type VARCHAR
Size 4
Nullable true
Indexed true
Monitoring Software
h_monitoring_software
 The asset monitoring software
Type VARCHAR
Size 255
Nullable true
Indexed true
Network Computer Name
h_net_computer_name
 The name/hostname of the computer
Type VARCHAR
Size 128
Nullable true
Indexed true
Network IP Address
h_net_ip_address
 The ip address(es) of this computer
Type VARCHAR
Size 128
Nullable true
Indexed true
Network Name
h_net_name
 The Network name
Type VARCHAR
Size 64
Nullable true
Indexed true
Network Windows Domain
h_net_win_domain
 The windows domain this computer is part of
Type VARCHAR
Size 32
Nullable true
Network Windows Domain Role
h_net_win_dom_role
 The role within the windows domain this computer plays
Type VARCHAR
Size 32
Nullable true
Next Patch Date
h_next_patch_date
 The next patch date
Type DATETIME
Nullable true
Indexed true
Number of 1 GbE MGMT Ports
h_number_1gbe_mgmt_ports
 The number of 1 GbE MGMT Ports
Type INTEGER
Nullable true
Number of 1 GbE Ports
h_number_1gbe_ports
 The number of 1 GbE Ports
Type VARCHAR
Size 8
Nullable true
Indexed true
Number of 10 GbE Ports
h_number_10gbe_ports
 The number of 10 GbE Ports
Type VARCHAR
Size 8
Nullable true
Indexed true
Number Of Memory Slots
h_number_memory_slots
 The number of memory slots
Type INTEGER
Nullable true
Number of Power Ports
h_number_power_ports
 The number of power ports
Type INTEGER
Size 8
Nullable true
Optical Drive
h_optical_drive
 The Optical Drive for this computer
Type VARCHAR
Size 64
Nullable true
OS Description
h_os_description
 Text description of the operating system running on this computer
Type VARCHAR
Size 100
Nullable true
OS Expiry Date
h_os_expiry_date
 The Operating System Expiry Date
Type DATETIME
Nullable true
Indexed true
OS Registered To
h_os_registered_to
 The name of the organisation/user the os reports being registered to
Type VARCHAR
Size 100
Nullable true
OS Serial Number
h_os_serial_number
 The serial number of this operating system
Type VARCHAR
Size 128
Nullable true
Indexed true
OS Service Pack
h_os_service_pack
 The Operating System service pack
Type VARCHAR
Size 32
Nullable true
Indexed true
OS Type
h_os_type
 The type of the operating system, WINNT, Linux, OSX etc…
Type VARCHAR
Size 32
Nullable true
OS Version
h_os_version
 The version of the operating system
Type VARCHAR
Size 32
Nullable true
Physical Cores
h_physical_cores
 The number of physical cores
Type INTEGER
Nullable true
Physical CPUs
h_physical_cpus
 The number of physical CPUs
Type INTEGER
Nullable true
Physical Disk Size
h_physical_disk_size
 The Physical Disk Size for this computer
Type VARCHAR
Size 16
Nullable true
Private IP Address
h_private_ip_address
 The asset private IP address
Type VARCHAR
Size 64
Nullable true
Indexed true
PSU1 Serial
h_psu1_serial
 PSU1 Serial
Type VARCHAR
Size 128
Nullable true
Indexed true
PSU2 Serial
h_psu2_serial
 PSU2 Serial
Type VARCHAR
Size 128
Nullable true
Indexed true
Public IP Address
h_public_ip_address
 The asset public IP address
Type VARCHAR
Size 64
Nullable true
Indexed true
Serial Number
h_serial_number
 The serial number/tagID number of this computer
Type VARCHAR
Size 128
Nullable true
Indexed true
Subnet Mask
h_subnet_mask
 The Subnet Mask
Type VARCHAR
Size 16
Nullable true
VM Clustered
h_vm_yn_clustered
 Yes or No , If server is part of a cluster
Type VARCHAR
Size 16
Nullable true
VM Clustered Id
h_vm_clusterid
 Name or Identfication of cluster
Type VARCHAR
Size 128
Nullable true
VM criticality
h_vm_criticality
 how critical to business operations
Type VARCHAR
Size 128
Nullable true
VM Disk Count
h_vm_disk_count
 Number of physical disks
Type INTEGER
Size 11
Nullable true
VM Generation
h_vm_generation
 The Versions of VM
Type VARCHAR
Size 16
Nullable true
VM Impact
h_vm_impact_level
 impact on business when down
Type VARCHAR
Size 128
Nullable true
VM Options
h_vm_size_options
 The sizes and options for the hosted virtual machines to run your apps and workloads
Type VARCHAR
Size 128
Nullable true
VM Resource Group
h_vm_resourcegroup
 Logical containers that you use to group related resources in a subscription
Type VARCHAR
Size 128
Nullable true
VM Server Type
h_vm_servertype
 To identify virtual or physical server
Type VARCHAR
Size 8
Nullable true
VM Subnet/Vlan
h_vm_vlanaddress
 Subnet or Vlan address
Type VARCHAR
Size 128
Nullable true
VM Subscription
h_vm_subscription
 A logical container for VM server resources
Type VARCHAR
Size 128
Nullable true
VM Urgency
h_vm_urgency_level
 urgency treatment level when down
Type VARCHAR
Size 128
Nullable true
Watts
h_watts
 Watts
Type VARCHAR
Size 16
Nullable true
Indexed true
wMAC Address
h_wmac_address
 The wMAC Address for this computer
Type VARCHAR
Size 32
Nullable true
Indexed true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document