Dashboard views

RV_EXEC_DASH_BY_INVENT

Provides high-level summary of inventory tracked by the system.

VENDOR_NAME
CATEGORY_NAME
DEVICE_NAME
HAS_VIOLATION
CNT_DEVICES_WITH_VIOLATIONS
SITE_NAME 

^{select * from RV_EXEC_DASH_BY_INVENT
where VENDOR_NAME = 'Juniper';}

RV_EXEC_DASH_BY_ACTION

Provides high-level summary of actions and action results.

ACTION_NAME
CNT_ACTIONS_SUCCESSFUL
CNT_ACTIONS_FAILED_MINOR
CNT_ACTIONS_FAILED_MAJOR
CNT_ACTIONS_SKIPPED
CNT_ACTIONS_ABORTED
SITE_NAME 

^{select * from RV_EXEC_DASH_BY_ACTIONwhere ACTION_NAME = 'Snapshot';}

RV_EXEC_DASH_BY_CONF_DRIFT

Provides high-level summary of drift types and number of devices having drifts.

DRIFT
CNT_DEVICES_WITH_DRIFTS
SITE_NAME 

^{select * from RV_EXEC_DASH_BY_CONF_DRIFT
where DRIFT = 'Any Drift'}

RV_EXEC_DASH_BY_USER_CNG

Displays information about the job approval source and type, and the number of external and internal changes.

JOB_APPROVAL_TYPE_NAME
JOB_APPROVAL_SRC_TYPE
CNT_EXT_CHANGES
CNT_INT_CHANGES
SITE_NAME 

^{select * from RV_EXEC_DASH_BY_USER_CNG
where JOB_APPROVAL_TYPE_NAME = 'myApproval'}

RV_EXEC_DASH_BY_CNG

Displays information about the type of change and the number of internal changes.

FLAG
SITE_NAME
CNT_INT_CHANGES 

^{select * from RV_EXEC_DASH_BY_CNG
where FLAG = 1;}

RV_SYS_STU_BY_SYS_STU

Displays the number of unmanaged devices (offline) devices, users, and the number of failed and successful actions.

CNT_OFFLINE_DEVICES
CNT_USERS
NO_OF_ACTION_ACC_FAILURE
NO_OF_ACTION_ACC_SUCCESSFUL
SITE_NAME 

^{select * from RV_SYS_STU_BY_SYS_STU;}

RV_SYS_STU_BY_DEV_GROUP_PART1

Displays the number of device groups and describes whether any of these has compliance violations.

HAS_VIOLATION
CNT_GROUP_NAMES
SITE_NAME 

^{select * from RV_SYS_STU_BY_DEV_GROUP_PART1;}

RV_SYS_STU_BY_DEV_GROUP_PART2

Displays the number of devices with violations and describes whether any of these has compliance violations.

HAS_VIOLATION
CNT_DEVICES_WITH_VIOLATIONS
SITE_NAME 

^{select * from RV_SYS_STU_BY_DEV_GROUP_PART2;}

RV_SYS_STU_BY_RULE

Displays the names and number of distinct compliance rules available in BMC Network Automation.

RULE_NAME
CNT_RULE_NAMES
SITE_NAME 

^{select * from RV_SYS_STU_BY_RULE;}

RV_SYS_STU_BY_EVENT

Displays the number of system events.

CNT_SYSTEM_EVENTS

^{select * from RV_SYS_STU_BY_EVENT;}

RV_SYS_STU_BY_ACTION

Displays the number of successful actions and number of failed actions.

CNT_ACTIONS_SUCCESSFUL
CNT_ACTIONS_FAILED_MINOR
CNT_ACTIONS_FAILED_MAJOR 

^{select * from  RV_SYS_STU_BY_ACTION;}

RV_SYS_SUMM_VENDOR_OS_NAME

Displays the top 5 OS image names, OS vendors, and the names and number of devices having those OS images.

VENDOR_NAME
DEVICE_OS_IMAGE_NAME
DEVICE_NAME
CNT_DEVICES
SITE_NAME 

^{select sum(cnt_devices) from RV_SYS_SUMM_VENDOR_OS_NAME
where VENDOR_NAME = 'Cisco';}

RV_SYS_SUMM_INT_CNG_LT_7_DYS

Displays the top 5 internal users and the number of internal changes in last 30 days.

ORIGINATOR_NAME
CNT_INT_CHANGES
SITE_NAME 

^{select * from RV_SYS_SUMM_INT_CNG_LT_7_DYS
where ORIGINATOR_NAME = 'sysadmin';}

RV_SYS_SUMM_EXT_CNG_LT_7_DYS

Displays the top 5 external users and the number of external changes in last 7 days.

EXT_USER
CNT_EXT_CHANGES
SITE_NAME 

^{select * from RV_SYS_SUMM_EXT_CNG_LT_7_DYS;}

RV_SYS_SUMM_INT_CNG_LT_30_DYS

Displays the top 5 internal users and the number of internal changes in last 30 days.

ORIGINATOR_NAME
CNT_INT_CHANGES
SITE_NAME 

^{select * from RV_SYS_SUMM_INT_CNG_LT_30_DYS;}

RV_SYS_SUMM_EXT_CNG_LT_30_DYS

Displays the top 5 external users and the number of external changes in last 30 days.

EXT_USER
CNT_EXT_CHANGES
SITE_NAME 

^{select * from RV_SYS_SUMM_EXT_CNG_LT_30_DYS;}