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

System Assets

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