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

Entity Details: Asset

Description

This defines an asset entity

Details

  • Application Reference: com.hornbill.servicemanager
  • Table: h_cmdb_assets
  • Display Name: Asset

Entity Options

  • Enable Webhooks: true
  • Visible To Reporting: false (default)
  • Enable Business Rules: false (default)
  • Disable Direct Access: false (default)

Entity Name List

  • ID Column: h_pk_asset_id
  • Filter: No filter
  • Columns:
    • h_name

Access Control

No access controls have been defined.

Entity Access Control

  • Privilege Level: none

No entity operation access controls have been defined.

Search and Browse Control

Filter

No search filter has been defined.

Searchable Columns

  • h_pk_asset_id
  • h_class
  • h_name
  • h_type
  • h_substate_id
  • h_substate_name
  • h_availability_state
  • h_asset_tag
  • h_record_state

Result Columns

  • h_pk_asset_id
  • h_asset_prefix
  • h_record_state
  • h_substate_id
  • h_substate_name
  • h_version
  • h_class
  • h_type
  • h_name
  • h_description
  • h_used_by
  • h_used_by_name
  • h_owned_by
  • h_owned_by_name
  • h_created_date
  • h_last_updated
  • h_last_updated_by
  • h_operational_state
  • h_availability_state
  • h_purpose
  • h_location_type
  • h_location
  • h_country
  • h_site
  • h_site_id
  • h_building
  • h_floor
  • h_room
  • h_geo_location
  • h_cost
  • h_order_number
  • h_invoice_number
  • h_supplier_id
  • h_product_id
  • h_order_date
  • h_received_date
  • h_cost_center
  • h_acq_method
  • h_warranty_expires
  • h_supported_by
  • h_scheduled_retire_date
  • h_actual_retired_date
  • h_disposal_reason
  • h_disposal_price
  • h_beneficiary
  • h_deprec_method
  • h_deprec_start
  • h_deprec_value
  • h_residual_value
  • h_rack
  • h_u_position
  • h_u_height
  • h_asset_tag
  • h_external_id
  • h_external_source
  • h_tag_id
  • h_tag_source
  • h_tag_mac
  • h_tag_location
  • h_booking
  • h_department_id
  • h_department_name
  • h_static
  • h_supplier_contract
  • h_maintenance_notice_period
  • h_maintenance_termination_period
  • h_annual_maintenance_review_date
  • h_disposal_code
  • h_last_audited_date

Free Text Index

Free text search index is not enabled for this entity.

File Attachment Store

  • Store ID: fs_entity
  • Timeout: PT10S
  • Key Expression: Not specified

Activity Stream

  • Visibility: public
  • Record Display Name: {%h_name%}
  • Activity Stream Reference Column: h_activity_stream_id
  • Contact Reference Column: none
  • Access Token Timeout: none

Data Change Log

  • Data Change Log Table: h_sys_audit_trail

Data Change Log Columns

  • h_warranty_start
  • h_warranty_expires
  • h_version
  • h_used_by_name
  • h_used_by
  • h_type
  • h_supported_by
  • h_supplier_id
  • h_site_id
  • h_site
  • h_company_id
  • h_scheduled_retire_date
  • h_room
  • h_residual_value
  • h_record_state
  • h_received_date
  • h_product_id
  • h_pk_asset_id
  • h_owned_by_name
  • h_owned_by
  • h_order_number
  • h_order_date
  • h_operational_state
  • h_name
  • h_maintenance_ref
  • h_maintenance_cost
  • h_location_type
  • h_location
  • h_invoice_number
  • h_image
  • h_idx_ref
  • h_geo_location
  • h_floor
  • h_disposal_reason
  • h_disposal_price
  • h_description
  • h_deprec_value
  • h_deprec_start
  • h_deprec_method
  • h_created_date
  • h_country
  • h_cost_center
  • h_cost
  • h_class
  • h_building
  • h_beneficiary
  • h_asset_tag
  • h_actual_retired_date
  • h_acq_method
  • h_rack
  • h_u_position
  • h_u_height
  • h_department_name
  • h_booking
  • h_static
  • h_supplier_contract
  • h_maintenance_notice_period
  • h_maintenance_termination_period
  • h_annual_maintenance_review_date
  • h_disposal_code
  • h_purpose
  • h_substate_name
  • h_last_audited_date

Entity Relationships

One-to-Many

Name Related Entity Reference Key Foreign Key Mandatory Managed
Attachment Attachment h_entity_id h_pk_asset_id false true
AssetsInstalledSoftware AssetsInstalledSoftware h_fk_asset_id h_pk_asset_id false true

Many-to-One

Name Related Entity Reference Key Foreign Key Mandatory Managed Mapped Values
AssetAssetsTypesRelationship AssetsTypes h_pk_type_id h_type true true No mapped values defined

Dynamic One-to-One

Name Dynamic Value Column Foreign Key Related Entities
AssetClass h_class h_pk_asset_id
Dynamic ValueReference KeyEntity NameManaged
basich_pk_asset_idAssetsBasictrue
computerh_pk_asset_idAssetsComputertrue
computerPeripheralh_pk_asset_idAssetsComputerPeripheraltrue
mobileDeviceh_pk_asset_idAssetsMobileDevicetrue
networkDeviceh_pk_asset_idAssetsNetworkDevicetrue
printerh_pk_asset_idAssetsPrintertrue
softwareh_pk_asset_idAssetsSoftwaretrue
telecomsh_pk_asset_idAssetsTelecomstrue
systemh_pk_asset_idAssetsSystemtrue
dataProcessingRecordh_pk_asset_idAssetsDataProcessingRecordtrue
In This Document