Audit Tables in Dashboard DB
Audit tables for common MI objects are listed below. These can be queried via Dashboard DB to generate audit reports.
-
custom_field_change_log
– any changes to Custom Field -
data_fetch_command_change_log
– changes of data fetch command or html code for the following set:- 'element',
- 'segment',
- 'calendar',
- 'dependency',
- 'command',
- 'digest_template',
- 'custom_script',
- 'dataset',
- 'portal_page',
- 'portal_page_layout',
- 'portal_page_template',
- 'javascript_chart_template_file',
- 'announcement'
-
dataset_storage_change_log
– any changes to Dataset Storage -
element_bulk_change_log
– changes to Elements via Bulk Change tool -
license_request_profile_change_log
– any changes to License Request Profile -
certification_log
– any changes for certification state for the following set:- 'element',
- 'dataset',
- 'sql connection',
- 'plugin profile',
- 'trigger'
The following tables include the field "Last Updated By", which lists the last user who edited an object.
alert_profile
alert_profile_dashboard_category
alert_profile_metric
alert_profile_metric_segment_value
alert_rule
alert_rule_simulation
annotation_group
change_report_column
change_report_column_temp
change_report_filter
change_report_key
chart_layout
chart_layout_template
compare_value_calc_method
custom_field
custom_field_auto_sync
custom_field_auto_sync_history
daily_target_value
dashboard_element
dashboard_element_delete_log
dashboard_element_dependency
dashboard_element_other_measurement_interval
dashboard_element_template
dashboard_element_topic
dashboard_element_topic_template
data_collector_job
data_collector_job_history
data_dependency
dataset
dataset_access_mapping
dataset_delete_log
dataset_filter
dataset_report_drill_path
dataset_storage
dataset_template
dataset_topic
dataset_topic_template
date_format
display_mask
element_drill_path
exception_report_alert
external_filter_log
external_filter_usage_log
external_filter_value_log
favorite
favorite_dashboard_element
favorite_dashboard_element_info
fiscal_month_target_value
fiscal_quarter_target_value
fiscal_year_target_value
folder
ftp_connection
homepage_message
inference_report_data_set_chart
inference_report_data_set_chart_row_value
inference_report_data_set_pivot
issue
issue_history
issue_notifications_log
javascript_chart_template
license_request_profile
measurement_interval_charting_interval
measurement_interval_compare_line
measurement_time_calc_command
metric_chart_compare_line
metric_drill_to_report
metric_filter
metric_target
monthly_target_value
notable_event
notable_event_calendar
notification_schedule
notification_schedule_distribution_topic
plugin_connection_profile
plugin_connection_profile_topic
portal_page_topic
proxy
quarterly_target_value
report_data_set_chart
report_data_set_chart_filter
report_data_set_chart_row_value
report_data_set_pivot
report_data_set_pivot_filter
segment
segment_template
segment_value
shared_drive
slide_show_element
source_database_connection
source_database_connection_topic
stats_dataset_template
target
topic
user
user_dashboard_element_access
user_dataset_access
user_favorite_access
user_group
user_group_dashboard_category
user_group_dashboard_element
user_group_dataset
user_group_favorite_access
user_group_member
user_group_notable_event_calendar_access
user_group_privilege
user_group_segment_access
user_group_segment_value_access
user_group_target_access
user_notable_event_calendar_access
user_note
user_note_delete_log
user_privilege
user_segment_access
user_segment_value_access
user_target_access
weekly_target_value
xtd_target_value
yearly_target_value