Profile Audit Extract

Description

This report provides a list of modifications made on tables in the Profile database. The report can target a specific table or include all of them. It allows users to pick one or more columns from the selected tables and to specify a time frame to further refine results. The report can also filter results based on the identifiers of up to two modified related entities in the selected tables.

Parameters

Scope selection is not relevant for audit reports.

From and To: Defines the start and end dates of the data time range.

Table Name: Presents tables which have been modified at least once, i.e., which have at least one entry in the audit table.

Column Name: Choose from columns available in the selected tables.

Last Modified By: Restricts results to modifications made by a specific individual.

Entity ID: If you know the identifier of the entity you will audit, enter it here to limit results to this entity only.

Entity2 ID: To further filter the results from a search with an Entity ID, enter the ID of one of its related entities.

1. Click Generate to obtain Profile Audit Extracts.

Figure 1 - Profile Audit Extract parameters

Results

Each row represents a modification in the selected tables.

Additional fields may appear in the report to reflect the configuration of your client accounts.

Figure 2 - Profile Audit Extract

Column Header Description example
Audit ID Each audit entry is assigned a number. Depending on the filters you have selected, the relevant audit entries will be added to your report.

117

Last Modification Date Date and time when the modification occurred.

8/5/2020 3:15:40 PM

Last Modified by Name of the user who performed the modification.

Neil Peart

Description Description of the modification.

 

Application Name Name of the Orchestration Console application in which the modification was made.

 

Operation Nature of the modification.
U- Update
I- Insert
D- Delete
Table Name Name of the modified table.

CONFIG

Column Name Name of the column in which the modification was done.

Value

Entity ID Identifier of the modified entity.

UsernameAndEmailUniqueBySalesScope

Entity2 ID Some entities require related entities. Language, for example, is related to language-culture entities like EN-CA. When a related entity was modified, its identifier is displayed here.

en-CA, it-IT

Old Value Value present prior to the modification.

 

New Value Value present after the modification.

 

Batch ID Batch in which the changes were made. A single batch can contain multiple modifications.

512988d4-c458-4c70-ae86-f0046ccf991

Permissions

Report Administrator

REFERENCES

Managing Reports and Extracts
Generating Analytics Reports and Extracts
Exporting, Downloading Analytics Reports