azureazure-active-directoryazure-data-explorerusergroups

Can I use Azure Data Explorer (Kusto) to query data (such as groups) in Microsoft Entra Admin Center?

There is UI to query/filter users/groups. I'm wondering if there is kusto connection to do that. thx.

enter image description here

Solution

  • As mentioned in this blog by AdamMarczakIO, it's not possible to query/filter Microsoft Entra groups directly in KQL as they are not Azure resources.

    Alternatively, you can make use of below Microsoft Graph API calls to query/filter users or groups in Graph Explorer.

    Users:

    GET https://graph.microsoft.com/v1.0/users/?$filter=startswith(displayName,'sri')&$select=id,displayName,userPrincipalName

    enter image description here

    Groups:

    GET https://graph.microsoft.com/v1.0/groups/?$filter=startswith(displayName, 'demo')&$select=id,displayName

    enter image description here

    References:

    List users - Microsoft Graph v1.0

    List groups - Microsoft Graph v1.0