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

System Assets

  • Article
  • 6 minutes to read

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
Asset
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 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
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
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document