All Alternate Keys in Environment
Retrieve all alternate keys across tables, key status, and index creation state for data integration.
Loading FetchXML...Loading Web API OData...Loading TDS SQL...How to Execute this Query
1. Browser Web API & Online Studios
Click Run Query for direct browser execution, or use Edit & Run FetchXML (FetchXML Tester) and Edit & Run OData (WebAPI Tester) to edit, beautify, and test queries in online studios.
2. XrmToolBox / FetchXML Builder
Copy the FetchXML snippet and open FetchXML Builder in XrmToolBox. Paste the query directly to inspect records, preview results, or generate C# / JavaScript code.
3. SSMS / TDS Endpoint
Copy the TDS / SQL query. In SQL Server Management Studio, connect to [org].crm.dynamics.com,5558 with Azure AD authentication and execute standard SQL queries.
Suggested Queries
Other frequently used Microsoft Dataverse queries
Failed Async System Jobs in Last 7 Days
Monitor and troubleshoot system job failures, asynchronous plugins, and workflow crashes from the past 7 days.
Registered Custom Plugin Steps & Execution Stages
Inspect all custom plugin steps, execution stages (Pre-val, Pre-op, Post-op), execution mode (Sync/Async), and target entity.
Tables Enabled for Auditing
Find which Dataverse tables currently have data auditing enabled for governance and compliance.