Query Service audit log integration
The Adobe Experience Platform Query Service audit log integration provides records of query-related user actions. Audit logs are an essential tool for troubleshooting and adhering to corporate data stewardship policies and regulatory requirements. The capability allows you to return an action log for many event types and filter and export the records. The logs can be accessed either through the Platform UI or the Audit Query API and downloaded in either CSV or JSON file formats.
To learn more about the audit logs user interface, refer to the audit logs overview document. To learn more about making calls to Platform APIs, refer to the audit logs API guide.
Prerequisites
You must have the Data Governance View User Activity Log permission enabled to view the audit log dashboard within the Platform UI. The permission is enabled through the Adobe Admin Console. Please contact your organization’s administrator if you do not have administrator privileges to enable this permission. See the access control documentation for full instructions on adding permissions through Admin Console.
Query Service audit log categories audit-log-categories
The audit log categories provided by Query Service are as follows.
Perform a Query Service audit log perform-an-audit-log
To perform an audit for Query Service activities, select Audits from the left navigation, followed by the funnel icon ( ) to display a list of filter controls to help narrow results.
From the Audits dashboard Activity log tab, you can filter all the recorded Platform actions by any of the Query Service categories. The log results can be further filtered based on the time period they were executed, the action/function taken, or the user that enacted the query. See the audit log documentation for full instructions on how to filter the logs based on category, action, user, and status.
The returned audit log data contains the following information on all queries that meet your chosen filter criteria.
month/day/year hour:minute AM/PM
format.
Details panel
Select any row of audit log results to open a details panel to the right of the screen.
The details panel can be used to find the Asset ID and the Event status.
The value of the Asset ID changes depending on the category used in the audit.
- When using the Query category, the Asset ID is the session ID.
- When using the Query template category, the Asset ID is the template ID and prefixed with
templateID:
. - When using the Scheduled query category, the Asset ID is the schedule ID and prefixed with
scheduleID:
.
The value of the Event status changes depending on the category used in the audit.
- When using the Query category, the Event status field provides a list of all query IDs executed by the user within that session.
- When using the Query template category, the Event status field provides the template name as a prefix for the event status.
- When using the Query schedule category, the Event status field provides the schedule name as a prefix for the event status.
Available filters for Query Service audit log categories available-filters
Available filters vary depending on the category selected in the dropdown. The following table details the filters available for Query Service audit log categories.
Next steps
By reading this document, you have a better understanding of the Query Service audit log capability and how it can be used to filter your Query Service user actions.
If you are using the Query Service audit log capability for troubleshooting purposes, you are recommended to read the troubleshooting guide.