SOLVED

Exporting User Activity Report

%3CLINGO-SUB%20id%3D%22lingo-sub-1503252%22%20slang%3D%22en-US%22%3EExporting%20User%20Activity%20Report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1503252%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20poking%20all%20over%20the%20place%2C%20including%20the%20%22Teams%20User%20Activity%22%20reports%2C%20and%20graph%20APIs%2C%20but%20I'm%20not%20finding%20what%20I'd%20think%20would%20be%20fairly%20obvious.%26nbsp%3B%20Under%20the%20Teams%20User%20Activity%20report%2C%20it%20shows%20a%20summary%20of%20the%20activity%20for%20the%20period%20requested.%20Without%20having%20to%20drill%20down%20into%20each%20user%2C%20is%20there%20a%20way%20to%20have%20it%20list%20all%20the%20activity%20broken%20out%3F%26nbsp%3B%20Basically%20I%20want%20an%20export%20of%20the%20%22Call%20History%22%20as%20shown%20under%20the%20user%20profile%2C%20but%20for%20all%20users.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1503252%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EActivity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1503324%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20User%20Activity%20Report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1503324%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20know%20it%20is%20more%20for%20the%20Quality%20side%20of%20things%20but%20it%20may%20be%20worth%20checking%20out%20the%20Call%20Quality%20Dashboard.%20There%20is%20a%20link%20from%20the%20Teams%20Admin%20Centre.%3CBR%20%2F%3E%3CBR%20%2F%3EOr%20take%20a%20look%20at%20the%20M365%20CLI.%20There%20are%20some%20reports%20there%20that%20essentially%20will%20utilise%20the%20Graph%20but%20it%20might%20be%20easier%20for%20you%20to%20script%20it%20to%20get%20at%20what%20you%20need.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3E%3CBR%20%2F%3EHenry%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1519537%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20User%20Activity%20Report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1519537%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F693840%22%20target%3D%22_blank%22%3E%40henryarphillips365%3C%2FA%3EThanks%20for%20the%20response%2C%20but%20it's%20not%20the%20quality%20data%20I'm%20after%2C%20though%20if%20the%20call%20history%20was%20there%2C%20I'd%20take%20it.%26nbsp%3B%20I'm%20just%20looking%20to%20be%20able%20to%20export%20the%20call%20log%2Factivity%20for%20users.%26nbsp%3B%20The%20Call%20Quality%20Dashboard%20doesn't%20appear%20to%20offer%20that%2C%20or%20my%20browser%20is%20hiding%20buttons%2C%20links%2C%20or%20clicks.%20I%20can't%20even%20seem%20to%20drill%20down%20into%20a%20day%20activity.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThrough%20the%20CQD%2C%20I%20tried%20going%20through%20the%20various%20detail%20reports%2C%20and%20ended%20up%20in%20helpdesk%20where%20it%20appears%20I%20can%20see%20the%20call%20details%2C%20but%20not%20who%20the%20call%20is%20between%20or%20maybe%20it's%20just%20the%20scope%20of%20the%20calls%20being%20displayed.%20Also%20not%20entirely%20sure%20why%20it%20seems%20to%20be%20obsessed%20with%20a%20specific%20date%2C%20and%20nothing%20recent.%26nbsp%3B%20Additionally%2C%20even%20when%20specifying%20a%20user%2C%20there%20doesn't%20appear%20to%20be%20an%20export%20option.%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-1519627%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20User%20Activity%20Report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1519627%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342739%22%20target%3D%22_blank%22%3E%40jangliss%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EMmmmmm%2C%20I%20see%20what%20you%20mean%20there%20doesn't%20seem%20to%20be%20anything%20to%20tap%20into%20the%20Call%20History%20programmatically.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20will%20keep%20hunting%20and%20let%20you%20know%20if%20I%20find%20anything.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20to%20throw%20it%20out%20there%20if%20by%20any%20chance%20the%20calls%20you%20are%20wanting%20to%20see%20the%20history%20of%20are%20PSTN%20calls%20you%20may%20still%20find%20them%20in%20the%20Legacy%20Portal%20or%20by%20way%20of%20the%20Get-CSOnlinePSTNUsage%20PowerShell%20cmdlet.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22henryarphillips365_0-1594666373586.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F205088i7AEEEB25BD6778C8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22henryarphillips365_0-1594666373586.png%22%20alt%3D%22henryarphillips365_0-1594666373586.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHenry%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1519695%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20User%20Activity%20Report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1519695%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342739%22%20target%3D%22_blank%22%3E%40jangliss%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20going%20to%20look%20for%20ideas%20from%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.lee-ford.co.uk%2Fget-cssessions-skype-online%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.lee-ford.co.uk%2Fget-cssessions-skype-online%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1519700%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20User%20Activity%20Report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1519700%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342739%22%20target%3D%22_blank%22%3E%40jangliss%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ENow%20this%20looks%20interesting%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftomtalks.blog%2F2020%2F06%2Fmicrosoft-teams-call-records-api-now-generally-available%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftomtalks.blog%2F2020%2F06%2Fmicrosoft-teams-call-records-api-now-generally-available%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529161%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20User%20Activity%20Report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529161%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F693840%22%20target%3D%22_blank%22%3E%40henryarphillips365%3C%2FA%3E%20This%20does%20look%20to%20have%20a%20little%20more%20promise%20than%20the%20CQD.%26nbsp%3B%20I'll%20have%20a%20poke%20into%20it%2C%20it%20seems%20to%20be%20designed%20as%20a%20subscribed%20service%20in%20terms%20of%20a%20webhook%20to%20pull%20the%20call%20details%20down.%26nbsp%3B%20Now%20if%20only%20they%20had%20the%20same%20API%20but%20with%20the%20ability%20to%20specify%20date%20ranges%20it'd%20be%20perfect%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20really%20appreciate%20the%20extra%20effort.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

