Tom Talks Microsoft Teams and Microsoft 365 news and opinions

Microsoft Teams audio, video and screen sharing minutes per user reports in Microsoft 365 Usage Reports

image

The Microsoft 365 admin center (portal.office.com) offers usage reports for a lot of the main services,

Reports are available for the last 7 days, 30 days, 90 days, and 180 days. Reports are typically around 48 hours behind.

image

Previous to this update we simply got a per user count of each of the following:

  • Channel Messages
  • Chat Messages
  • 1:1 Calls
  • Meetings

This is still the default of the Web UI view.

image

However, if you click the “choose columns button” or do the Excel export, you can now also get the following:

image

New fields give the total minutes for each user for the 7, 30, 90 or 180 day period.

It reports minutes for:

  • Audio Duration
  • Video Duration
  • Screen Share Duration

We also get:

  • Meetings Organized Count
  • Meetings Attended Count
  • AdHoc Meetings Organized Count
  • AdHoc Meetings Attended Count
  • Scheduled Meetings Organized Count

Thanks to Raj Gorsia for letting me know about this change.

You can also export this to excel. The exported format for audio time, video time and screen share time follows ISO8601 date format, which is a bit of a pain as it comes out like this: “P3DT14H20M45S

image

P is the duration designator for period – which just denotes that its a value for a period of time.

D is the day designator that follows the value for the number of days.

T is the time designator that precedes the time components of the representation.

H is the hour designator that follows the value for the number of hours.

M is the minute designator that follows the value for the number of minutes.

S is the second designator that follows the value for the number of seconds.

So, “P3DT14H20M45S” is 3 days, 14 hours, 20 minutes and 45 seconds. It also outputs 0 values as this “PT0S” making it a pain to convert the values with a formula.

Still, it’s great to finally get some per user minutes reports without needing to leverage the call records API.

Be sure to subscribe for blog email updates for more Microsoft Teams reporting updates.

About the author

Tom Arbuthnot

A Microsoft MVP and Microsoft Certified Master, Tom Arbuthnot is Principal Solutions Architect at Microsoft Collaboration specialists Modality Systems.

Tom stays up to date with industry developments and shares news and his opinions on his blog, Microsoft Teams Podcast and email list. He is a regular speaker at events around the world.

2 comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Tom Talks Microsoft Teams and Microsoft 365 news and opinions