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

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…

How can we help?

{{docApp.searchError}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

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

  1. {{book.title}}

CMDB Software Assets

  • Article
  • 5 minutes to read

Details

Table ID: h_cmdb_assets_software

Stores information about assets in the 'Software' asset class in the CMDB

Table Attributes

Name Value
Primary Key h_pk_asset_id

Columns

Name & ID Description Column Attributes Relationships
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
Discovery Fingerprint
h_dsc_fingerprint
 The MD5 fingerprint of the overall software item
Type VARCHAR
Size 32
Nullable true
Discovery SIID
h_dsc_siid
 The ID of the Site Integration Server that last discovered this computer
Type INTEGER
Nullable true
Indexed true
Discovery Source
h_dsc_source
 The id of the discovery profile used to discover this computer
Type INTEGER
Nullable true
Indexed true
Ext.Custom Date 1
h_custom_ext_date1
 Extended Custom Date 1
Type DATETIME
Nullable true
Ext.Custom Date 2
h_custom_ext_date2
 Extended Custom Date 2
Type DATETIME
Nullable true
Ext.Custom Date 3
h_custom_ext_date3
 Extended Custom Date 3
Type DATETIME
Nullable true
Ext.Custom Date 4
h_custom_ext_date4
 Extended Custom Date 4
Type DATETIME
Nullable true
Ext.Custom Date 5
h_custom_ext_date5
 Extended Custom Date 5
Type DATETIME
Nullable true
Ext.Custom Date 6
h_custom_ext_date6
 Extended Custom Date 6
Type DATETIME
Nullable true
Ext.Custom Date 7
h_custom_ext_date7
 Extended Custom Date 7
Type DATETIME
Nullable true
Ext.Custom Date 8
h_custom_ext_date8
 Extended Custom Date 8
Type DATETIME
Nullable true
Ext.Custom Decimal 1
h_custom_ext_dec1
 Extended Custom Decimal 1 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 2
h_custom_ext_dec2
 Extended Custom Decimal 2 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 3
h_custom_ext_dec3
 Extended Custom Decimal 3 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 4
h_custom_ext_dec4
 Extended Custom Decimal 4 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 5
h_custom_ext_dec5
 Extended Custom Decimal 5 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 6
h_custom_ext_dec6
 Extended Custom Decimal 6 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 7
h_custom_ext_dec7
 Extended Custom Decimal 7 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 8
h_custom_ext_dec8
 Extended Custom Decimal 8 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Integer 1
h_custom_ext_int1
 Extended Custom Integer 1
Type INTEGER
Nullable true
Ext.Custom Integer 2
h_custom_ext_int2
 Extended Custom Integer 2
Type INTEGER
Nullable true
Ext.Custom Integer 3
h_custom_ext_int3
 Extended Custom Integer 3
Type INTEGER
Nullable true
Ext.Custom Integer 4
h_custom_ext_int4
 Extended Custom Integer 4
Type INTEGER
Nullable true
Ext.Custom Integer 5
h_custom_ext_int5
 Extended Custom Integer 5
Type INTEGER
Nullable true
Ext.Custom Integer 6
h_custom_ext_int6
 Extended Custom Integer 6
Type INTEGER
Nullable true
Ext.Custom Integer 7
h_custom_ext_int7
 Extended Custom Integer 7
Type INTEGER
Nullable true
Ext.Custom Integer 8
h_custom_ext_int8
 Extended Custom Integer 8
Type INTEGER
Nullable true
Ext.Custom Text 1
h_custom_ext_text1
 Extended Custom Text 1
Type LONGTEXT
Nullable true
Ext.Custom Text 2
h_custom_ext_text2
 Extended Custom Text 2
Type LONGTEXT
Nullable true
Ext.Custom Text 3
h_custom_ext_text3
 Extended Custom Text 3
Type LONGTEXT
Nullable true
Ext.Custom Text 4
h_custom_ext_text4
 Extended Custom Text 4
Type LONGTEXT
Nullable true
Ext.Custom Varchar 1
h_custom_ext_char1
 Extended Custom Varchar 1
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 10
h_custom_ext_char10
 Extended Custom Varchar 10
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 11
h_custom_ext_char11
 Extended Custom Varchar 11
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 12
h_custom_ext_char12
 Extended Custom Varchar 12
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 13
h_custom_ext_char13
 Extended Custom Varchar 13
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 14
h_custom_ext_char14
 Extended Custom Varchar 14
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 15
h_custom_ext_char15
 Extended Custom Varchar 15
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 16
h_custom_ext_char16
 Extended Custom Varchar 16
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 17
h_custom_ext_char17
 Extended Custom Varchar 17
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 18
h_custom_ext_char18
 Extended Custom Varchar 18
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 19
h_custom_ext_char19
 Extended Custom Varchar 19
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 2
h_custom_ext_char2
 Extended Custom Varchar 2
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 20
h_custom_ext_char20
 Extended Custom Varchar 20
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 3
h_custom_ext_char3
 Extended Custom Varchar 3
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 4
h_custom_ext_char4
 Extended Custom Varchar 4
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 5
h_custom_ext_char5
 Extended Custom Varchar 5
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 6
h_custom_ext_char6
 Extended Custom Varchar 6
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 7
h_custom_ext_char7
 Extended Custom Varchar 7
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 8
h_custom_ext_char8
 Extended Custom Varchar 8
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 9
h_custom_ext_char9
 Extended Custom Varchar 9
Type VARCHAR
Size 255
Nullable true
First Discovered
h_dsc_first_discovered
 The date/time the computer was first discovered
Type DATETIME
Nullable true
Last Changed
h_dsc_last_changed
 The date/time the computer configuration was last detected
Type DATETIME
Nullable true
Indexed true
Last Discovered
h_dsc_last_discovered
 The date/time the computer was last discovered
Type DATETIME
Nullable true
License Cost
h_license_cost
 The cost of the license
Type DECIMAL
Precision 20
Scale 2
Nullable true
Indexed true
License Count
h_license_count
 The license count
Type INTEGER
Nullable true
License Expiry Date
h_license_expiry_date
 The date the license expires
Type DATETIME
Nullable true
Indexed true
License Key
h_license_key
 The asset license key
Type VARCHAR
Size 128
Nullable true
Indexed true
License Renewal Date
h_license_renewal_date
 The date the license has been renewed
Type DATETIME
Nullable true
Indexed true
License Start Date
h_license_start_date
 The date the license starts
Type DATETIME
Nullable true
Indexed true
License Type
h_license_type
 The type of license (Single User Licence, Named User Licence, Concurrent Licence, Per Device Licence, Optimizational based Licence, Transactional based Licence, Subscription based Licence)
Type VARCHAR
Size 128
Nullable true
Indexed true
Product Name
h_product_name
 Product Name
Type VARCHAR
Size 100
Nullable true
Registered Email Address
h_registered_email_address
 The registered email address
Type VARCHAR
Size 64
Nullable true
Indexed true
Registered Name
h_registered_name
 The registered name
Type VARCHAR
Size 128
Nullable true
Indexed true
Release Date
h_release_date
 Release Date
Type DATETIME
Nullable true
Indexed true
Vendor Name
h_vendor_name
 The name of a Vendor record in h_itsm_vendors table.
Type VARCHAR
Size 100
Nullable true
Version
h_version
 Product Version ID
Type VARCHAR
Size 16
Nullable true
Version
h_version_name
 Product Version name
Type VARCHAR
Size 16
Nullable true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document