Solution GetDirectoryGroup

Directory Groups report

Solution Code: GetDirectoryGroup

Description

This report lists the groups in your Entra ID (Azure AD) tenant — Microsoft 365 groups, security groups, mail-enabled security groups and distribution lists — with their key properties. Owner and member-count details are optional (see Parameters).

Report generated

Column Title	Description
Id	Object ID of the group
DisplayName	Name of the group
Type	Group classification: Microsoft 365 Group / Mail-enabled security group / Security Group / Distribution List / Unknown
CreatedDate	Date and time when the group was created
OwnersTotal	Total number of owners (only when "Include Owners" is enabled, otherwise Unknown)
OwnersEmail	Email addresses of all group owners (only when "Include Owners" is enabled)
MembershipType	Dynamic or Static group
MembersTotal	Total number of members (only when "Include Members count" is enabled, otherwise Unknown)
MailEnabled	Whether the group has a mailbox
Email	Email address of the group, when applicable
SecurityEnabled	Whether it is defined as a security group
Visibility	Public / Private (only applicable to Microsoft 365 groups)
Description	Description of the group
Remarks	Remarks/errors captured while building the row

Requirements

API	Delegated	Application
Microsoft Graph	User.Read Group.Read.All	Group.Read.All
RBAC	Group Administrator*	NA

Global Reader or another admin role that can read Entra ID groups.

Parameters

Directory Group filter

How this Solution works

1. Retrieves all groups in the tenant.
2. Filters them by the Directory Group filter (creation date range and group types).
3. For each matching group, optionally retrieves its owners and/or total member count, depending on the selected parameters.
4. Records one row per group.

Notes

To keep the report a manageable size, only the number of members is reported (MembersTotal); the individual members are never listed.

Owners and member counts require an extra Graph call per group, so enabling those options will make the report slower on tenants with many groups.