Key Performance Indicator views
The out-of-the-box Key Performance Indicator (KPI) dashboard views include multiple reports with data related to productivity, compliance, and maturity in your network environment. You can use this information to build your own custom Dashboard using your own reporting tool.
Built-in KPI views
Recommendation
BMC recommends that you apply appropriate filters (such as BUSINESS_SERVICE or TIME_RANGE) 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_CMP_DASH Shows the trends for key compliance metrics, including device compliance, rule compliance, device drift, and drift audit information, over the specified time period. | MONTHS | select * from RV_CMP_DASH; |
RV_MATURITY_DASH_AUTH_CNG Shows metrics related to sources of changes to network devices, including authorized changes. | BUSINESS_SERVICE MONTHS YEARS CNT_ACTIONS_APPROVED_INT CNT_ACTIONS_APPROVED_EXT CNT_ACTIONS_UNAPPROVED TIME_RANGE | select * from RV_MATURITY_DASH_AUTH_CNG; |
RV_MATURITY_DASH_INT_CNG Shows metrics related to sources of changes to network devices, including internal and external changes. | MONTHS YEARS BUSINESS_SERVICE CNT_DEVICES CNT_INT_CHANGES CNT_EXT_CHANGES TIME_RANGE | select * from RV_MATURITY_DASH_INT_CNG; |
RV_PROD_DASH_FOR_ACN Shows metrics for the changes associated with the device-related actions by users for the specified time period. | MONTHS YEARS CNT_ACTIONS_SUCCESSFUL CNT_ACTIONS_FAILED_MINOR CNT_ACTIONS_FAILED_MAJOR BUSINESS_SERVICE TIME_RANGE | select * from RV_PROD_DASH_FOR_ACN; |
RV_PROD_DASH_FOR_CNG Shows metrics for the changes associated with the device-related actions by users for the specified time period. | MONTHS YEARS CNT_ACTIONS_SUCCESSFUL CNT_ACTIONS_FAILED_MINOR CNT_ACTIONS_FAILED_MAJOR BUSINESS_SERVICE TIME_RANGE | select * from RV_PROD_DASH_FOR_CNG; |
RV_PROD_DASH_FOR_DEV Shows metrics for the device-related actions by users for the specified time period. | CNT_DEVICES YEARS MONTHS BUSINESS_SERVICE TIME_RANGE | select * from RV_PROD_DASH_FOR_DEV; |
RV_PROD_DASH_FOR_RULE Shows metrics for the number of logged in BMC Network Automation users and their role names for the specified time period. | CNT_LOGGED_IN ROLE_NAME YEARS MONTHS TIME_RANGE | select * from RV_PROD_DASH_FOR_RULE; |
Comments
Log in or register to comment.