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

System Assets

Details

Table ID: h_cmdb_assets_system

Stores information about assets in the 'System' asset class

Table Attributes

Name Value
Primary Key h_pk_asset_id

Columns

Name & ID Description Column Attributes Relationships
Access request information
h_access_request_information
Access request information to the system
Type VARCHAR
Size 512
Nullable true
Indexed true
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
Associated database
h_associated_database
Any associated database
Type VARCHAR
Size 128
Nullable true
Indexed true
Authorising owner
h_authorising_owner
The URN of the authorising access owner
Type VARCHAR
Size 191
Nullable true
Authorising owner name
h_authorising_owner_name
The authorising access owner name
Type VARCHAR
Size 64
Nullable true
Indexed true
Authorising team
h_authorising_team
The ID of the authorising access team
Type VARCHAR
Size 160
Nullable true
Authorising team name
h_authorising_team_name
The authorising access team name
Type VARCHAR
Size 128
Nullable true
Indexed true
Business owner
h_business_owner
The URN of the business owner
Type VARCHAR
Size 191
Nullable true
Business owner name
h_business_owner_name
The business owner name
Type VARCHAR
Size 64
Nullable true
Indexed true
Citrix published
h_citrix_published
Whether the system is citrix published
Type INTEGER
Size 11
Nullable true
Cloud based
h_cloud_based
Whether the system is cloud based
Type INTEGER
Size 11
Nullable true
Criticality
h_criticality
The criticality of the system to the business
Type VARCHAR
Size 128
Nullable true
Indexed true
Discovery Fingerprint
h_dsc_fingerprint
The MD5 fingerprint of the overall item
Type VARCHAR
Size 32
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
In house
h_in_house
Whether the system is developed/owned in house
Type INTEGER
Size 11
Nullable true
Information owner
h_information_owner
The URN of the information owner
Type VARCHAR
Size 191
Nullable true
Information owner name
h_information_owner_name
The information owner name
Type VARCHAR
Size 64
Nullable true
Indexed true
License information
h_license_information
License information
Type VARCHAR
Size 512
Nullable true
Indexed true
Mobile app
h_mobile_app
Whether the system has a native mobile application
Type INTEGER
Size 11
Nullable true
Native client
h_native_client
Whether the system has a native client
Type INTEGER
Size 11
Nullable true
Out of hours WTC
h_out_of_hours_wtc
Working time calendar used to determine out of hours availability
Type VARCHAR
Size 64
Nullable true
Indexed true
Requires authorisation
h_requires_authorisation
Whether the system requires authorisation
Type INTEGER
Size 11
Nullable true
Requires elearning
h_requires_elearning
Whether the system requires elearning
Type INTEGER
Size 11
Nullable true
Supporting team
h_supporting_team
The ID of the supporting team
Type VARCHAR
Size 160
Nullable true
Supporting team name
h_supporting_team_name
The supporting team name
Type VARCHAR
Size 128
Nullable true
Indexed true
System Version
h_system_version
System version
Type VARCHAR
Size 16
Nullable true
Indexed true
Uses active directory
h_uses_active_directory
Uses active directory
Type INTEGER
Size 11
Nullable true
In This Document