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

Products

Details

Table ID: h_itsm_products

Stores Product information for assets

Table Attributes

Name Value
Primary Key h_pk_product_id

Columns

Name & ID Description Column Attributes Relationships
Class
h_class
Identifies the class of product, see asset clases
Type VARCHAR
Size 32
Nullable true
Indexed true
Product ID
h_pk_product_id
The unique identifier of a product, derrived by creating an md5 hash of the vendor ID and product name
Type VARCHAR
Size 32
Nullable false
Primary Key true
One to Many
h_itsm_product_versions.h_fk_product_id
Product Name
h_product_name
The name of the product
Type VARCHAR
Size 64
Nullable true
Vendor ID
h_fk_vendor_id
The ID of the vendor who makes this product
Type VARCHAR
Size 32
Nullable true
Indexed true
Many to One
h_itsm_vendors.h_pk_vendor_id
In This Document