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
  • 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 2
h_custom_ext_char2
 Extended Custom Varchar 2
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
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