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 Computer Assets

  • Article
  • 10 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 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
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