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

CMDB Asset Users

Details

Table ID: h_cmdb_assets_users

Stores information about which users associated with an asset

Table Attributes

Name Value
Primary Key h_pk_id

Columns

Name & ID Description Column Attributes Relationships
Asset ID
h_fk_assetid
Asset unique record identifier from h_cmdb_assets.h_pk_asset_id
Type VARCHAR
Size 32
Nullable true
Indexed true
Entity ID
h_fk_entityid
This column stores the same values as the column h_fk_userid, apart when h_usertype = 'Customer Organizations'. When h_usertype = 'Customer Organizations', then h_fk_userid stores the container ID, h_fk_entityid stores the Organization ID
Type VARCHAR
Size 64
Nullable true
ID
h_pk_id
Unique identifier for this asset user record
Type INTEGER
Nullable false
Primary Key true
Auto Increment true
User ID
h_fk_userid
The unique identifier of the 'user' e.g. a contact id/user id/team id/company id
Type VARCHAR
Size 64
Nullable true
Indexed true
User Type
h_usertype
The type of the 'user' e.g. 'contact', 'user', 'team', 'company'
Type VARCHAR
Size 64
Nullable true
In This Document