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 Software Assets

  • Article
  • 2 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
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