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