Users Inherited System Admin Role from Teams
Find all users who inherit the System Administrator role through assigned team memberships.
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
Active Users with No Security Roles Assigned
Find licensed, active users who do not have any security role assigned directly.
Am I System Administrator?
Check if the currently authenticated user possesses the System Administrator security role directly.
Application Users (Service Principals) and Roles
Audit all Microsoft Entra ID Application Users (Service Principals) and their assigned security roles.