SOLVED

Can I determine how many Office 365 groups a user has created?

%3CLINGO-SUB%20id%3D%22lingo-sub-307282%22%20slang%3D%22en-US%22%3ECan%20I%20determine%20how%20many%20Office%20365%20groups%20a%20user%20has%20created%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307282%22%20slang%3D%22en-US%22%3E%3CP%3EOur%20business%20employees%20have%20embraced%20Office%20365%20groups%20in%20a%20big%20way%20and%20have%20started%20reaching%20the%20regrettable%20250-group-creation%20limit%20for%20non-admin%20accounts.%20Is%20there%20a%20way%20to%20determine%20how%20many%20Office%20365%20groups%20an%20account%20has%20created%20so%20we%20can%20tell%20if%20the%20account%20is%20about%20to%20turn%20into%20a%20pumpkin%20or%20do%20we%20just%20have%20to%20wait%20for%20them%20to%20suddenly%20not%20be%20able%20to%20create%20Office%20365%20groups%20anymore%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-307282%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Groups%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309131%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20determine%20how%20many%20Office%20365%20groups%20a%20user%20has%20created%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309131%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20Fred.%20I%20have%20left%20some%20votes%20and%20a%20note%20detailing%20our%20struggle%20on%20%2Flol%2Ffeedback%2C%20I%20mean%20User%20Voice.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309126%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20determine%20how%20many%20Office%20365%20groups%20a%20user%20has%20created%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309126%22%20slang%3D%22en-US%22%3E%3CP%3EHere%20is%20what%20Office%20365%20tech%20support%20responded%20with%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EAfter%20extensive%20research%2C%20only%20the%20Audit%20log%20and%20the%20group%20listing%20would%20be%20a%20way%20to%20see%20how%20many%20groups%20a%20specific%20user%20has%20created.%20%3CU%3EGroups%20created%20by%20this%20user%20will%20need%20to%20be%20deleted%20before%20he%2Fshe%20will%20be%20able%20to%20create%20more.%3C%2FU%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E%26nbsp%3B%3C%2FEM%3E%3C%2FP%3E%3CP%3EI%20wasn't%20able%20to%20get%20a%20response%20from%20the%20guy%20about%20what%20the%20%22group%20listing%22%20is%20that%20he%20was%20referring%20to%2C%20since%20no%20listing%20I've%20seen%20shows%20the%26nbsp%3B%3CEM%3Ecreators%3C%2FEM%3E%3B%20only%20the%26nbsp%3B%3CEM%3Eowners%3C%2FEM%3Ewhich%20is%20not%20the%20same%20thing.%20For%20now%20I%20will%20pass%20on%20to%20the%20LoB%20that%20we%20basically%20can't%20tell%20when%20an%20employee%20is%20going%20to%20max%20out%20and%20to%20try%20having%20people%20log%20into%20OWA%20with%20a%20new%20account%20ginned%20up%20just%20for%20making%20Office%20365%20groups%20until%20it%20too%20gets%20burned%20and%20then%20just%20order%20it%20deleted%20and%20have%20another%20one%20made.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307350%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20determine%20how%20many%20Office%20365%20groups%20a%20user%20has%20created%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307350%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F258727%22%20target%3D%22_blank%22%3E%40Kelp_Acres%3C%2FA%3E.%3C%2FP%3E%3CP%3EI've%20previously%20submitted%20a%20User%20Voice%20related%20to%20this%20issue%20to%20include%20%22Created%20By%22%20column%20in%20the%20SharePoint%20administration%20center.%20It%20may%20not%20prevent%20the%20250%20limit%20for%20creating%20Teams%20but%20should%20give%20admins%20visibility%20to%20coordinate%20with%20workspace%20owners.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Foffice365.uservoice.com%2Fforums%2F273493-office-365-admin%2Fsuggestions%2F33485983-office-365-group-owner%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Foffice365.uservoice.com%2Fforums%2F273493-office-365-admin%2Fsuggestions%2F33485983-office-365-group-owner%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fhashtag%2FFredO365tips%3Fsrc%3Dhash%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFred%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307336%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20determine%20how%20many%20Office%20365%20groups%20a%20user%20has%20created%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307336%22%20slang%3D%22en-US%22%3EInteresting%2C%20good%20to%20know%2C%20but%20yeah%20I%20agree%20kind%20of%20odd%20that%20the%20limit%20is%20set%20like%20that%20without%20a%20seeming%20way%20to%20Change%20the%20creators%20to%20something%20else%20to%20clear%20out%20there%20count%20or%20something%20somehow.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307333%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20determine%20how%20many%20Office%20365%20groups%20a%20user%20has%20created%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307333%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20we%20first%20encountered%20this%2C%20someone%20was%20setting%20up%20groups%20for%20all%20existing%20client%20accounts%20and%20then%20suddenly%20couldn't%20anymore%20after%20making%20a%20group%20for%20the%20250th%20account%20on%20the%20list.%20Here%20is%20what%20she%20recalls%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EWe%20thought%20it%20was%201%20and%20the%20same%2C%20so%20I%20removed%20Ownership%20from%20me%20on%20all%20the%20groups%2C%20and%20found%20out%20that%2C%20even%20when%20I%20gave%20them%20away%2C%20after%20my%20email%20address%20%3C%2FEM%3E%5BUPN%5D%3CEM%3Ehad%20created%20250%20groups%2C%20I%20could%20no%20longer%20make%20any%20groups.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E%26nbsp%3B%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EWe%20went%20through%20Microsoft%2C%20and%20it%20is%20correct%2C%20250%20groups%20created%20is%20a%20user%20limit.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20her%20specific%20case%2C%20she%20is%20a%20very%20trusted%20employee%20so%20I%20elevated%20her%20account%20to%20admin%20so%20she%20could%20finish%20her%20project%20and%20then%20busted%20her%20back%20down%20to%20private%20again.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20see%20where%20%22created%20by%22%20is%20a%20unified-group%20property%20and%20if%20the%20user%20who%20created%20the%20group%20doesn't%20own%20it%2C%20then%20why%20even%20track%20it%20in%20a%20way%20that%20burns%20the%20user%20after%20only%20250.%20It's%20an%20odd%20limitation%20to%20build%20into%20something%20that%20is%20supposed%20to%20move%20this%20menial%20task%20out%20of%20IT%20and%20into%20the%20line%20of%20business%2C%20where%20it%20is%20going%20to%20be%20performed%20by%20some%20administrative%20person%2C%20until%2C%20oops%2C%20they%20can't%20do%20it%20anymore.%20Unless%20they%20are%20in%20the%20IT%20Dept.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307327%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20determine%20how%20many%20Office%20365%20groups%20a%20user%20has%20created%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307327%22%20slang%3D%22en-US%22%3EI%20don't%20see%20how%20they%20could%20track%20it%20either.%20Curious%20if%20you%20can%20only%20be%20owner%20of%20250%20and%20that's%20how%20they%20limit%20it%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307307%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20determine%20how%20many%20Office%20365%20groups%20a%20user%20has%20created%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307307%22%20slang%3D%22en-US%22%3E%3CP%3EApart%20from%20harvesting%20the%20Audit%20logs%2C%20I'm%20not%20aware%20of%20any%20method%20to%20list%20all%20groups%20created%20by%20a%20specific%20person.%20You%20can%20guesstimate%20the%20value%20based%20on%20the%20number%20of%20groups%20he's%20an%20owner%20of%2C%20but%20that's%20not%20a%201%3A1%20correspondence.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Our business employees have embraced Office 365 groups in a big way and have started reaching the regrettable 250-group-creation limit for non-admin accounts. Is there a way to determine how many Office 365 groups an account has created so we can tell if the account is about to turn into a pumpkin or do we just have to wait for them to suddenly not be able to create Office 365 groups anymore?

