SAP Knowledge Base Article - Public

3680957 - Audit Logs Export Discrepancy Between Recent and Archived Data

Symptom

  • When downloading recent audit logs, data includes columns such as username and descriptions.
  • When downloading archived audit logs, the exported CSV file does not include enriched data such as usernames and descriptions, only raw data with IDs and UUIDs.
  • Users are unable to identify or interpret UUIDs without additional actions.

Environment

Audit for SAP Sales/Service Cloud

Reproducing the Issue

  1. Navigate to the Audit Logs section in the system.
  2. Select "Recent Logs" and click the export button to download the file. Open the file and observe the data presented, including enriched columns such as usernames and descriptions.
  3. Switch to "Archived Logs" and select a log date.
  4. Click the export button to download the file. Open the file and observe that the exported data does not include enriched columns such as usernames and descriptions, only raw data with IDs and UUIDs.

Cause

  • Recent audit logs are retrieved directly from the database and dynamically enriched during export with user IDs and their corresponding user names for better readability.
  • Archived audit logs, stored in raw format, do not undergo dynamic enrichment during export due to the resource-intensive nature of the operation. Logs older than 7 days are archived in the raw format as they were originally collected.

Resolution

  1. Understand that this behaviour is expected due to system design.
  2. Recent audit logs are retrieved directly from the database and enriched dynamically during export.
  3. Archived audit logs are stored in raw form, and the export process does not perform name enrichment for those entries.
  4. To retrieve user details from archived logs, use the API endpoint: sap/c4c/api/v1/iam-service/users/<UUID of the User taken from archive> .
  5. If needed, Configure audit log retention settings to a maximum of 14 months from the archive view in the Audit log list view.

See Also

Refer to: a href="https://help.sap.com/viewer/product/SAP_SALES_SERVICE_CLOUD/latest/en-US" SAP Sales/Service Cloud Documentation /a

Keywords

audit logs, recent logs, archived logs, CSV export, username, UUID, raw data, data enrichment, SAP Sales/Service Cloud, audit logs discrepancy, export issue, audit data format , KBA , CEC-CRM-AUD , Audit for SAP Sales/Service Cloud , Problem

Product

SAP Sales Cloud and SAP Service Cloud Version 2 all versions