How to Export Microsoft Teams Meeting Attendance Report

Managing Teams meeting attendance isn’t just about tracking participants, it also involves enforcing organizational policies and handling meeting data. Organizers have specific settings that allow them to hide meeting attendance or apply certain compliance rules for their meetings. In such cases, admins can manage attendance reports through the Teams admin center to control visibility and restrict report access for organizers as needed.

Note: Disabling access to meeting attendance reports for organizers does not affect administrative audit or compliance access.

Enable attendance and engagement report using Teams admin center

• On, but organizers can turn it off: It allows organizers to view and download the attendance and engagement reports by default. They can also disable it in their meeting options.
• Off: Organizers cannot view or download attendance and engagement reports for the meetings they organize.
• On: Organizers can view and download meeting attendance reports for all meetings they create but cannot disable this feature.

Note: Organizers with a Teams Premium license can view engagement insights. These include how many attendees unmuted, turned on their cameras, raised hands, used reactions, or participated in Q&A during the meeting.

Manage attendance and engagement report policies using PowerShell

Managing attendance and engagement report settings through the Teams admin center often requires navigating multiple tabs, which can be a time-consuming process. With PowerShell, admins can configure these policies quickly using a single cmdlet.

Controlling participant inclusion in meeting attendance reports is important for security and compliance. By default, Teams meeting attendees' details are included, which may expose sensitive information if not properly managed. Admins can configure this setting to protect privacy, align with organizational policies, and ensure only relevant data is recorded.

Manage participant inclusion in meeting attendance report via Teams admin center

Along with attendee inclusion, admins can also control what kind of information is shown in reports that are accessed by organizers or attendees.

Configure attendee information in attendance report via Teams admin center

You can also decide what details of participants should be shown in the report using the "Attendee information" drop-down. This setting has the following drop-down options.

Note: To apply this setting for all participants in your organization, you can configure it in the Global (org-wide default) policy. However, these settings do not apply to external participants.

Tracking both the meetings a user has organized and those they've attended is crucial for gaining complete visibility into their meeting activity. This is especially important during internal audits, security investigations, or when verifying participation in sensitive meetings, particularly when you need to see who attended a Teams meeting if you are not the organizer. This helps to strengthen accountability, ensure compliance, and support informed decisions through user engagement insights.

Get meetings organized and attended by a specific user using Teams admin center

• Log in to the Microsoft Teams admin center and navigate to Users»Manage users.
• Select the specific user whose meeting details you want to investigate.
• In the user's profile, go to the Meetings & Calls tab to view the list of meetings the user organized and participated in.
• You’ll see key details such as the meeting or call id, start time, duration, participants, and more, and you can also click a specific meeting id to export Teams meeting attendee details.

Note: The Microsoft Teams admin center only retains detailed participant and meeting data for up to 30 days.

Although the Teams admin center provides meeting details for specific users, it is not possible to filter out the meetings a user has participated in. However, identifying meetings a specific user attends is essential for several scenarios. These include investigating a suspected account compromise, or verifying that C-suite meetings are attended only by authorized participants.

Find meetings attended by a specific user using Microsoft Purview

• Log in to the Microsoft Purview portal and navigate to Solutions»Audit»Search.
• In the Users field, select the specific user you want to investigate and also customize the date range.
• In the Workloads drop-down, choose Microsoft Teams.
• Enter MeetingParticipantDetail under Activities - operation names.
• Click Search to view all meetings attended by that specific user with details such as date, IP address, meeting id, etc.

Get specific users’ Teams meeting attended details using PowerShell

$targetAttendee = "<user@domain.com>"
Search-UnifiedAuditLog -StartDate '<YYYY-MM-DD>' -EndDate '<YYYY-MM-DD>' -Operations "MeetingParticipantDetail" |
ForEach-Object {
	$data = $_.AuditData | ConvertFrom-Json
	$createdBy = $_.UserIds
	$join = Get-Date $data.JoinTime -Format "yyyy-MM-dd hh:mm"
	$leave = Get-Date $data.LeaveTime -Format "yyyy-MM-dd hh:mm"
	$data.Attendees | Where-Object { $_.UPN -eq $targetAttendee } | ForEach-Object {
		[pscustomobject]@{
			'Meeting ID'    = $data.MeetingDetailId
			'Created By'    = $createdBy
			'Attendee'      = if ($_.AttendeesInfo -ne 'User') { $_.DisplayName } else { (Get-ExoRecipient -Identity $_.userObjectId).DisplayName }
			'Attendee Type' = $_.RecipientType
			'Joined Time'   = $join
			'Left Time'     = $leave
		}
	}
} | Format-Table -AutoSize

Retrieve Teams meetings attended by a specific user using Powershell Script

• Obtaining Teams meeting details attended by a specific user using the above PowerShell command returns data in JSON format, which requires additional parsing and adds complexity to the process.
• To simplify this, we’ve developed a PowerShell script that lists the meetings attended by a specific user. It includes key details such as meeting id, created by, attendee, attendee UPN, participant join/leave time, duration, and more, all at once to save time and effort.

Native methods for tracking specific users’ meeting attendance often involve manual effort and provide only limited insights. AdminDroid makes it effortless by offering comprehensive, user-specific attendance reports in just a few clicks.

• AdminDroid’s Teams meeting details report offers clear insights into meeting details of a specific user. You can quickly refine and view relevant data with easy filters such as participant’s UPN.
• Here, you can review key details such as meeting type, event time, join/leave time, etc. The report also supports column customization and sorting, which helps you access the most important insights.

Tracking users’ daily meeting activities in Microsoft Teams helps assess their participation in collaboration, workload management, and contribution to team goals. This helps admins to review a user’s meeting history, and interaction types to monitor engagement and meeting effectiveness.

View users’ meeting activities in Teams admin center

• Sign-in to the Microsoft Teams admin center and navigate to Analytics & reports»Usage reports.
• Under the Report drop-down, select Teams user activity and choose a desired timeframe (7,30,90, or 180 days) from the Date range drop-down.
• Click Run report to generate the user activity data and you'll see a graphical representation of user activity trends over the selected period.

With the Teams Admin Center, admins can view user activity trends but need to interpret multiple metrics and reports to get a full picture of a user's meeting engagement. In contrast, AdminDroid provides a complete view of users' meeting activity in one place, which makes it easier and faster to access.

• The overall Teams meeting details offers a list of users along with counts of various Teams meetings they organized and attended, such as ad-hoc meetings, one-time meetings, recurring meetings, etc.
• Additionally, you can review the Teams meeting duration summary report which provides the total meeting duration based on audio calls, video meetings, and screen sharing. This helps you maintain productivity and optimize meeting schedules.

Handy tip: Utilize the Schedule option available in the report to receive regular insights via email in formats such as CSV, PDF, XLS, and more.