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

CMDB Assets

  • Article
  • 7 minutes to read

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
Type INTEGER
Nullable true
Actual Retired Date
h_actual_retired_date
 The actual date this asset was retired from service
Type DATETIME
Nullable true
Annual Maintenance Review Data
h_annual_maintenance_review_date
 The asset annual maintenance review date
Type DATETIME
Nullable true
Indexed true
Asset ID
h_pk_asset_id
 Unique record identifier
Type VARCHAR
Size 32
Nullable false
Primary Key true
One to Many
AssetsInstalledSoftware
h_cmdb_assets_installed_software.h_fk_asset_id
Asset Substate Name
h_substate_name
 Provide a more specific description of the asset state
Type VARCHAR
Size 64
Nullable true
Asset Tag
h_asset_tag
 Holds asset/tag barcode number used for the purpose of tracking financial assets
Type VARCHAR
Size 64
Nullable true
Asset Tag ID
h_tag_id
 Hardware Asset Tag ID
Type VARCHAR
Size 64
Nullable true
Indexed true
Asset Tag MAC Address
h_tag_mac
 Hardware Asset Tag MAC Address
Type VARCHAR
Size 64
Nullable true
Indexed true
Asset Tag Parent Location
h_tag_location
 Hardware Asset Tag Parent Location
Type VARCHAR
Size 64
Nullable true
Indexed true
Asset Tag Source
h_tag_source
 Hardware Asset Tag Source
Type VARCHAR
Size 64
Nullable true
Indexed true
Availability State
h_availability_state
 -1 = value not set, 0 = N/A, 1 = Available, 2 = Impacted, 3 = Unavailable
Type INTEGER
Nullable true
Beneficiary
h_beneficiary
 The beneficary for this asset
Type VARCHAR
Size 64
Nullable true
Indexed true
Booking
h_booking
 The booking status of the asset: -1 = value not set, 0 = Available, 1 = Not Available, 2 = Booked
Type VARCHAR
Size 32
Nullable true
Indexed true
Building
h_building
 The building this asset is located in
Type VARCHAR
Size 32
Nullable true
Indexed true
Class
h_class
 The class of asset this is. See asset classes
Type VARCHAR
Size 32
Nullable true
Indexed true
Company ID
h_company_id
 The id of the company for this asset
Type VARCHAR
Size 255
Nullable true
Company Name
h_company_name
 The name of the company for this asset
Type VARCHAR
Size 255
Nullable true
Indexed true
Cost
h_cost
 The price paid for this asset
Type DECIMAL
Precision 20
Scale 2
Nullable true
Cost Center
h_cost_center
 The cost center this asset should be attributed to
Type VARCHAR
Size 64
Nullable true
Indexed true
Country
h_country
 The country this item is located in
Type VARCHAR
Size 32
Nullable true
Indexed true
Creation date
h_created_date
 The date this asset was created
Nullable true
Type DATETIME
Department
h_department_name
 The department name the asset belongs to
Type VARCHAR
Size 128
Nullable true
Indexed true
Depreciation Method
h_deprec_method
 -1 = value not set,, 0 = None, 1 = straight line, 2 = reducing balance
Type INTEGER
Nullable true
Depreciation Start
h_deprec_start
 The date that depreciation calculations started on this asset
Type DATETIME
Nullable true
Indexed true
Depreciation Value
h_deprec_value
 About to depreciate per period, depends on depreciation mode
Type DECIMAL
Precision 20
Scale 2
Nullable true
Description
h_description
 The description for this asset
Type VARCHAR
Size 255
Nullable true
Disposal Code
h_disposal_code
 The asset disposal code
Type VARCHAR
Size 128
Nullable true
Indexed true
Disposal Price
h_disposal_price
 The value of the asset at disposal
Type DECIMAL
Precision 20
Scale 2
Nullable true
Disposal Reason
h_disposal_reason
 The reason this asset has been disposed
Type VARCHAR
Size 500
Nullable true
External Asset Reference
h_external_id
 The asset external reference
Type VARCHAR
Size 64
Nullable true
Indexed true
External Asset Source
h_external_source
 The source of the external asset reference
Type VARCHAR
Size 64
Nullable true
Indexed true
Floor
h_floor
 The floor this asset is located on
Type VARCHAR
Size 32
Nullable true
Indexed true
Geographical Location
h_geo_location
 The GEO location this asset can be found at
Type VARCHAR
Size 32
Nullable true
Indexed true
Invoice Number
h_invoice_number
 The suppliers invoice number for this asset
Type VARCHAR
Size 32
Nullable true
Indexed true
Last Audited Date
h_last_audited_date
 The last audited date
