GUID confusion for Office 365 Groups

%3CLINGO-SUB%20id%3D%22lingo-sub-238474%22%20slang%3D%22en-US%22%3EGUID%20confusion%20for%20Office%20365%20Groups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-238474%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20developing%20an%20app%20which%20will%20get%20Office%20365%20Activity%20details%20and%20trying%20to%20map%20with%20Single%20owner%20Office%20365%20groups%20(custom%20function).%20But%20the%20activities%20are%20not%20contains%20name%20of%20the%20Office%20365%20Group%20and%20owner%20name.%26nbsp%3B%26nbsp%3BInstead%20it%20displays%20a%20GUID%20because%20below%20settings%20is%20enabled%20in%20Office%20365%20ports.%20Those%20GUID%20ids%20are%20not%20matching%20with%20group%20GUID.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPortal%20configuration%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESample%20activities%3A%3C%2FP%3E%3CP%3EReport%20Refresh%20Date%2C%3CSTRONG%3EGroup%20Display%20Name%3C%2FSTRONG%3E%2CIs%20Deleted%2C%3CSTRONG%3EOwner%20Principal%20Name%3C%2FSTRONG%3E%2CLast%20Activity%20Date%2CGroup%20Type%2CMember%20Count%2CExternal%20Member%20Count%2CExchange%20Received%20Email%20Count%2CSharePoint%20Active%20File%20Count%2CYammer%20Posted%20Message%20Count%2CYammer%20Read%20Message%20Count%2CYammer%20Liked%20Message%20Count%2CExchange%20Mailbox%20Total%20Item%20Count%2CExchange%20Mailbox%20Storage%20Used%20(Byte)%2CSharePoint%20Total%20File%20Count%2CSharePoint%20Site%20Storage%20Used%20(Byte)%2CReport%20Period%3CBR%20%2F%3E2018-08-25%3CSTRONG%3E%2CB2FAC040CC5A824ED378389A571D61EC%3C%2FSTRONG%3E%2CFalse%2C%3CSTRONG%3EC877B17718CF963D677F40DAD0EA6962%3C%2FSTRONG%3E%2C2018-08-22%2CPrivate%2C2%2C0%2C%2C3%2C%2C%2C%2C430%2C4378623%2C3%2C1808281%2C30%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20is%20the%20case%20how%20I%20can%20analyze%20the%20report%20for%20Office%20365%20Groups%20and%20its%20activities.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20identify%20the%20group%20name%20base%20on%20GUID%20return%20by%20MS%20Graph%20API%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMS%20graph%20API%20Used%3A%26nbsp%3Breports%2FgetOffice365GroupsActivityDetail(period%3D'D30')%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-238474%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EGraph%20API%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Groups%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eofiice%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239758%22%20slang%3D%22en-US%22%3ERe%3A%20GUID%20confusion%20for%20Office%20365%20Groups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239758%22%20slang%3D%22en-US%22%3E%3CP%3EWell%20that's%20kind%20of%20the%20point%20of%20using%20anonymization%2C%20you%20cannot%20tell%20the%20exact%20user%2Fobject.%20I'm%20not%20sure%20what%20the%20exact%20algorithm%20to%20generate%20those%20IDs%20is%2C%20probably%20is%20a%20combination%20with%20the%20tenant%20and%20user's%20GUID%2C%20and%20I'm%20not%20aware%20of%20any%20public%20document%20detailing%20it.%20If%20you%20need%20to%20see%20the%20actual%20object%20IDs%2C%20disable%20this%20option.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239381%22%20slang%3D%22en-US%22%3ERe%3A%20GUID%20confusion%20for%20Office%20365%20Groups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239381%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%26nbsp%3B%3CSPAN%3Eanonymization%20feature%20is%20enabled.%20If%20I%20disable%20the%26nbsp%3Banonymization%20then%20I%20get%20the%20group%20name%20in%20plain%20text.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20question%20here%20is%2C%20if%26nbsp%3Banonymization%20is%20enabled%20then%20how%20to%20find%20out%2F%20map%20activities%20with%20the%20group%20because%20the%20activity%20GUID%20under%20%22Group%20principal%20name%20%22%20is%26nbsp%3B%20not%20matching%20with%20actual%20group%20GUID.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-239361%22%20slang%3D%22en-US%22%3ERe%3A%20GUID%20confusion%20for%20Office%20365%20Groups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239361%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20me%20the%20report%20displays%20the%20Group%20name%20just%20fine.%20Are%20you%20perhaps%20using%20the%20%22anonymization%22%20feature%20for%20the%20reports%2C%20which%20you%20can%20configure%20under%20%3CA%20href%3D%22https%3A%2F%2Fportal.office.com%2Fadminportal%2Fhome%23%2FSettings%2FServicesAndAddIns%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fportal.office.com%2Fadminportal%2Fhome%23%2FSettings%2FServicesAndAddIns%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi,

 

I am developing an app which will get Office 365 Activity details and trying to map with Single owner Office 365 groups (custom function). But the activities are not contains name of the Office 365 Group and owner name.  Instead it displays a GUID because below settings is enabled in Office 365 ports. Those GUID ids are not matching with group GUID. 

 

Portal configuration:

 

Sample activities:

Report Refresh Date,Group Display Name,Is Deleted,Owner Principal Name,Last Activity Date,Group Type,Member Count,External Member Count,Exchange Received Email Count,SharePoint Active File Count,Yammer Posted Message Count,Yammer Read Message Count,Yammer Liked Message Count,Exchange Mailbox Total Item Count,Exchange Mailbox Storage Used (Byte),SharePoint Total File Count,SharePoint Site Storage Used (Byte),Report Period
2018-08-25,B2FAC040CC5A824ED378389A571D61EC,False,C877B17718CF963D677F40DAD0EA6962,2018-08-22,Private,2,0,,3,,,,430,4378623,3,1808281,30

 

If this is the case how I can analyze the report for Office 365 Groups and its activities.

 

Is there any way to identify the group name base on GUID return by MS Graph API

 

MS graph API Used: reports/getOffice365GroupsActivityDetail(period='D30')

 

 

3 Replies

For me the report displays the Group name just fine. Are you perhaps using the "anonymization" feature for the reports, which you can configure under https://portal.office.com/adminportal/home#/Settings/ServicesAndAddIns

Yes, anonymization feature is enabled. If I disable the anonymization then I get the group name in plain text. 

 

The question here is, if anonymization is enabled then how to find out/ map activities with the group because the activity GUID under "Group principal name " is  not matching with actual group GUID.

Well that's kind of the point of using anonymization, you cannot tell the exact user/object. I'm not sure what the exact algorithm to generate those IDs is, probably is a combination with the tenant and user's GUID, and I'm not aware of any public document detailing it. If you need to see the actual object IDs, disable this option.