Skip to Content

Change Tracking views

The out-of-the-box Change Tracking views provide detailed and summary information about changes that are associated with device-related actions in your networking environment. You can use this information to build your own custom Change Tracking reports using your own reporting tool.

Built-in Change Tracking views

Information
Recommendation

BMC recommends that you apply appropriate filters (such as REAL_TIMESTAMP or SITE_NAME) while querying the views. You can also apply other filters based on your requirements. Filtering the data improves performance by decreasing the amount of data being fetched, thereby minimizing the time required to process the views.

TrueSight Network Automation - Data Warehouse provides the following built-in views:

View Name/Description

Columns in the view

Example

RV_CNG_FRQ_EXT_CNG

Shows the number of device configuration changes done by external users during the specified time period.

EXT_USER
CNT_EXT_CHANGES
REAL_TIMESTAMP
SITE_NAME 

select * from RV_CNG_FRQ_EXT_CNG where
REAL_TIMESTAMP = '06-04-17'

RV_CNG_FRQ_INT_CNG

Shows the number of device configuration changes done by internal users during the specified time period. 

ORIGINATOR_TYPE_NAME
ORIGINATOR_NAME
CNT_INT_CHANGES
REAL_TIMESTAMP
SITE_NAME 

select * from RV_CNG_FRQ_INT_CNG where REAL_TIMESTAMP = '06-04-17' and ORIGINATOR_TYPE_NAME = 'user'

RV_CNG_FRQ_DEV_GROUP

Shows the number of internal and external device configuration changes done by device groups during the specified time period.

DEVICE_GROUP_NAME
CNT_EXT_CHANGES
CNT_INT_CHANGES
REAL_TIMESTAMP
SITE_NAME 

select * from RV_CNG_FRQ_DEV_GROUP
where DEVICE_GROUP_NAME = 'Huston';

RV_CNG_TRK_SUMM_BY_APPRO_TYPE

Shows the jobs by approval types that resulted in configuration changes in the specified time period.

JOB_APPROVAL_TYPE_NAME
CONF_TRAIL_NAME
JOB_APPROVAL_SRC_TYPE
CNT_EXT_CHANGES
CNT_INT_CHANGES
REAL_TIMESTAMP
SITE_NAME 

select * from RV_CNG_TRK_SUMM_BY_APPRO_TYPE
where JOB_APPROVAL_TYPE_NAME = 'myApproval';

RV_CNG_TRK_SUMM_BY_DEV

Shows the devices with configuration changes in the specified time period.  

DEVICE_NAME
DEVICE_ADDRESS
JOB_APPROVAL_TYPE_NAME
CONF_TRAIL_NAME
APPROVED_EXT
APPROVED_INT
DEVICE_TYPE_NAME
CATEGORY_NAME
REALM_NAME
DEVICE_MODEL_NAME
DEVICE_OS_IMAGE_NAME
CNT_EXT_CHANGES
CNT_INT_CHANGES
REAL_TIMESTAMP
SITE_NAME 

select * from RV_CNG_TRK_SUMM_BY_DEV
where CATEGORY_NAME = 'Router';

RV_CNG_TRK_TREND_BY_APPRO_TYPE

Shows the trends in configuration changes by job approval type for the specified time period.

JOB_APPROVAL_TYPE_NAME
JOB_APPROVAL_SRC_TYPE
YEARS
CNT_EXT_CHANGES
CNT_INT_CHANGES
QUARTERS
MONTHS
WEEKS
DAYS
HOURS
REAL_TIMESTAMP
SITE_NAME 

select * from RV_CNG_TRK_TREND_BY_APPRO_TYPE
where JOB_APPROVAL_SRC_TYPE = 'myApproval';

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

TrueSight Network Automation Reporting 19.11