Type DATETIME
Nullable true
Indexed true
Last Updated
h_last_updated
 The date/time this record was last updated
Type DATETIME
Nullable true
Last Updated By
h_last_updated_by
 The URN of the user that updated this record last
Type VARCHAR
Size 64
Nullable true
Location
h_location
 Freeform location information
Type VARCHAR
Size 100
Nullable true
Location Type
h_location_type
 -1=value not set, 0=physical location, 1=mobile-person, 2-mobile-vehicle
Type INTEGER
Nullable true
Indexed true
Maintenance Cost
h_maintenance_cost
 The maintenance cost for this asset
Type DECIMAL
Precision 20
Scale 2
Nullable true
Maintenance Notice Period
h_maintenance_notice_period
 The asset maintenance notice period
Type DATETIME
Nullable true
Indexed true
Maintenance Reference
h_maintenance_ref
 The maintenance reference number for this asset
Type VARCHAR
Size 8
Nullable true
Indexed true
Name
h_name
 The display name for this asset
Type VARCHAR
Size 128
Nullable true
Indexed true
Notes
h_notes
 Notes for this asset
Type LONGTEXT
Nullable true
Operational State
h_operational_state
 -1=value not set, 0=operational, 1=pre-production, 2=retired
Type INTEGER
Nullable true
Indexed true
Order Date
h_order_date
 The date the asset was ordered
Type DATETIME
Nullable true
Order Number
h_order_number
 The purchase order number used when purchasing this asset
Type VARCHAR
Size 32
Nullable true
Indexed true
Owned By
h_owned_by
 The URN of the user that has been assigned as the owner of the device
Type VARCHAR
Size 191
Nullable true
Indexed true
Owned By Name
h_owned_by_name
 The display name for the assigned owner
Type VARCHAR
Size 64
Nullable true
Product ID
h_product_id
 The product id for this asset
Type VARCHAR
Size 32
Nullable true
Purpose
h_purpose
 The purpose of the asset
Type LONGTEXT
Nullable true
Rack
h_rack
 The rack this asset is put in. This property is only used for servers in a rack
Type VARCHAR
Size 128
Nullable true
Indexed true
Received Date
h_received_date
 The date this asset was received from the supplier
Type DATETIME
Nullable true
Record State
h_record_state
 -1 = value not set, 0 = current, 1 = active, 2 = archived
Type INTEGER
Nullable true
Indexed true
Residual Value
h_residual_value
 The current residual value, caclulated by daily consolidation process
Type DECIMAL
Precision 20
Scale 2
Nullable true
Room
h_room
 The room this asser is located in
Type VARCHAR
Size 32
Nullable true
Indexed true
Scheduled Retire Date
h_scheduled_retire_date
 The date we expect this asset to be retired from service
Type DATETIME
Nullable true
Indexed true
Site
h_site
 The site this asset is located on
Type VARCHAR
Size 128
Nullable true
Indexed true
Static
h_static
 Tell if the asset location is static: -1 = value not set, 0 = Yes, 1 = No
Type VARCHAR
Size 4
Nullable true
Indexed true
Supplier Contract
h_supplier_contract
 The reference to the asset supplier contract
Type VARCHAR
Size 128
Nullable true
Indexed true
Supplier ID
h_supplier_id
 The supplier this asset was purchased from
Type VARCHAR
Size 64
Nullable true
Supported By
h_supported_by
 Free form text
Type VARCHAR
Size 64
Nullable true
Termination Period
h_maintenance_termination_period
 The asset termination period for maintenance
Type DATETIME
Nullable true
Indexed true
Type
h_type
 The type of asset this is. (h_cmdb_asset_types)
Type VARCHAR
Size 32
Nullable true
Indexed true
Many to One
AssetsTypes
h_cmdb_asset_types.h_pk_type_id
U Height
h_u_height
 The U Height of the server inside the rack. This property is only used for servers in a rack
Type VARCHAR
Size 64
Nullable true
Indexed true
U Position
h_u_position
 The U Position of the server inside the rack. This property is only used for servers in a rack
Type VARCHAR
Size 64
Nullable true
Indexed true
Used By
h_used_by
 The URN of the user/customer/department that has been assigned as the user of the device
Type VARCHAR
Size 191
Nullable true
Indexed true
Used By Name
h_used_by_name
 The display name for the assigned user
Type VARCHAR
Size 64
Nullable true
Version
h_version
 Default value = 1
Type VARCHAR
Size 16
Nullable true
Indexed true
Warranty Expires
h_warranty_expires
 The date.time the warranty on this asset expires
Type DATETIME
Nullable true
Warranty Start
h_warranty_start
 The date.time the warranty on this asset starts
Type DATETIME
Nullable true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document