DEVICE_DIMENSION
The Device dimension (DEVICE_DIMENSION) contains device records with details about the device name, alias, type, status and so on. The following attributes are available for each entity in this dimension and can be used in reports.
In addition to the columns documented here, the DEVICE_DIMENSION table includes a column for each custom host attribute you load in to the reporting database. Columns for custom host attributes can be added to this dimension in the Administrative Console. Click Configure Reporting Server > Add Custom Host Attributes.
|
Columns |
Type |
Length |
Description |
|
ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the device record as defined in FlexNet Operations. The ID is the primary key for the Device dimension. |
|
DEVICE_NAME |
string |
2000 |
A 2000-character (non-nullable) name of the device. |
|
BACKUP_DEVICE_NAME |
string |
2000 |
A 2000-character (nullable) backup name for the device. Only used for server devices. |
|
DEVICE_ALIAS |
string |
64 |
A 64-character (nullable) device alias. |
|
DEVICE_TYPE |
string |
64 |
A 64-character (nullable) device type. The possible values are CLIENT, SERVER or SERVED_CLIENT. |
|
DESCRIPTION |
string |
2000 |
A 2000-character (nullable) description of the device. |
|
STATUS |
string |
64 |
A 64-character (nullable) status statement for the device. Device status can be ACTIVE or OBSOLETE. |
|
MACHINE_TYPE |
string |
64 |
A 64-character (nullable) machine type. The possible machine type values are PHYSICAL, VIRTUAL, or UNKNOWN. |
|
VM_NAME |
string |
64 |
A 64-character (nullable) VM name for the device. VM_NAME is null if MACHINE_TYPE is not VIRTUAL. |
|
HOST_TYPE |
string |
255 |
A 255-character (nullable) host type. The host type FLX_CLIENT and FLEX_SERVER are common host types, but no additional restrictions are placed on the value of HOST_TYPE. |
|
HOST_ID_TYPE |
string |
64 |
A 64-character host ID type. Common values are ETHERNET, FLEXID_9, FLEXID_10, String, and VM_UUID. Default: String. |
|
PUBLISHER |
string |
64 |
A 64-character producer name. |
|
PUBLISHER_IDENTITY |
string |
64 |
A 64-character (nullable) identifier for the device producer. |
|
USER_STRING |
varchar2 |
255 |
If the Device user option is set to On with validation and the device is mapped to a user, this is the user name. If the device is mapped to a contact, this is the contact’s email ID The USER_STRING is a foreign key to the CONTACT_DIMENSION table. If the Device user option is set to On without validation and the device is mapped to a user or a contact, this is the plain text string provided with the device during activation. If the Device user option is set to Off (default setting) or the device is mapped to a user or a contact, this is null. See “Configuring FlexNet Operations” in the Producer Portal Help Guide for more information on configuring the Device user option. |