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


The Microsoft 365 admin center ( 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.


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.


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


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


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.

Sourced from: TomTalks Blog. View the original article here.

About Telecoms-Channel is your one-stop source for the latest news and insights from the telecoms industry in South Africa, where you get comprehensive coverage of the industry and keep up with the ever-evolving market landscape.

Whether you need to understand market trends, identify new opportunities, or stay informed of the latest developments, we have you covered.

In addition to bringing the best news together, we have access to an extensive supplier network that makes it easy for any telecoms company looking to tap into new markets or enter the telecoms industry. Take advantage of our expertise and contact us today to find your next partner!

Other posts you might be interested in

Single Request. Multiple Quotes. Save Thousands.