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_profilealert_profile_dashboard_categoryalert_profile_metricalert_profile_metric_segment_valuealert_rulealert_rule_simulationannotation_groupchange_report_columnchange_report_column_tempchange_report_filterchange_report_keychart_layoutchart_layout_templatecompare_value_calc_methodcustom_fieldcustom_field_auto_synccustom_field_auto_sync_historydaily_target_valuedashboard_elementdashboard_element_delete_logdashboard_element_dependencydashboard_element_other_measurement_intervaldashboard_element_templatedashboard_element_topicdashboard_element_topic_templatedata_collector_jobdata_collector_job_historydata_dependencydatasetdataset_access_mappingdataset_delete_logdataset_filterdataset_report_drill_pathdataset_storagedataset_templatedataset_topicdataset_topic_templatedate_formatdisplay_maskelement_drill_pathexception_report_alertexternal_filter_logexternal_filter_usage_logexternal_filter_value_logfavoritefavorite_dashboard_elementfavorite_dashboard_element_infofiscal_month_target_valuefiscal_quarter_target_valuefiscal_year_target_valuefolderftp_connectionhomepage_messageinference_report_data_set_chartinference_report_data_set_chart_row_valueinference_report_data_set_pivotissueissue_historyissue_notifications_logjavascript_chart_templatelicense_request_profilemeasurement_interval_charting_intervalmeasurement_interval_compare_linemeasurement_time_calc_commandmetric_chart_compare_linemetric_drill_to_reportmetric_filtermetric_targetmonthly_target_valuenotable_eventnotable_event_calendarnotification_schedulenotification_schedule_distribution_topicplugin_connection_profileplugin_connection_profile_topicportal_page_topicproxyquarterly_target_valuereport_data_set_chartreport_data_set_chart_filterreport_data_set_chart_row_valuereport_data_set_pivotreport_data_set_pivot_filtersegmentsegment_templatesegment_valueshared_driveslide_show_elementsource_database_connectionsource_database_connection_topicstats_dataset_templatetargettopicuseruser_dashboard_element_accessuser_dataset_accessuser_favorite_accessuser_groupuser_group_dashboard_categoryuser_group_dashboard_elementuser_group_datasetuser_group_favorite_accessuser_group_memberuser_group_notable_event_calendar_accessuser_group_privilegeuser_group_segment_accessuser_group_segment_value_accessuser_group_target_accessuser_notable_event_calendar_accessuser_noteuser_note_delete_loguser_privilegeuser_segment_accessuser_segment_value_accessuser_target_accessweekly_target_valuextd_target_valueyearly_target_value