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/

피드백 제출됨

이 문서로 해당 문제가 해결되었습니까?

평가 결과 선택

권장 콘텐츠

제목