The out-of-the-box Action Activity views provide detailed and summary information about activities that are associated with device-related actions in your networking environment. You can use this information to build your own custom Action Activity reports using your own reporting tool.
Built-in Action Activity views
InformationRecommendation
BMC recommends that you apply appropriate filters (such as REPORT_BY_NAME, REPORT_BY_VALUE, 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:
| | |
|---|
RV_ACN_ACT_SUMM Provides information about the number of devices that have attempted actions for the specified time period. | REPORT_BY_VALUE
CNT_ACTIONS_SUCCESSFUL
CNT_ACTIONS_FAILED_MINOR
CNT_ACTIONS_FAILED_MAJOR
CNT_ACTIONS_SKIPPED
CNT_ACTIONS_ABORTED
REPORT_BY_NAME
ACTION_NAME
SITE_NAME
TIME_PERIOD | select * from RV_ACN_ACT_SUMM
where REPORT_BY_NAME = 'Device Category' and
time_period = 'Last 30 Days' |
RV_ACN_ACT_SUMM_BY_DEV Summarizes information about the actions taken by devices during the specified time period. | ACTION_NAME
DEVICE_NAME
DEVICE_ADDRESS
REALM_NAME
VENDOR_NAME
DEVICE_TYPE_NAME
CATEGORY_NAME
DEVICE_OS_IMAGE_NAME
DEVICE_MODEL_NAME
CNT_ACTIONS_SUCCESSFUL
CNT_ACTIONS_FAILED_MINOR
CNT_ACTIONS_FAILED_MAJOR
CNT_ACTIONS_SKIPPED
CNT_ACTIONS_ABORTED
SITE_NAME
TIME_PERIOD | select * from RV_ACN_ACT_SUMM_BY_DEV
where time_period = 'Last 90 Days' and action_name = 'Snapshot' |
RV_ACN_APPRO_SUMM Provides information about the number of devices that have attempted approved or unapproved actions for the specified time period. | REPORT_BY_NAME
REPORT_BY_VALUE
CNT_ACTIONS_APPROVED_INT
CNT_ACTIONS_APPROVED_EXT
CNT_ACTIONS_UNAPPROVED
SITE_NAME
TIME_PERIOD | select * from RV_ACN_APPRO_SUMM
where REPORT_BY_NAME = 'Device Category'
and time_period = 'Last 30 Days' |
RV_ACN_APPRO_SUMM_BY_DEV Summarizes information about the devices that have taken approved or unapproved actions for the specified time period. | ACTION_CLASSIFICATION
DEVICE_NAME
REALM_NAME
DEVICE_ADDRESS
VENDOR_NAME
DEVICE_TYPE_NAME
CATEGORY_NAME
DEVICE_MODEL_NAME
DEVICE_OS_IMAGE_NAME
CNT_ACTIONS_APPROVED_INT
CNT_ACTIONS_APPROVED_EXT
CNT_ACTIONS_UNAPPROVED
SITE_NAME
TIME_PERIOD | select * from RV_ACN_ACT_SUMM_BY_DEV
where time_period = 'Last 30 Days'
and site_name = 'dev-pun-029612' |