7 Replies
Highlighted
Solution

Apart from harvesting the Audit logs, I'm not aware of any method to list all groups created by a specific person. You can guesstimate the value based on the number of groups he's an owner of, but that's not a 1:1 correspondence.

Highlighted
I don't see how they could track it either. Curious if you can only be owner of 250 and that's how they limit it?
Highlighted

When we first encountered this, someone was setting up groups for all existing client accounts and then suddenly couldn't anymore after making a group for the 250th account on the list. Here is what she recalls:

 

We thought it was 1 and the same, so I removed Ownership from me on all the groups, and found out that, even when I gave them away, after my email address [UPN] had created 250 groups, I could no longer make any groups.

 

We went through Microsoft, and it is correct, 250 groups created is a user limit.

 

In her specific case, she is a very trusted employee so I elevated her account to admin so she could finish her project and then busted her back down to private again. 

 

I don't see where "created by" is a unified-group property and if the user who created the group doesn't own it, then why even track it in a way that burns the user after only 250. It's an odd limitation to build into something that is supposed to move this menial task out of IT and into the line of business, where it is going to be performed by some administrative person, until, oops, they can't do it anymore. Unless they are in the IT Dept.

 

 

Highlighted
Interesting, good to know, but yeah I agree kind of odd that the limit is set like that without a seeming way to Change the creators to something else to clear out there count or something somehow.
Highlighted

Hi, @Kelp_Acres.

I've previously submitted a User Voice related to this issue to include "Created By" column in the SharePoint administration center. It may not prevent the 250 limit for creating Teams but should give admins visibility to coordinate with workspace owners. 

 

https://office365.uservoice.com/forums/273493-office-365-admin/suggestions/33485983-office-365-group...

 

Fred

 

Here is what Office 365 tech support responded with:

 

After extensive research, only the Audit log and the group listing would be a way to see how many groups a specific user has created. Groups created by this user will need to be deleted before he/she will be able to create more.

 

I wasn't able to get a response from the guy about what the "group listing" is that he was referring to, since no listing I've seen shows the creators; only the owners which is not the same thing. For now I will pass on to the LoB that we basically can't tell when an employee is going to max out and to try having people log into OWA with a new account ginned up just for making Office 365 groups until it too gets burned and then just order it deleted and have another one made.

 

Highlighted

Thanks, Fred. I have left some votes and a note detailing our struggle on /lol/feedback, I mean User Voice.