Using PowerShell to report obsolete Office 365 Groups (and Teams)

%3CLINGO-SUB%20id%3D%22lingo-sub-147814%22%20slang%3D%22en-US%22%3EUsing%20PowerShell%20to%20report%20obsolete%20Office%20365%20Groups%20(and%20Teams)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147814%22%20slang%3D%22en-US%22%3E%3CP%3EOffice%20365%20Groups%20(and%20Teams)%20can%20quickly%20become%20obsolete%2C%20but%20administrators%20need%20some%20help%20to%20find%20the%20underused%20groups.%20PowerShell%20comes%20to%20the%20rescue%20through%20a%20mixture%20of%20checks%20against%20the%20group%20mailbox%2C%20Office%20365%20audit%20log%2C%20and%20Teams%20compliance%20records.%20A%20nice%20HTML%20report%20is%20the%20result%20%E2%80%93%20and%20isn%E2%80%99t%20that%20always%20welcome.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.petri.com%2Fidentifying-obsolete-office-365-groups-powershell%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.petri.com%2Fidentifying-obsolete-office-365-groups-powershell%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-147814%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-148053%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20PowerShell%20to%20report%20obsolete%20Office%20365%20Groups%20(and%20Teams)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-148053%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20be%20very%20useful%2C%20thanks%20for%20sharing.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2164034%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20PowerShell%20to%20report%20obsolete%20Office%20365%20Groups%20(and%20Teams)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2164034%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F64%22%20target%3D%22_blank%22%3E%40Tony%20Redmond%3C%2FA%3E%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWas%20really%20interested%20in%20using%20this%20script%20but%20I%20am%20not%20able%20to%20locate%20it%20through%20the%20link%20that%20you%20provided%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpetri.com%2Fidentifying-obsolete-office-365-groups-powershell%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpetri.com%2Fidentifying-obsolete-office-365-groups-powershell%3C%2FA%3E%26nbsp%3Bthe%20Technet%20forum%20does%20not%20seem%20to%20have%20it%20either%20unless%20I'm%20not%20looking%20in%20the%20right%20location.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fgallery.technet.microsoft.com%2FCheck-for-obsolete-Office-c0020a42%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgallery.technet.microsoft.com%2FCheck-for-obsolete-Office-c0020a42%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2164072%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20PowerShell%20to%20report%20obsolete%20Office%20365%20Groups%20(and%20Teams)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2164072%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F27934%22%20target%3D%22_blank%22%3E%40Mariusz%20Walczuk%3C%2FA%3E%26nbsp%3BThe%20TechNet%20Gallery%20is%20closed%2C%20so%20I%20moved%20discussion%20of%20the%20report%20script%20to%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Foffice365itpros.com%2F2020%2F01%2F14%2Foffice-365-groups-teams-activity-report%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Foffice365itpros.com%2F2020%2F01%2F14%2Foffice-365-groups-teams-activity-report%2F%3C%2FA%3E.%20You%20can%20now%20get%20it%20from%20GitHub.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2164086%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20PowerShell%20to%20report%20obsolete%20Office%20365%20Groups%20(and%20Teams)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2164086%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20very%20much%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F64%22%20target%3D%22_blank%22%3E%40Tony%20Redmond%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
MVP

Office 365 Groups (and Teams) can quickly become obsolete, but administrators need some help to find the underused groups. PowerShell comes to the rescue through a mixture of checks against the group mailbox, Office 365 audit log, and Teams compliance records. A nice HTML report is the result – and isn’t that always welcome.


https://www.petri.com/identifying-obsolete-office-365-groups-powershell

4 Replies

Could be very useful, thanks for sharing.

Hi @Tony Redmond

 

Was really interested in using this script but I am not able to locate it through the link that you provided in https://petri.com/identifying-obsolete-office-365-groups-powershell the Technet forum does not seem to have it either unless I'm not looking in the right location. 

 

https://gallery.technet.microsoft.com/Check-for-obsolete-Office-c0020a42

@Mariusz Walczuk The TechNet Gallery is closed, so I moved discussion of the report script to https://office365itpros.com/2020/01/14/office-365-groups-teams-activity-report/. You can now get it from GitHub.