Environment Variables and Current Values
Retrieve all environment variable definitions along with their current environment-specific values and default values.
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
List All Installed Solutions
Retrieve all visible solutions with publisher details, version numbers, and managed vs unmanaged status.
List Cloud Flows Status in Solutions
Query the state, status reason, and activation of Power Automate Cloud Flows in solutions.
Connection References and Bound Connectors
List all connection references in the environment, connector type, and connection status.