Useful PowerShell cmdlets to administer Office 365 Groups – Part 2

12th May 2018

Hey folks, hope you enjoyed my First blog on PowerShell cmdlets and as promised here is the sequel to the previous blog. Today we shall discuss some more PowerShell cmdlets that help managing your Office 365 groups even better. So, without much ado lets dive straight into that.

In this scenario, I’ve created a SharePoint subsite named “Usage Guidelines” which speaks about all the guidelines a user must follow while using Office 365 groups in my organization and the user can refer that while creating / using Office 365 groups. Once this has been enabled this what the end user view would be like. Please check the screenshot below.

In this scenario, I’ve created a SharePoint subsite named“Usage Guidelines” which speaks about all the guidelines a user must follow while using Office 365 groups in my organization and the user can refer that while creating / using Office 365 groups. Once this has been enabled this what the end user view would be like. Please check the screenshot below.

Scenario 4: Restrict all access for guest users to Groups including the ones that were already granted access

Like any object, an Office 365 Group might become unused over time. No current method exists to detect what groups are underused, so here's a script that does the job for you by checking audit records to establish whether any SharePoint file activity has occurred in the group document library in the last 90 days and whether any conversations have happened in the group mailbox in the last year. Seeing that it's all done in simple PowerShell, you can tailor the code to your heart's content. A HTML report file is generated at the end, which contains some statistics like:

15. To get the list of Obsolete Office 365 groups in your tenant:

This is a PowerShell script from Office 365 fame Tony Redmond and the explanation for the script can be found below.

Like any object, an Office 365 Group might become unused over time. No current method exists to detect what groups are underused, so here's a script that does the job for you by checking audit records to establish whether any SharePoint file activity has occurred in the group document library in the last 90 days and whether any conversations have happened in the group mailbox in the last year. Seeing that it's all done in simple PowerShell, you can tailor the code to your heart's content. A HTML report file is generated at the end, which contains some statistics like: