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

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