How to read the Audit sql table in Power Platform with sqL4CDS

If you’re looking to access audit data from Dataverse using SQL, SQL4CDS is a must-have plugin for XrmToolBox. It allows you to write SQL-style queries against your Dataverse environment, including tables like audit that are typically hard to reach via FetchXML or the UI.

How to Install SQL4CDS

1. Download and open XrmToolBox from https://www.xrmtoolbox.com.
2. Go to Tools > Plugin Store.
3. Search for SQL 4 CDS by Mark Carrington.
4. Click Install, then launch the plugin from the main menu.

How to Query the Audit Table

Once connected to your environment, you can run queries like:

SQL

SELECT * FROM audit

WHERE objectid = ‘your-record-guid’

ORDER BY createdon DESC
Show more lines

You can filter by operation, userid, or any other relevant field. Results can be exported to Excel or CSV for further analysis.

SQL4CDS makes it easy to explore audit logs for compliance, troubleshooting, or reporting—without needing to write complex FetchXML.