Teams Usage Reports in Office 365 Admin Center

%3CLINGO-SUB%20id%3D%22lingo-sub-132709%22%20slang%3D%22en-US%22%3ETeams%20Usage%20Reports%20in%20Office%20365%20Admin%20Center%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-132709%22%20slang%3D%22en-US%22%3E%3CP%3EIt's%20nice%20to%20see%20the%20first%20two%20usage%20reports%20for%20Teams%20(user%20activity%20and%20device%20activity)%20turn%20up%20in%20the%20Office%20365%20Admin%20Center%2C%20but%20it%20looks%20as%20if%20guest%20user%20activity%20is%20excluded%20from%20the%20usage%20data.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F210%22%20target%3D%22_blank%22%3E%40Anne%20Michels%3C%2FA%3E%2C%20am%20I%20correct%3F%20If%20so%2C%20what's%20the%20logic%20of%20excluding%20guest%20user%20activity%20-%20is%20it%20because%20the%20Graph%20doesn't%20capture%20this%20data%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20800px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F24907i268FCA81FD1B9952%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22TeamsActivity.jpg%22%20title%3D%22TeamsActivity.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-132709%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-295430%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20Usage%20Reports%20in%20Office%20365%20Admin%20Center%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-295430%22%20slang%3D%22en-US%22%3E%3CP%3EDo%20we%20have%20any%20options%20to%20know%20How%20many%20minutes%20a%20individual%20Joined%20Teams%20meeting%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-173126%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20Usage%20Reports%20in%20Office%20365%20Admin%20Center%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-173126%22%20slang%3D%22en-US%22%3E%3CP%3Esince%20the%20option%20to%20invite%20guests%20with%20a%20few%20clicks%20is%20available%20a%20report%20of%20external%20users%20%2F%20guests%20is%20a%20must-have%20in%20my%20complaince%20-reports.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAny%20ideas%20when%20this%20feature%20will%20be%20available%20%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-132848%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20Usage%20Reports%20in%20Office%20365%20Admin%20Center%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-132848%22%20slang%3D%22en-US%22%3EInterested%20also%20on%20having%20an%20answer%20to%20the%20question%20done%20by%20Tony%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1291466%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20Usage%20Reports%20in%20Office%20365%20Admin%20Center%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1291466%22%20slang%3D%22en-US%22%3E%3CP%3EHi%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%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F210%22%20target%3D%22_blank%22%3E%40Anne%20Michels%2C%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20you%20are%20doing%20well.%20I%20am%20having%20to%20track%20the%20guests%20activity%20for%20my%20company.%20Has%20this%20question%20been%20answered%3F%20I%20basically%20have%20to%20find%20out%20the%20number%20of%20active%20guests%20per%20meeting%20or%20per%20user%20for%20my%20company%20each%20day.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20what%20you%20think.%26nbsp%3B%26nbsp%3B%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-1291490%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20Usage%20Reports%20in%20Office%20365%20Admin%20Center%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1291490%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F614130%22%20target%3D%22_blank%22%3E%40nicholasong1990%3C%2FA%3E%26nbsp%3B%20AFAIK%2C%20this%20data%20is%20not%20exposed%20in%20public%20interfaces%20(Graph%2C%20PowerShell%2C%20or%20audit%20logs).%20I%20wrote%20an%20article%20about%20how%20to%20identify%20obsolete%20guests%20a%20while%20ago%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.petri.com%2Fguest-account-obsolete-activity%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.petri.com%2Fguest-account-obsolete-activity.%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20looked%20at%20the%20Teams%20user%20activity%20Graph%20API%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Freportroot-getteamsuseractivityuserdetail%3Fview%3Dgraph-rest-1.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Freportroot-getteamsuseractivityuserdetail%3Fview%3Dgraph-rest-1.0%3C%2FA%3E.%20It%20supports%20call%20usage%2C%20but%20only%20for%20tenant%20users.%20As%20far%20as%20I%20can%20see%2C%20the%20Office%20365%20usage%20data%20in%20the%20Graph%20are%20for%20tenant%20users%20only.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1291534%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20Usage%20Reports%20in%20Office%20365%20Admin%20Center%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1291534%22%20slang%3D%22en-US%22%3E%3CP%3E%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%3EThank%20you%20for%20your%20reply.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoftteams%2Fteams-analytics-and-reports%2Fteams-usage-report%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoftteams%2Fteams-analytics-and-reports%2Fteams-usage-report%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20link%20above%20shows%20a%20column%20that%20is%20labeled%20guests.%20Is%20this%20defined%20to%20be%20the%20number%20of%20active%20guest%20users%20for%20each%20team(which%20is%20a%20class)%3F%20If%20so%2C%20can%20i%20just%20set%20the%20date%20range%20to%20be%20for%201%20day%20and%20export%20to%20excel%20and%20manipulate%20it%20there%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESome%20background%2C%20we%20are%20a%20learning%20centre%20that%20conducts%20hundreds%20of%20classes%20where%20our%20teachers%20are%20Microsoft%20corporate%20account%20users%20and%20they%20send%20team%20meeting%20invites%20to%20the%20students.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20trying%20to%20keep%20track%20of%20the%20daily%20participation%20of%20students%20in%20each%20class.%20Hence%20i%20assume%20that%201%20count%20of%20%22guest%22%20should%20signify%20activity%20by%201%20student%20for%20each%20meeting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20do%20you%20think%20of%20my%20work%20around%20and%20understanding%20here%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1291578%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20Usage%20Reports%20in%20Office%20365%20Admin%20Center%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1291578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F614130%22%20target%3D%22_blank%22%3E%40nicholasong1990%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Elooking%20at%20that%20report%20(Teams%20usage)%2C%20it%20seems%20like%20%22Guests%22%20is%20the%20number%20of%20active%20guests%20in%20a%20team%20during%20the%20reporting%20period.%20In%20some%20cases%2C%20the%20guest%20might%20have%20simply%20accessed%20the%20team%20and%20not%20done%20anything.%20But%20it%20could%20be%20enough%20for%20your%20purposes%2C%20once%20you%20understand%20that%20active%20doesn't%20mean%20sending%20a%20message%2C%20attending%20a%20meeting%2C%20or%20so%20on.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
MVP

