Admin Teams Along with Member Users
Find all teams holding the System Administrator role together with their member users.
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 Teams with System Administrator Role
Retrieve all Dataverse teams that have been assigned the System Administrator role.
Users Inherited System Admin Role from Teams
Find all users who inherit the System Administrator role through assigned team memberships.
Teams Assigned to Current User
List all Microsoft Dataverse teams and business units to which the current user belongs.