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? (4376481)

立即与支持人员聊天

反馈已提交

本文是否解决了您的问题？

选择评级

标题

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?
说明

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?
解决办法

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 picture

The 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/

反馈已提交

本文是否解决了您的问题？

选择评级

建议的内容

标题