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…
{{server.name}}
{{server.summary}}
{{server.documentCount.toLocaleString()}} pages Not published to this site
- Name
-
{{server.name}} - URL
-
{{mcpServerUrl(server.path)}}
| Tool | What it does |
|---|---|
{{tool.name}} |
{{part.text}}{{part.text}} |
How can we help?
{{docApp.searchError}}
{{product.name}}
Searching in {{docApp.searchFilterBySpecificBookTitle}}
Searching for:
{{docApp.searchResultFilteredItems.length}} results for:
{{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}}
{{group.title || group.id}}
{{group.description}}
Details
Table ID: h_cmdb_assets
This table holds the Assets records in the system.
Table Attributes
| Name | Value |
|---|---|
| Primary Key | h_pk_asset_id |
Columns
| Name & ID | Description | Column Attributes | Relationships | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Acquired Method
h_acq_method |
-1=value not set, 0=none, 1=purchased, 2=leased, 3=loaned, 4=rented, 5=personal |
|
|
||||||||
|
Actual Retired Date
h_actual_retired_date |
The actual date this asset was retired from service |
|
|
||||||||
|
Annual Maintenance Review Data
h_annual_maintenance_review_date |
The asset annual maintenance review date |
|
|
||||||||
|
Asset ID
h_pk_asset_id |
Unique record identifier |
|
One to Many
h_itsm_attachments.h_entity_id
h_cmdb_assets_installed_software.h_fk_asset_id
|
||||||||
|
Asset State
h_record_state |
-1 = value not set, 0 = current, 1 = active, 2 = archived |
|
|
||||||||
|
Asset Substate
h_substate_name |
Provide a more specific description of the asset state |
|
|
||||||||
|
Asset Tag
h_asset_tag |
Holds asset/tag barcode number used for the purpose of tracking financial assets |
|
|
||||||||
|
Asset Tag ID
h_tag_id |
Hardware Asset Tag ID |
|
|
||||||||
|
Asset Tag MAC Address
h_tag_mac |
Hardware Asset Tag MAC Address |
|
|
||||||||
|
Asset Tag Parent Location
h_tag_location |
Hardware Asset Tag Parent Location |
|
|
||||||||
|
Asset Tag Source
h_tag_source |
Hardware Asset Tag Source |
|
|
||||||||
|
Availability State
h_availability_state |
-1 = value not set, 0 = N/A, 1 = Available, 2 = Impacted, 3 = Unavailable |
|
|
||||||||
|
Beneficiary
h_beneficiary |
The beneficary for this asset |
|
|
||||||||
|
Booking
h_booking |
The booking status of the asset: -1 = value not set, 0 = Available, 1 = Not Available, 2 = Booked |
|
|
||||||||
|
Building
h_building |
The building this asset is located in |
|
|
||||||||
|
Class
h_class |
The class of asset this is. See asset classes |
|
|
||||||||
|
Company ID
h_company_id |
The id of the company for this asset |
|
|
||||||||
|
Company Name
h_company_name |
The name of the company for this asset |
|
|
||||||||
|
Copied From Asset ID
h_copied_from_asset_id |
The ID of the source asset this record was duplicated from. Null if the asset was not created via duplication. |
|
|
||||||||
|
Cost
h_cost |
The price paid for this asset |
|
|
||||||||
|
Cost Center
h_cost_center |
The cost center this asset should be attributed to |
|
|
||||||||
|
Country
h_country |
The country this item is located in |
|
|
||||||||
|
Creation date
h_created_date |
The date this asset was created |
|
|
||||||||
|
Custom Date 1
h_custom_date1 |
Custom Date 1 |
|
|
||||||||
|
Custom Date 10
h_custom_date10 |
Custom Date 10 |
|
|
||||||||
|
Custom Date 11
h_custom_date11 |
Custom Date 11 |
|
|
||||||||
|
Custom Date 12
h_custom_date12 |
Custom Date 12 |
|
|
||||||||
|
Custom Date 13
h_custom_date13 |
Custom Date 13 |
|
|
||||||||
|
Custom Date 14
h_custom_date14 |
Custom Date 14 |
|
|
||||||||
|
Custom Date 15
h_custom_date15 |
Custom Date 15 |
|
|
||||||||
|
Custom Date 2
h_custom_date2 |
Custom Date 2 |
|
|
||||||||
|
Custom Date 3
h_custom_date3 |
Custom Date 3 |
|
|
||||||||
|
Custom Date 4
h_custom_date4 |
Custom Date 4 |
|
|
||||||||
|
Custom Date 5
h_custom_date5 |
Custom Date 5 |
|
|
||||||||
|
Custom Date 6
h_custom_date6 |
Custom Date 6 |
|
|
||||||||
|
Custom Date 7
h_custom_date7 |
Custom Date 7 |
|
|
||||||||
|
Custom Date 8
h_custom_date8 |
Custom Date 8 |
|
|
||||||||
|
Custom Date 9
h_custom_date9 |
Custom Date 9 |
|
|
||||||||
|
Custom Decimal 1
h_custom_dec1 |
Custom Decimal 1 (0.00) |
|
|
||||||||
|
Custom Decimal 10
h_custom_dec10 |
Custom Decimal 10 |
|
|
||||||||
|
Custom Decimal 11
h_custom_dec11 |
Custom Decimal 11 |
|
|
||||||||
|
Custom Decimal 12
h_custom_dec12 |
Custom Decimal 12 |
|
|
||||||||
|
Custom Decimal 13
h_custom_dec13 |
Custom Decimal 13 |
|
|
||||||||
|
Custom Decimal 14
h_custom_dec14 |
Custom Decimal 14 |
|
|
||||||||
|
Custom Decimal 15
h_custom_dec15 |
Custom Decimal 15 |
|
|
||||||||
|
Custom Decimal 2
h_custom_dec2 |
Custom Decimal 2 (0.00) |
|
|
||||||||
|
Custom Decimal 3
h_custom_dec3 |
Custom Decimal 3 (0.00) |
|
|
||||||||
|
Custom Decimal 4
h_custom_dec4 |
Custom Decimal 4 (0.00) |
|
|
||||||||
|
Custom Decimal 5
h_custom_dec5 |
Custom Decimal 5 (0.00) |
|
|
||||||||
|
Custom Decimal 6
h_custom_dec6 |
Custom Decimal 6 (0.00) |
|
|
||||||||
|
Custom Decimal 7
h_custom_dec7 |
Custom Decimal 7 (0.00) |
|
|
||||||||
|
Custom Decimal 8
h_custom_dec8 |
Custom Decimal 8 (0.00) |
|
|
||||||||
|
Custom Decimal 9
h_custom_dec9 |
Custom Decimal 9 |
|
|
||||||||
|
Custom Integer 1
h_custom_int1 |
Custom Integer 1 |
|
|
||||||||
|
Custom Integer 10
h_custom_int10 |
Custom Integer 10 |
|
|
||||||||
|
Custom Integer 11
h_custom_int11 |
Custom Integer 11 |
|
|
||||||||
|
Custom Integer 12
h_custom_int12 |
Custom Integer 12 |
|
|
||||||||
|
Custom Integer 13
h_custom_int13 |
Custom Integer 13 |
|
|
||||||||
|
Custom Integer 14
h_custom_int14 |
Custom Integer 14 |
|
|
||||||||
|
Custom Integer 15
h_custom_int15 |
Custom Integer 15 |
|
|
||||||||
|
Custom Integer 2
h_custom_int2 |
Custom Integer 2 |
|
|
||||||||
|
Custom Integer 3
h_custom_int3 |
Custom Integer 3 |
|
|
||||||||
|
Custom Integer 4
h_custom_int4 |
Custom Integer 4 |
|
|
||||||||
|
Custom Integer 5
h_custom_int5 |
Custom Integer 5 |
|
|
||||||||
|
Custom Integer 6
h_custom_int6 |
Custom Integer 6 |
|
|
||||||||
|
Custom Integer 7
h_custom_int7 |
Custom Integer 7 |
|
|
||||||||
|
Custom Integer 8
h_custom_int8 |
Custom Integer 8 |
|
|
||||||||
|
Custom Integer 9
h_custom_int9 |
Custom Integer 9 |
|
|
||||||||
|
Custom Text 1
h_custom_text1 |
Custom Text 1 |
|
|
||||||||
|
Custom Text 2
h_custom_text2 |
Custom Text 2 |
|
|
||||||||
|
Custom Text 3
h_custom_text3 |
Custom Text 3 |
|
|
||||||||
|
Custom Text 4
h_custom_text4 |
Custom Text 4 |
|
|
||||||||
|
Custom Text 5
h_custom_text5 |
Custom Text 5 |
|
|
||||||||
|
Custom Varchar 1
h_custom_char1 |
Custom Varchar 1 |
|
|
||||||||
|
Custom Varchar 10
h_custom_char10 |
Custom Varchar 10 |
|
|
||||||||
|
Custom Varchar 11
h_custom_char11 |
Custom Varchar 11 |
|
|
||||||||
|
Custom Varchar 12
h_custom_char12 |
Custom Varchar 12 |
|
|
||||||||
|
Custom Varchar 13
h_custom_char13 |
Custom Varchar 13 |
|
|
||||||||
|
Custom Varchar 14
h_custom_char14 |
Custom Varchar 14 |
|
|
||||||||
|
Custom Varchar 15
h_custom_char15 |
Custom Varchar 15 |
|
|
||||||||
|
Custom Varchar 2
h_custom_char2 |
Custom Varchar 2 |
|
|
||||||||
|
Custom Varchar 3
h_custom_char3 |
Custom Varchar 3 |
|
|
||||||||
|
Custom Varchar 4
h_custom_char4 |
Custom Varchar 4 |
|
|
||||||||
|
Custom Varchar 5
h_custom_char5 |
Custom Varchar 5 |
|
|
||||||||
|
Custom Varchar 6
h_custom_char6 |
Custom Varchar 6 |
|
|
||||||||
|
Custom Varchar 7
h_custom_char7 |
Custom Varchar 7 |
|
|
||||||||
|
Custom Varchar 8
h_custom_char8 |
Custom Varchar 8 |
|
|
||||||||
|
Custom Varchar 9
h_custom_char9 |
Custom Varchar 9 |
|
|
||||||||
|
Department
h_department_name |
The department name the asset belongs to |
|
|
||||||||
|
Depreciation Frequency (Months)
h_deprec_freq |
Number of months between depreciation calculations - 1 to 12 |
|
|
||||||||
|
Depreciation Method
h_deprec_method |
-1 = value not set, 0 = None, 1 = straight line, 2 = reducing balance |
|
|
||||||||
|
Depreciation Start
h_deprec_start |
The date that depreciation calculations started on this asset |
|
|
||||||||
|
Depreciation Term (Months)
h_deprec_term |
Number of months to depreciate the asset over |
|
|
||||||||
|
Depreciation Value
h_deprec_value |
Amount to depreciate per period, depends on depreciation mode |
|
|
||||||||
|
Description
h_description |
The description for this asset |
|
|
||||||||
|
Disposal Code
h_disposal_code |
The asset disposal code |
|
|
||||||||
|
Disposal Price
h_disposal_price |
The value of the asset at disposal |
|
|
||||||||
|
Disposal Reason
h_disposal_reason |
The reason this asset has been disposed |
|
|
||||||||
|
External Asset Reference
h_external_id |
The asset external reference |
|
|
||||||||
|
External Asset Source
h_external_source |
The source of the external asset reference |
|
|
||||||||
|
Floor
h_floor |
The floor this asset is located on |
|
|
||||||||
|
Geographical Location
h_geo_location |
The GEO location this asset can be found at |
|
|
||||||||
|
Invoice Number
h_invoice_number |
The suppliers invoice number for this asset |
|
|
||||||||
|
Last Audited Date
h_last_audited_date |
The last audited date |
|
|
||||||||
|
Last Depreciation Date
h_deprec_date |
The last date that depreciation was calculated on this asset |
|
|
||||||||
|
Last Updated
h_last_updated |
The date/time this record was last updated |
|
|
||||||||
|
Last Updated By
h_last_updated_by |
The URN of the user that updated this record last |
|
|
||||||||
|
Location
h_site |
The location this asset is located on |
|
|
||||||||
|
Location Information
h_location |
Freeform location information |
|
|
||||||||
|
Location Type
h_location_type |
-1=value not set, 0=physical location, 1=mobile-person, 2-mobile-vehicle |
|
|
||||||||
|
Maintenance Cost
h_maintenance_cost |
The maintenance cost for this asset |
|
|
||||||||
|
Maintenance Notice Period
h_maintenance_notice_period |
The asset maintenance notice period |
|
|
||||||||
|
Maintenance Reference
h_maintenance_ref |
The maintenance reference number for this asset |
|
|
||||||||
|
Name
h_name |
The display name for this asset |
|
|
||||||||
|
Net Value
h_net_value |
The current value for this asset |
|
|
||||||||
|
Notes
h_notes |
Notes for this asset |
|
|
||||||||
|
Operational State
h_operational_state |
-1=value not set, 0=operational, 1=pre-production, 2=retired |
|
|
||||||||
|
Order Date
h_order_date |
The date the asset was ordered |
|
|
||||||||
|
Order Number
h_order_number |
The purchase order number used when purchasing this asset |
|
|
||||||||
|
Owned By
h_owned_by_name |
The display name for the assigned owner |
|
|
||||||||
|
Owned By (URN)
h_owned_by |
The URN of the user that has been assigned as the owner of the device |
|
|
||||||||
|
Partition ID
h_fk_partition_id |
Set to an asset partition - used to filter out assets by user and or role visibility |
|
|
||||||||
|
Preferred SLA
h_fk_slaid |
Prefered sla to use for assets of this type |
|
|
||||||||
|
Product ID
h_product_id |
The product id for this asset |
|
|
||||||||
|
Purpose
h_purpose |
The purpose of the asset |
|
|
||||||||
|
Rack
h_rack |
The rack this asset is put in. This property is only used for servers in a rack |
|
|
||||||||
|
Received Date
h_received_date |
The date this asset was received from the supplier |
|
|
||||||||
|
Residual Value
h_residual_value |
The minimum residual value of an asset after depreciation |
|
|
||||||||
|
Room
h_room |
The room this asser is located in |
|
|
||||||||
|
Scheduled Retire Date
h_scheduled_retire_date |
The date we expect this asset to be retired from service |
|
|
||||||||
|
Static
h_static |
Tell if the asset location is static: -1 = value not set, 0 = Yes, 1 = No |
|
|
||||||||
|
Supplier Contract
h_supplier_contract |
The reference to the asset supplier contract |
|
|
||||||||
|
Supplier ID
h_supplier_id |
The supplier this asset was purchased from |
|
|
||||||||
|
Supported By
h_supported_by |
Free form text |
|
|
||||||||
|
Termination Period
h_maintenance_termination_period |
The asset termination period for maintenance |
|
|
||||||||
|
Type
h_type |
The type of asset this is. (h_cmdb_asset_types) |
|
|||||||||
|
U Height
h_u_height |
The U Height of the server inside the rack. This property is only used for servers in a rack |
|
|
||||||||
|
U Position
h_u_position |
The U Position of the server inside the rack. This property is only used for servers in a rack |
|
|
||||||||
|
Used By
h_used_by_name |
The display name for the assigned user |
|
|
||||||||
|
Used By (URN)
h_used_by |
The URN of the user/customer/department that has been assigned as the user of the device |
|
|
||||||||
|
Version
h_version |
Default value = 1 |
|
|
||||||||
|
Warranty Expires
h_warranty_expires |
The date.time the warranty on this asset expires |
|
|
||||||||
|
Warranty Start
h_warranty_start |
The date.time the warranty on this asset starts |
|
|
- Version {{docApp.book.version}}
- Node {{docApp.node}} / {{docApp.build}}
In This Document