Get Created Date of Microsoft 365 Groups Using Microsoft Graph

This article will show you how to get the creation date of all your Azure Active Directory groups using a PowerShell script. This is important for auditing purposes and can be used in other scripts to remove any groups that were created after a certain date.

Connect to Microsoft Graph PowerShell

To perform this task, you need install Microsoft Graph PowerShell modules before you can connect to Microsoft Graph API.

1. Before you begin, let’s install the modules following this article.

2. Connect to Microsoft Graph using required scope then sign-in using a global admin account.

Connect-MgGraph -Scope Group.Read.All

3. Run the following script to get the CreatedDateTime of all Microsoft 365 groups in a tenant.

$Report = @()
$Groups = Get-MgGroup -All
foreach ($Group in $Groups) {

    $ObjReport = [PSCustomObject]@{
    DisplayName = $Group.DisplayName    
    Mail     = $Group.Mail
    CreationDate  = $Group.CreatedDateTime
    }

$Report += $ObjReport

}

$Report | Format-Table

$Report | Format-Table

DisplayName Mail                            CreationDate
----------- ----                            ------------
Finance     [email protected]            7/25/2022 3:33:15 PM
M365G       [email protected]              7/18/2022 3:06:48 PM
SSPS        [email protected]               8/8/2022 7:13:41 AM
IT          [email protected]                 8/4/2022 2:24:52 PM
Bon Ben     [email protected]          7/25/2022 2:08:50 PM
Bon Ben     [email protected] 7/3/2022 4:30:40 AM
DL1         [email protected]                7/18/2022 3:11:24 PM
Rest of R&D [email protected]               7/26/2022 4:08:17 AM
R&D         [email protected]                7/26/2022 4:05:59 AM

You can export the results output to a csv file using following command:

$Report | Export-Csv C:\Report_GroupCreatedDate.csv -Nti

Get CeatedDate for a single group

In some cases, you just need get the creation date for a single group only.

1. First, run Get-MgGroup command to find out the group ids.

Get-MgGroup -All

Id                                   DisplayName Description                                                   GroupTypes AccessType
--                                   ----------- -----------                                                   ---------- ----------
181b9ed2-ecf8-49da-bca1-7088af72251f Finance                                                                   {Unified}
1d60a3e4-04ad-4631-bcca-4e5c8d3a6a81 M365G       M365G                                                         {Unified}
43678fdb-2e72-410d-807c-1ee4f89628ef SSPS        SSPS                                                          {Unified}
74029cc4-4776-43ad-9fbd-946ee7ee040d IT                                                                        {Unified}
76c65d3f-4baf-47d2-941f-769d3fed9e0e Bon Ben     Check here for organization announcements and important info. {Unified}
7fa305ba-61ef-4340-9d71-0ff9fa79192f Bon Ben     Bon Ben                                                       {Unified}
a4bb6c1d-d485-484b-87e6-bfb298abb3fd DL1         DL1                                                           {}
c00c4ca7-cb70-407c-868c-5914b8a31578 Rest of R&D Rest of R&D                                                   {Unified}
c16931e9-4771-442d-af64-389b3ea06244 R&D         R&D                                                           {Unified}

Or you can run the following command to get all groups whose display name contains ‘Finance‘.

Get-MgGroup -All -ConsistencyLevel eventual -Count GroupCount -Search '"Displayname:Finance"'

Id                                   DisplayName Description GroupTypes AccessType
--                                   ----------- ----------- ---------- ----------
181b9ed2-ecf8-49da-bca1-7088af72251f Finance                 {Unified}

2. Finally, run the following command to export the CreatedDate of a group.

(Get-MgGroup -GroupId 181b9ed2-ecf8-49da-bca1-7088af72251f).CreatedDateTime

Monday, July 25, 2022 3:33:15 PM