Export audit logs

(0) Share

Report

Posted on by ppl666

Hello.

I want to export audit logs like in this video:

Copy Audit Log Data from Existing CoE Environment - YouTube

But I dont see admin_auditlogs table when I am trying to create dataflow. Why? I have system administrator rights.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Jonathan Manrique 2,687 on at

Like (0)

Report

Hi @ppl666

Did you check if you have active auditing for the environment and then for the table

Was this reply helpful? Yes No
ppl666 26 on at

Like (0)

Report

Yes. I can see audit logs in my model driven app. But I need to export them. So I need an access to admin_auditlog table. But I dont see it.

Was this reply helpful? Yes No
pavanmanideep 495 Power Up Champ - 2025 on at

Like (0)

Report

Hi @ppl666

I wrote a blog post on how to connect to your Dataverse instance using SQL

https://ecellorscrm.com/2023/08/09/connecting-to-your-dataverse-instance-to-run-sql-queries-without-...

Can you try this way and see if you were able to see those tables?

Hope this helps…

If I have answered your question, please mark your post as Solved.
If you like my response or got a direction forward to proceed, please give it a Thumbs Up at least. Appreciate your Kudos. You can accept more than one post as a solution.

If you were still facing any issue or challenge, please do let me know so that I can try to check for you. Happy to help you further.

Blog: https://ecellorscrm.com

Cheers,
PMDY

Was this reply helpful? Yes No
Jonathan Manrique 2,687 on at

Like (0)

Report

Hi @Pavan_Mani_Deep

You can use this tool from xrm toolbox "Audit History Extractor"

GitHub - alduzzen1985/Audit-History-Extractor: A XrmToolBox plugin to extract the Audit History into a CSV File

Was this reply helpful? Yes No
ppl666 26 on at

Like (0)

Report

I know about xrm toolbox, but I need to create a flow to export this data.

Was this reply helpful? Yes No
Jonathan Manrique 2,687 on at

Like (0)

Report

Hi @ppl666

Here is a solution that may help you.

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Where-is-the-Audit-History-Table/td-p/2350926

Was this reply helpful? Yes No
ppl666 26 on at

Like (0)

Report

@Jmanriquerios @Pavan_Mani_Deep
But why I cant access this tables like this guy in the video I sent? Through dataflow.

Was this reply helpful? Yes No
alx.kpk 50 on at

Like (0)

Report

Are you using CoE (Center of Excellence) on your environment? I think that's required to be able to use the admin_auditlog table

Set up the CoE Starter Kit: Prerequisites and instructions - Power Platform | Microsoft Learn

Was this reply helpful? Yes No