Patch 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 Table Name	Definition	Behavior
DIM_CUSTOMER_LATEST	Attributes for 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_CUSTOMER_SITE_HIERARCHY
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_DATE	Calendar
DIM_PATCH	Attributes relating to a Patch GUID.	Only reflects the current status of attributes i.e. it will not segment history according to attribute changes.
DIM_PATCH_ACTION_STATUS	The action type that can be approval or installations and their associated status.
DIM_SEVERITY	The severity relating to a particular Patch GUID.
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.

Measure Object	Associated With
FACT_PATCH_ACTION	DIM_DATE DIM_CUSTOMER_LATEST DIM_CUSTOMER_SITE_HIERARCHY DIM_PATCH DIM_PATCH_ACTION_STATUS DIM_SITE_LATESTDIM_TENANT

Measure Object

Associated With

FACT_PATCH_ACTION

DIM_DATE

DIM_CUSTOMER_LATEST

DIM_CUSTOMER_SITE_HIERARCHY

DIM_PATCH

DIM_PATCH_ACTION_STATUS

DIM_SITE_LATESTDIM_TENANT