Product Audit Extract

ANALYTICS > REPORTS

Description

This report provides a list of modifications made on tables in the Product 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 table(s) selected above.

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

Entity ID: If you know the identifier of the entity you are attempting to 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.

Click Generate to obtain Product Audit Extracts.

Figure 1 - Product Audit Extract parameters

Results

Each row represents a modification in the selected table.

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

Figure 2 - Product 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.	1, 2, 3
Last Modification Date	Date when the modification occurred.	8/5/2020 3:44:50 PM
Last Modified by	Name of the user who performed the modification.	first.last@Orckestra.com
Description	Description of the modification.
Application Name	Name of the Orchestration Console application in which the modification was made.	OMS
Operation	Nature of the modification. Possible choices include U (update), I (insert) and D (delete).	Create
Table Name	Name of the modified table.	scope.Global_ITEM_PRICELIST
Column Name	Name of the column in which the modification was done.	Price
Entity ID	Identifier of the modified entity.	1613325-84616284
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.	Default
Old Value	Value present prior to the modification.
New Value	Value present after the modification.	39.99
Batch ID	Batch in which the changes were made. A single batch can contain multiple modifications.	8c6985ce-ca9b-49b6-88ec-80a2c4114d58