Compliance views

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

Built-in Compliance 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_PLY_CMP_DEV_IN_CMP Displays the compliant devices for the specified time period.	DEVICE_ADDRESS SITE_NAME TIME_PERIOD	^{select * from RV_CONF_PLY_CMP_DEV_IN_CMP} ^{where TIME_PERIOD = 'Current';}
RV_CONF_PLY_CMP_DEV_NT_IN_CMP Displays the non-compliant devices for the specified time period.	DEVICE_ADDRESS SITE_NAME TIME_PERIOD	^{select * from RV_CONF_PLY_CMP_DEV_NT_IN_CMP where TIME_PERIOD = 'Current';}
RV_CONF_PLY_CMP_DEV_LAST_CONF Displays the date on which last configuration changes were made on the compliant and non-compliant devices for the specified time period.	DEVICE_ADDRESS LAST_CONF_CHANGE_DATE	^{select * from RV_CONF_PLY_CMP_DEV_LAST_CONF;} Note: You can join RV_CONF_PLY_CMP_DEV_LAST_CONF and RV_CONF_PLY_CMP_DEV_IN_CMP to generate a meaningful report for the compliant devices. You can join RV_CONF_PLY_CMP_DEV_LAST_CONF and RV_CONF_PLY_CMP_DEV_NT_IN_CMP to generate a meaningful report for the non-compliant devices.
RV_CONF_PLY_CMP_CONF_PLY Displays the rule sets, rules, and and total number of rules on the compliant and non-compliant devices for the specified time period.	RULE_SET_NAME RULE_NAME CNT_RULES SITE_NAME TIME_PERIOD	^{select * from RV_CONF_PLY_CMP_CONF_PLY;}
RV_DEV_CMP_DTLS Displays the latest data on compliant and non-compliant devices for the specified time period.	REALM_NAME DEVICE_NAME HAS_VIOLATION_CRITICAL HAS_VIOLATION HAS_VIOLATION_INFO HAS_VIOLATION_MAJOR HAS_VIOLATION_MINOR HAS_VIOLATION_WARNING NO_OF_VIOLATIONS NO_OF_CONF DEVICE_STATUS DEVICE_TYPE_NAME CATEGORY_NAME VENDOR_NAME DEVICE_MODEL_NAME DEVICE_OS_IMAGE_NAME SITE_NAME TIME_PERIOD	^{select * from RV_DEV_CMP_DTLS} ^{where category_name = 'Switch'} ^{and has_violation_critical = 'x'} ^{and time_period = 'Last 7 Days';}
RV_DEV_CMP_SUMM Shows the number of violations for the specified device at the specified point in time.	VIOLATION_TYPE REPORT_BY_NAME REPORT_BY_VALUE DEVICE_STATUS CNT_DEVICES_WITH_VIOLATIONS SITE_NAME TIME_PERIOD	^{select * from RV_DEV_CMP_SUMM} ^{where REPORT_BY_NAME = 'Vendor'} ^{and DEVICE_STATUS = 'Online'} ^{and time_period = 'Last 7 Days';}
RV_DEV_CMP_TREND Shows the number of device compliance violations for the specified time period.	VIOLATION_TYPE REPORT_BY_NAME REPORT_BY_VALUE YEARS TIME_PERIOD_ID DTE_TIME QUARTERS MONTHS WEEKS DAYS HOURS CNT_DEVICES_WITH_VIOLATIONS ETL_TIME_PERIOD SITE_NAME TIME_PERIOD	^{select * from RV_DEV_CMP_TREND} ^{where REPORT_BY_NAME = 'Device Category'} ^{and time_period = 'Current';}
RV_RULE_CMP_DTLS Displays the rules with compliance violations at the specified point in time.	RULE_SET_NAME REALM_NAME RULE_NAME SEVERITY CNT_DEVICES_VIOLATING_RULES SITE_NAME TIME_PERIOD	^{select * from RV_RULE_CMP_DTLS where SEVERITY = 'Minor' and time_period = 'Current';}
RV_RULE_CMP_SUMM Displays the state of compliance violations, organized by rule set, at the specified point in time.	RULE_SET_NAME SEVERITY CNT_DEVICES_VIOLATING_RULES SITE_NAME TIME_PERIOD	^{select * from RV_RULE_CMP_SUMM where SEVERITY = 'Info' and time_period = 'Current';}
RV_RULE_CMP_TREND Shows the trend of rule compliance violations over the specified time period.	RULE_SET_NAME YEARS TIME_PERIOD_ID DTE_TIME QUARTERS MONTHS WEEKS DAYS HOURS CNT_DEVICES_VIOLATING_RULES ETL_TIME_PERIOD SITE_NAME TIME_PERIOD	^{select * from RV_RULE_CMP_TREND where RULE_SET_NAME = 'Auto-CSR-Ex-Spans-RuleLevel' and time_period = 'Last 30 days';}
RV_RULE_DEV_CMP_DTLS Displays the rules and devices with compliance violations at the specified point in time.	REALM_NAME RULE_SET_NAME RULE_NAME DEVICE_NAME DEVICE_ADDRESS DEVICE_OS_IMAGE_NAME DEVICE_MODEL_NAME SEVERITY SITE_NAME TIME_PERIOD	^{select * from RV_RULE_DEV_CMP_DTLS where REALM_NAME = 'Default' and time_period = 'Current';}

Compliance views

Built-in Compliance views

TrueSight Network Automation Reporting 19.11

On this page