Configuration Drift views

The out-of-the-box Configuration Drift reports provide detailed and summary information about drift (a discrepancy from the trusted configuration) in your networking environment. You can use this information to build your own custom Configuration Drift reports using your own reporting tool

Built-in Configuration Drift views

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_CONF_DRIFT_DTLS Displays the devices that have a configuration drift at the specified point in time.	DEVICE_NAME REALM_NAME HAS_DRIFT HAS_DRIFT_RT HAS_DRIFT_ST HAS_DRIFT_RS HAS_DRIFT_OS SITE_NAME TIME_PERIOD	^{select * from RV_CONF_DRIFT_DTLS} ^{where HAS_DRIFT = 'X'} ^{and time_period = 'All'}
RV_CONF_DRIFT_SUMM Displays the number of devices with configuration drift at the specified point in time.	CNT_DEVICES_WITH_DRIFTS DRIFT REPORT_BY_VALUE REPORT_BY_NAME SITE_NAME TIME_PERIOD	^{select * from RV_CONF_DRIFT_SUMM} ^{where REPORT_BY_NAME = 'Device Type'} ^{and drift = 'Any Drift'} ^{and TIME_PERIOD = 'Current';}
RV_CONF_DRIFT_TREND Displays the trend of device configuration drifts over the specified time period.	DRIFT REPORT_BY_VALUE REPORT_BY_NAME YEARS TIME_PERIOD_ID DTE_TIME QUARTERS MONTHS WEEKS DAYS HOURS CNT_DEVICES_WITH_DRIFTS ETL_TIME_PERIOD SITE_NAME TIME_PERIOD	^{select * from RV_CONF_DRIFT_TREND} ^{where REPORT_BY_NAME = 'Device Category'} ^{and drift = 'Running Vs Startup Drift'} ^{and TIME_PERIOD = 'Current';}

Configuration Drift views

Built-in Configuration Drift views

TrueSight Network Automation Reporting 19.11

On this page