Skip to Content

Source of Change views

The out-of-the-box Source of Change views provide detailed and summary information about the internal and external changes made in your networking environment. You can use this information to build your own customSoiurce of Change reports using your own reporting tool.

Built-in Source of change views

Information
Recommendation

BMC recommends that you apply appropriate filters (such as TIME_PERIOD 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_BY_PERSON_INT_USER

Displays the number of configuration changes and the associated internal users for the specified time period.

ORIGINATOR_NAME
CNT_INT_CHANGES
SITE_NAME
TIME_PERIOD 

select * from RV_CNG_BY_PERSON_INT_USER
where TIME_PERIOD = 'All';

RV_CNG_BY_PERSON_EXT_USER

Displays the number of configuration changes and the associated external users for the specified time period.

EXT_USER
CNT_EXT_CHANGES
TIME_PERIOD
SITE_NAME

select * from RV_CNG_BY_PERSON_EXT_USER
where TIME_PERIOD = 'All';

RV_CONF_CNG_TOTAL_CONF_CNG

Displays information about the source, time, and total number of the internal and external configuration changes in your networking environment for the specified time period. 

ORIGINATOR_TYPE_NAME
DISPLAY_HOUR
SUM_INT_AND_EXT_CHANGES
TIME_PERIOD
SITE_NAME 

select * from RV_CONF_CNG_TOTAL_CONF_CNG
where TIME_PERIOD = 'Last 30 Days';

RV_CONF_CNG_INT_CONF_CNG

Displays information about the source, time, and device on which internal configuration changes are done in your networking environment for the specified time period.

DEVICE_NAME
DEVICE_ADDRESS
CREATED_DATE
ORIGINATOR_NAME
ORIGINATOR_TYPE_NAME
TIME_PERIOD
SITE_NAME 

select * from RV_CONF_CNG_INT_CONF_CNG
where ORIGINATOR_TYPE_NAME = 'User'
and TIME_PERIOD = 'Last 90 Days';

RV_CONF_CNG_EXT_CONF_CNG

Displays information about the date and device on which external configuration changes are done in your networking environment for the specified time period.

DEVICE_NAME
DEVICE_ADDRESS
CREATED_DATE
EXT_USER
SITE_NAME
TIME_PERIOD 

select * from RV_CONF_CNG_EXT_CONF_CNG
where TIME_PERIOD = 'Last 30 Days';

RV_CONF_CNG_CNG_HISTORY

Displays information about the time and total number of configuration changes in your networking environment for the specified time period

DISPLAY_HOUR
NO_CHANGES 

select * from RV_CONF_CNG_CNG_HISTORY
where DISPLAY_HOUR = '07:00 AM';

RV_SOURCE_OF_CNG_DTLS

Displays the devices' details and number of internal and external configuration changes for devices in your networking environment for the specified time period

DEVICE_NAME
DEVICE_ADDRESS
DEVICE_MODEL_NAME
REPORT_BY_NAME
REPORT_BY_VALUE
CNT_INT_CHANGES
CNT_EXT_CHANGES
SITE_NAME
TIME_PERIOD 

select * from RV_SOURCE_OF_CNG_DTLS
where REPORT_BY_NAME = 'Device Type'
and TIME_PERIOD = 'All';

 

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

TrueSight Network Automation Reporting 19.11