Return
-
Title
Is there a unique identifier field in ApexSQL Audit that links before and after lines, allowing you to join the two together in a report? -
Description
Is there a unique identifier field in ApexSQL Audit that links before and after lines, allowing you to join the two together in a report? -
Resolution
The only unique ApexSQL Audit identifiers we could offer are:
EventSource == 0 - auditing
EventSource == 2 - Before-After auditing
However, there potentially could be another solution to this.
Please generate two different reports, one for standard auditing by using API call and one Before-After report for the same time.
Then add both reports, one by one, in the Power BI to get the whole pictureThe following guides might also be helpful:
https://knowledgebase.apexsql.com/using-api-to-generate-sql-auditing-reports/
https://solutioncenter.apexsql.com/extract-sql-auditing-data-into-power-bi/