Execute & Inspect Dataverse Queries
A curated catalog of frequently used Microsoft Dataverse queries with instant browser execution across FetchXML, Web API OData, and TDS SQL.
Active Users with No Security Roles Assigned
Find licensed, active users who do not have any security role assigned directly.
All Alternate Keys in Environment
Retrieve all alternate keys across tables, key status, and index creation state for data integration.
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.
Environment Variables and Current Values
Retrieve all environment variable definitions along with their current environment-specific values and default values.
Failed Async System Jobs in Last 7 Days
Monitor and troubleshoot system job failures, asynchronous plugins, and workflow crashes from the past 7 days.
Inactive Users Holding Security Roles
Identify disabled users who still retain direct security roles in the environment for offboarding compliance.
List All Enabled System Administrators
Retrieve all active and enabled users who hold the System Administrator role.
List All Installed Solutions
Retrieve all visible solutions with publisher details, version numbers, and managed vs unmanaged status.
List All Teams with System Administrator Role
Retrieve all Dataverse teams that have been assigned the System Administrator role.
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.
Users Inherited System Admin Role from Teams
Find all users who inherit the System Administrator role through assigned team memberships.
Inherited Security Roles from Assigned Teams
List all security roles inherited by the current user from their assigned teams.
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.
Security Roles Assigned Directly to Me
Retrieve all Dataverse security roles directly assigned to the current user.
Tables Enabled for Auditing
Find which Dataverse tables currently have data auditing enabled for governance and compliance.
Teams Assigned to Current User
List all Microsoft Dataverse teams and business units to which the current user belongs.
Admin Teams Along with Member Users
Find all teams holding the System Administrator role together with their member users.