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

CMDB Asset Types

Details

Table ID: h_cmdb_asset_types

Stores information about Asset Types

Table Attributes

Name Value
Primary Key h_pk_type_id

Columns

Name & ID Description Column Attributes Relationships
Additional Properties
h_additional_properties_mandatory
The mandatory additional properties
Type LONGTEXT
Nullable true
Additional Properties Summary
h_additional_properties_summary
The additional properties to display in the asset summary
Type LONGTEXT
Nullable true
Archived
h_archived
The type can be archived (1) and will be hidden from the asset ui navigation tree in the user experience. Asset managers will be able to see archived types via a ui switch
Type INTEGER
Nullable true
Asset Prefix
h_asset_prefix
This column value will be used to determine the trailing characters of the Asset Id.
Type VARCHAR
Size 3
Nullable true
Indexed true
Auto Generate Name (Flag)
h_auto_generate_name
Flag to determine whether to automatically set the 'Name' attribute with the generated Asset Id.
Type INTEGER
Nullable true
Indexed true
Category ID
h_fk_category_id
The id of the Asset Category
Type INTEGER
Nullable true
Class
h_class
The class this is a type of
Type VARCHAR
Size 32
Nullable true
Indexed true
Common Properties
h_common_properties_visibility
The visibility of the common properties (i.e. the properties common to all asset type, independent from the class it belong to)
Type LONGTEXT
Nullable true
Description
h_description
Type description
Type VARCHAR
Size 150
Nullable true
General Properties
h_general_properties_mandatory
The mandatory general properties
Type LONGTEXT
Nullable true
General Properties Summary
h_general_properties_summary
The general properties to display in the asset summary
Type LONGTEXT
Nullable true
Image
h_icon
The location of the customer uploaded type image
Type VARCHAR
Size 255
Nullable true
Image
h_icon_name
The name of the customer uploaded type image
Type VARCHAR
Size 255
Nullable true
Name
h_name
Reference to the URN of the object creating the relationship to (URN to assets will be the entity URN)
Type VARCHAR
Size 64
Nullable true
Indexed true
Partition ID
h_fk_partition_id
Partition identifier that type was created for
Type VARCHAR
Size 32
Nullable true
Indexed true
Preferred SLA
h_fk_slaid
Prefered sla to use for assets of this type
Type VARCHAR
Size 100
Nullable true
Specific Properties
h_specific_properties_visibility
The visibility of the properties specific for the class the asset type belongs to
Type LONGTEXT
Nullable true
Type ID
h_pk_type_id
The primary key for this type
Type INTEGER
Nullable false
Primary Key true
One to Many
h_cmdb_assets.h_type
h_itsm_attachments.h_entity_id
UI Configuration
h_ui_configuration
Settings for display of assets of this type
Type LONGTEXT
Nullable true
UI Icon
h_ui_icon
The reference of the type icon used in navigation and lists (new icons)
Type VARCHAR
Size 128
Nullable true
In This Document