Device data
Here are the object definitions, behaviors, and associations used in both the Dashboard and custom reports.
Certain items, unique to the Dashboard and custom reports, may not appear in the same format in the direct data access data dictionary.
Object definitions
| Object Table Name | Definition | Behavior |
|---|---|---|
|
DIM_CUSTOMER_LATEST |
Attributes of a Customer that owns the device. |
Only reflects the current status of attributes i.e. it will not segment history according to attribute changes. |
|
DIM_DATE |
Calendar |
|
|
DIM_DEVICE_SUMMARY |
Attributes for a discovered Asset. Includes N-Central device, hardware, CPU, OS and agent attributes. |
It reflects the historic status of attributes depicting how the attributes changed over a period of time. |
|
DIM_DEVICE_SUMMARY_LATEST |
Attributes for a discovered Asset. Includes N-Central device, hardware, CPU, OS and agent attributes. |
Only reflects the current status of attributes i.e. it will not segment history according to attribute changes. |
|
DIM_SITE |
Attributes for a Customer\Site that owns the Device. |
It reflects the historic status of attributes depicting how the attributes changed over a period of time. |
|
DIM_SITE_LATEST |
Attributes for a Customer\Site that owns the Device. |
Only reflects the current status of attributes i.e. it will not segment history according to attribute changes. |
|
DIM_APPLICATION |
Attributes of an application |
It reflects the historic status of attributes depicting how the attributes changed over a period of time. |
|
DIM_TIME |
Time |
|
|
FACT_APPLICATION_COUNT |
Attributes of application metrics on a device. |
It reflects application metrics for every device and snapshot date. |
|
FACT_APPLICATION_STATUS |
Attributes of application approval and installation status on a device. |
It reflects the application approval and installation status per device. |
|
FACT_ASSET_COUNT |
Attributes of device status |
It reflects the device status for every snapshot date. |
Object associations
| Measure Object | Associated with |
|---|---|
|
FACT_APPLICATION_COUNT FACT_APPLICATION_STATUS FACT_ASSET_COUNT |
DIM_TIME DIM_DATE DIM_SITE DIM_SITE_LATEST DIM_DEVICE_SUMMARY DIM_DEVICE_SUMMARY_LATEST DIM_CUSTOMER_SITE_HEIRARCHY DIM_CUSTOMER_LATEST DIM_APPLICATIONDIM_APP_PUBLISHER |