In May 2020, Microsoft introduced the ability to download attendance reports for meetings in Microsoft Teams. Today you can only do this once enabled on a meeting policy per user, via PowerShell, so an IT admin must be the one to perform this action. This post will be updated once other methods are realized.
Make sure you have the Skype for Business Online Connector module downloaded and installed: https://docs.microsoft.com/en-us/skypeforbusiness/set-up-your-computer-for-windows-powershell/download-and-install-the-skype-for-business-online-connector
To get started, open your PowerShell console in admin mode. If you haven’t already, import the SkypeOnlineConnector module:
Next you will need to create and establish a new Skype for Business session via the cmdlets you just imported. There a couple ways to do this, but below is an example:
$userCredential = Get-Credential $sfbSession = New-CsOnlineSession -Credential $userCredential Import-PSSession $sfbSession
Now we are ready to enable Attendance Reports on the meeting policy(ies). Because we need the meeting policy, be sure to grab the name from the admin console (unless you know it by heart!) I’ve also selected a meeting policy that is assigned to all my teachers to ensure that only the instructors and staff are able to download attendance reports, while also ensuring students do not have this capability. The meeting policy I selected is appropriately named Education_Teacher. If you don’t have a meeting policy created, you can create one but make sure it gets assigned to the appropriate users, either individually or batch.
We have two options with the -AllowEngagementReport parameter on the cmdlet, enable or disable. As noted in the documentation:
“To enable a meeting organizer to download the meeting attendance report, set the AllowEngagementReport parameter to Enabled. When enabled, the option to download the report is displayed in the Participants pane.
To prevent a meeting organizer from downloading the report, set the parameter to Disabled. By default, this setting is disabled and the option to download the report isn’t available.”
Below is my example:
Set-CsTeamsMeetingPolicy -Identity Education_Teacher -AllowEngagementReport Enabled
That’s it! To validate, you can now run the following command and get verify the output revelas that the AllowEngagementReport property is set to Enabled:
Get-CsTeamsMeetingPolicy -Identity Education_Teacher
As a final test (you may have to wait 24-48 hours), start a new meeting in Microsoft Teams, and in the Participants lists, you should now see a download icon that will download the attendance report. Once downloaded, it can be found in your downloads folder on Windows.
Also note that you can only download this report during the meeting, so make sure to grab it before you end the meeting! Again, it can take up 24-48 hours for the policy to apply, so be sure to do this in plenty of time before the school year starts so your educators can take attendance day one!
- Meeting Policy Docs: https://docs.microsoft.com/en-us/microsoftteams/meeting-policies-in-teams#meeting-policy-settings—meeting-attendance-report
- Set-CsTeamsMeetingPolicy Docs: https://docs.microsoft.com/en-us/powershell/module/skype/set-csteamsmeetingpolicy?view=skype-ps
- Microsoft Teams meeting attendance reports docs: https://docs.microsoft.com/en-us/microsoftteams/teams-analytics-and-reports/meeting-attendance-report#related-topics
- Download Attendance Reports in Teams: https://support.office.com/en-us/article/download-attendance-reports-in-teams-ae7cf170-530c-47d3-84c1-3aedac74d310?ui=en-US&rs=en-US&ad=US
- YouTube: Download Attendance Report in Microsoft Teams: https://www.youtube.com/watch?v=OBJ3hQx0-GE