Announcements
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.
Hi @ppl666
Did you check if you have active auditing for the environment and then for the table
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.
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
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
I know about xrm toolbox, but I need to create a flow to export this data.
Here is a solution that may help you.
https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Where-is-the-Audit-History-Table/td-p/2350926
@Jmanriquerios @Pavan_Mani_Deep
But why I cant access this tables like this guy in the video I sent? Through dataflow.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 519 Most Valuable Professional
11manish 489
Haque 327
