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 Mobile Device Assets

  • Article
  • 6 minutes to read

Details

Table ID: h_cmdb_assets_mobile_device

Stores information about assets in the 'Mobile Device' 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
Capacity
h_capacity
 The storage capacity of the asset
Type VARCHAR
Size 16
Nullable true
Compliance Expiration
h_compliance_expiration
 Compliance Expiration
Type DATETIME
Nullable true
Indexed true
Compliance State
h_compliance_state
 Compliance State
Type VARCHAR
Size 64
Nullable true
Indexed true
CPU Info
h_cpu_info
 The CPU Info for this device
Type VARCHAR
Size 64
Nullable true
Data Number
h_data_number
 Data Number
Type VARCHAR
Size 32
Nullable true
Indexed true
Delivery Type
h_delivery_type
 Delivery Type
Type VARCHAR
Size 32
Nullable true
Indexed true
Device Encrypted
h_device_encrypted
 Device Encrypted
Type VARCHAR
Size 32
Nullable true
Indexed true
Device ID
h_device_id
 Device ID
Type VARCHAR
Size 64
Nullable true
Indexed true
Device Name
h_device_name
 Device Name
Type VARCHAR
Size 64
Nullable true
Indexed true
Device Registration State
h_device_registration_state
 Device Registration State
Type VARCHAR
Size 64
Nullable true
Indexed true
Discovery Fingerprint
h_dsc_fingerprint
 The MD5 fingerprint of the overall item
Type VARCHAR
Size 32
Nullable true
Discovery Software Fingerprint
h_dsc_sw_fingerprint
 The MD5 fingerprint of the installed software items
Type VARCHAR
Size 32
Nullable true
Enrolled
h_enrolled
 Enrolled
Type DATETIME
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
IMEI Number
h_imei_number
 The IMEI number for this asset
Type VARCHAR
Size 32
Nullable true
IMSI Number
h_imsi_number
 The IMSI number for this asset
Type VARCHAR
Size 32
Nullable true
IP Address
h_ip_address
 The ip address for this asset
Type VARCHAR
Size 128
Nullable true
Last Sync
h_last_sync
 Last Sync
Type DATETIME
Nullable true
Indexed true
MAC Address
h_mac_address
 The mac address for this asset
Type VARCHAR
Size 32
Nullable true
Manufacturer
h_manufacturer
 The manufacturer for this asset
Type VARCHAR
Size 64
Nullable true
Model
h_model
 The model for this asset
Type VARCHAR
Size 64
Nullable true
MTPAS Access Class
h_mtpas_access_class
 The MTPAS Access Class for this asset
Type VARCHAR
Size 64
Nullable true
Operating System Expiry Date
h_os_expiry_date
 Operating System Expiry Date
Type DATETIME
Nullable true
Indexed true
OS description
h_os_description
 OS description
Type VARCHAR
Size 256
Nullable true
Indexed true
OS patch
h_os_patch
 OS patch
Type VARCHAR
Size 128
Nullable true
Indexed true
OS Version
h_os_version
 The Operating System for this device
Type VARCHAR
Size 32
Nullable true
Phone Number
h_phone_number
 The phone number for this asset
Type VARCHAR
Size 20
Nullable true
Primary Termination
h_primary_termination
 Primary Termination
Type VARCHAR
Size 32
Nullable true
Indexed true
Secondary Service Provider ID
h_secondary_service_provider_id
 Secondary Service Provider ID
Type VARCHAR
Size 32
Nullable true
Indexed true
Serial Number
h_serial_number
 The serial number for this asset
Type VARCHAR
Size 128
Nullable true
SIM Number
h_sim_number
 The sim card number for this asset
Type VARCHAR
Size 32
Nullable true
SIM Type
h_sim_type
 The sim card type for this asset
Type VARCHAR
Size 16
Nullable true
Tariff Code
h_tariff_code
 Tariff Code
Type VARCHAR
Size 32
Nullable true
Indexed true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document