By default it is enabled for users to create the office365 groups. There are few organizations where they do not need to restrict this group creation because these groups are heavily influenced on utilizing the office365 services Sharepoint,Yammer, Microsoft Teams, PowerBI , Outlook, Planner and Road Map which in turn might decline the office 365 user adoption rate.
The below script can be used to run in task scheduler on a monthly basis for reviewing the Office 365 groups which have been created in last 30 days and will email us the report.
Below is the sample output of the script which will provide us the below details.

######################################################################################################################## # Description :- Powershell Script To extract office365 groups created less than 30 days time and send them in email # Author :- Sathish Veerapandian # Created :- 15-Jul-2019 # Updated :- 15-Oct-2019 # Version :- 0.2 # Notes :- ######################################################################################################################### $Header = @" TABLE {border-width: 1px; border-style: solid; border-color: black; border-collapse: collapse;} TH {border-width: 1px; padding: 3px; border-style: solid; border-color: black; background-color: #6495ED;} TD {border-width: 1px; padding: 3px; border-style: solid; border-color: black;} "@ # Load MFA Module $MFAExchangeModule = ((Get-ChildItem -Path $($env:LOCALAPPDATA+"\Apps\2.0\") -Filter CreateExoPSSession.ps1 -Recurse).FullName | Select-Object -Last 1) . "$MFAExchangeModule" # Initiate Session Connect-EXOPSSession -UserPrincipalname mentionadminid@domain.com # Get Office365 Groups Get-UnifiedGroup -ResultSize unlimited | select DisplayName,PrimarySMtpAddress,WhenCreated,ManagedBy,RecipientTypeDetails,AccessType | Export-Csv C:\Scripts\365groups.csv -NoTypeInformation # Define the date variable for Cutoffdate less than 31 days $CutoffDate = get-date -date $(get-date).adddays(-31) -format "M/dd/yyyy h:mm:ss tt" # Get the office365 groups created lesser than 31 days $Data = Import-CSV "C:\Scripts\365groups.csv" | Where-Object {$_.WhenCreated -as [datetime] -gt $CutoffDate} # Export the office365 groups created lesser than 31 days in csv file $data | ConvertTo-Html -Head $Header | Out-File -FilePath C:\Scripts\365.html # Send the exported csv email to the helpdesk team for evaluation Send-MailMessage -From senderemailID -To recipientemailid -Attachments "C:\Scripts\365.html" -BodyAsHtml -SmtpServer mentionsmtpserver -Subject Office365GroupStatus
Thanks
Sathish Veerapandian
Leave a Reply