I've been poking all over the place, including the "Teams User Activity" reports, and graph APIs, but I'm not finding what I'd think would be fairly obvious.  Under the Teams User Activity report, it shows a summary of the activity for the period requested. Without having to drill down into each user, is there a way to have it list all the activity broken out?  Basically I want an export of the "Call History" as shown under the user profile, but for all users.

6 Replies
Highlighted
Best Response confirmed by ThereseSolimeno (Microsoft)
Solution
Hi,

I know it is more for the Quality side of things but it may be worth checking out the Call Quality Dashboard. There is a link from the Teams Admin Centre.

Or take a look at the M365 CLI. There are some reports there that essentially will utilise the Graph but it might be easier for you to script it to get at what you need.

Thanks

Henry
Highlighted

@henryarphillips365Thanks for the response, but it's not the quality data I'm after, though if the call history was there, I'd take it.  I'm just looking to be able to export the call log/activity for users.  The Call Quality Dashboard doesn't appear to offer that, or my browser is hiding buttons, links, or clicks. I can't even seem to drill down into a day activity.

 

Through the CQD, I tried going through the various detail reports, and ended up in helpdesk where it appears I can see the call details, but not who the call is between or maybe it's just the scope of the calls being displayed. Also not entirely sure why it seems to be obsessed with a specific date, and nothing recent.  Additionally, even when specifying a user, there doesn't appear to be an export option.

 

 

Highlighted

@jangliss 

Mmmmmm, I see what you mean there doesn't seem to be anything to tap into the Call History programmatically.

I will keep hunting and let you know if I find anything.

 

Just to throw it out there if by any chance the calls you are wanting to see the history of are PSTN calls you may still find them in the Legacy Portal or by way of the Get-CSOnlinePSTNUsage PowerShell cmdlet.

henryarphillips365_0-1594666373586.png

 

 

Thanks

 

Henry

Highlighted
Highlighted

Thanks @henryarphillips365 This does look to have a little more promise than the CQD.  I'll have a poke into it, it seems to be designed as a subscribed service in terms of a webhook to pull the call details down.  Now if only they had the same API but with the ability to specify date ranges it'd be perfect :)

 

I really appreciate the extra effort. Thanks!