It's nice to see the first two usage reports for Teams (user activity and device activity) turn up in the Office 365 Admin Center, but it looks as if guest user activity is excluded from the usage data. @Anne Michels, am I correct? If so, what's the logic of excluding guest user activity - is it because the Graph doesn't capture this data?

 

TeamsActivity.jpg

7 Replies
Highlighted
Interested also on having an answer to the question done by Tony
Highlighted

since the option to invite guests with a few clicks is available a report of external users / guests is a must-have in my complaince -reports.

 

Any ideas when this feature will be available ?  

Highlighted

Do we have any options to know How many minutes a individual Joined Teams meeting

Highlighted

Hi @Tony Redmond and @Anne Michels, 

 

I hope you are doing well. I am having to track the guests activity for my company. Has this question been answered? I basically have to find out the number of active guests per meeting or per user for my company each day. 

 

Please let me know what you think.  

 

 

Highlighted

@nicholasong1990  AFAIK, this data is not exposed in public interfaces (Graph, PowerShell, or audit logs). I wrote an article about how to identify obsolete guests a while ago https://www.petri.com/guest-account-obsolete-activity.

 

I looked at the Teams user activity Graph API https://docs.microsoft.com/en-us/graph/api/reportroot-getteamsuseractivityuserdetail?view=graph-rest.... It supports call usage, but only for tenant users. As far as I can see, the Office 365 usage data in the Graph are for tenant users only.

Highlighted

@Tony RedmondThank you for your reply. 

 

https://docs.microsoft.com/en-us/microsoftteams/teams-analytics-and-reports/teams-usage-report

 

The link above shows a column that is labeled guests. Is this defined to be the number of active guest users for each team(which is a class)? If so, can i just set the date range to be for 1 day and export to excel and manipulate it there? 

 

Some background, we are a learning centre that conducts hundreds of classes where our teachers are Microsoft corporate account users and they send team meeting invites to the students. 

 

We are trying to keep track of the daily participation of students in each class. Hence i assume that 1 count of "guest" should signify activity by 1 student for each meeting.

 

What do you think of my work around and understanding here? 

Highlighted

@nicholasong1990 

 

looking at that report (Teams usage), it seems like "Guests" is the number of active guests in a team during the reporting period. In some cases, the guest might have simply accessed the team and not done anything. But it could be enough for your purposes, once you understand that active doesn't mean sending a message, attending a meeting, or so on.