SOLVED

Accessing all attendance reports as a admin

%3CLINGO-SUB%20id%3D%22lingo-sub-1450863%22%20slang%3D%22en-US%22%3EAccessing%20all%20attendance%20reports%20as%20a%20admin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1450863%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20as%20a%20global%20Admin%20can%20we%20download%20previous%20attendance%20reports%20for%20all%20teams%20meetings%3F%20and%20can%20the%20organiser%20of%20a%20meeting%20access%20the%20attendance%20reports%20of%20previous%20meetings%20held%20by%20them%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20helpp!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1450863%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EActivity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdministrator%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBest%20Practices%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECalling%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECommunity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EConversations%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHow-to%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EIT%20Pro%20Training%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMeetings%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESettings%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20%26amp%3B%20Tricks%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Interface%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1450990%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20all%20attendance%20reports%20as%20a%20admin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1450990%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F575283%22%20target%3D%22_blank%22%3E%40AB21805%3C%2FA%3E%26nbsp%3BIf%20you%20add%20the%20CQD%20dashboard%20to%20Power%20BI%20you%20are%20able%20to%20export%20information%20from%20meetings%20held%20up%20to%2030%20days%20back%20in%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1451033%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20all%20attendance%20reports%20as%20a%20admin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1451033%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F195259%22%20target%3D%22_blank%22%3E%40Par%20Linderoth%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20the%20only%20option%3F%20is%20this%20easy%20to%20do%20(sorry%20I'm%20not%20the%20best%20with%20Power%20BI)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20admin%20not%20got%20an%20option%20in%20Analytics%20and%20Reports%3F%20to%20pull%20meeting%20attendance%20reports%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1452781%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20all%20attendance%20reports%20as%20a%20admin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1452781%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F575283%22%20target%3D%22_blank%22%3E%40AB21805%3C%2FA%3E%26nbsp%3BIt%20is%20fairly%20easy%20but%20if%20you%20have%20never%20used%20the%20CQD%20before%20it%20might%20take%20some%20time%20to%20setup%20and%20get%20the%20date.%20Once%20you%20got%20the%20data%20for%20that%20meeting%20it%20is%20easy%20to%20export%20it%20to%20a%20CSV%20file%20and%20use%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20some%20info%20about%20CQD%20in%20Power%20BI%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoftteams%2Fcqd-power-bi-query-templates%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoftteams%2Fcqd-power-bi-query-templates%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20what%20I%20know%20it%20is%20not%20possible%20to%20do%20in%20Analytics%20and%20Reports.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1457158%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20all%20attendance%20reports%20as%20a%20admin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1457158%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F195259%22%20target%3D%22_blank%22%3E%40Par%20Linderoth%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20managed%20to%20add%20CQD%20but%20i%20have%20no%20clue%20on%20which%20query%20to%20use!%20can%20you%20help%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1458209%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20all%20attendance%20reports%20as%20a%20admin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1458209%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F575283%22%20target%3D%22_blank%22%3E%40AB21805%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20that%20we%20are%20offthe%20track%20on%20the%20Thread.%20For%20meeting%20Attendance%20reports%20currently%20only%20the%20meeting%20attendance%20report%20can%20be%20downloaded%20during%20the%20meeting.%20For%20all%20the%20past%20meetings%20for%20which%20we%20need%20to%20have%20the%20meeting%20attendance%20report%20we%20need%20to%20wait%20for%20the%20Feature%20release%20from%20Microsoft%20Engineering%20Team.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20Uservoice%20for%20the%20same%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F33989875-view-or-export-a-list-of-users-who-attended-a-meet%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F33989875-view-or-export-a-list-of-users-who-attended-a-meet%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F599053-schools-and-universities%2Fsuggestions%2F39969796-download-attendance-list-in-a-teams-meeting%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F599053-schools-and-universities%2Fsuggestions%2F39969796-download-attendance-list-in-a-teams-meeting%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20answers%20the%20query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20Regards%2C%3C%2FP%3E%3CP%3ESatish%20U%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1458363%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20all%20attendance%20reports%20as%20a%20admin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1458363%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F259632%22%20target%3D%22_blank%22%3E%40Satish2805%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20for%20this!%20So%20in%20the%20mean%20while%20till%20this%20feature%20is%20done%2C%20is%20it%20possible%20through%20Power%20BI%3F%20Using%20the%20CQD%20report%20templates%20for%20attendance%20reports%20for%20meetings%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1458400%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20all%20attendance%20reports%20as%20a%20admin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1458400%22%20slang%3D%22en-US%22%3EHello%20AB%2C%3CBR%20%2F%3E%3CBR%20%2F%3ENo%20there%20is%20no%20method%20currently%20available%20to%20download%20the%20reports.%3CBR%20%2F%3E%3CBR%20%2F%3EWith%20Regards%2C%3CBR%20%2F%3ESatish%20U%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1495675%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20all%20attendance%20reports%20as%20a%20admin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495675%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F575283%22%20target%3D%22_blank%22%3E%40AB21805%3C%2FA%3E%26nbsp%3BIf%20you%20go%20to%20CQD%20and%20use%20the%26nbsp%3B%3CEM%3ECQD%20Helpdesk%20Report%3C%2FEM%3E%20you%20can%20do%20it.%20Search%20for%20the%20user%20who%20organized%20the%20meeting.%26nbsp%3BRight-click%20and%20choose%20%3CEM%3EDrill%20through%20-%26gt%3B%26nbsp%3B%3C%2FEM%3E%3CEM%3EUser%20Activities.%20%3C%2FEM%3E%26nbsp%3BFind%20the%20meeting%20and%20right-click%20and%20choose%20%3CEM%3EDrill%20through%20-%26gt%3B%20Conference%20details.%3C%2FEM%3E%26nbsp%3BYou%20will%20now%20see%20the%20participants%20of%20the%20meeting%20and%20can%20export%20the%20data%20to%20Excel%20if%20you%20like.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1496037%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20all%20attendance%20reports%20as%20a%20admin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1496037%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F195259%22%20target%3D%22_blank%22%3E%40Par%20Linderoth%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much%20for%20this%2C%20How%20do%20I%20find%20the%20name%20of%20the%20team%20rather%20than%20the%20conference%20ID%20or%20even%20find%20out%20how%20to%20find%20the%20conference%20ID%20for%20a%20particular%20team%20so%20I%20know%20how%20to%20Identify%20that%20im%20looking%20at%20the%20correct%20team%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20How%20to%20I%20export%20this%20as%20an%20excel%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1496123%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20all%20attendance%20reports%20as%20a%20admin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1496123%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F575283%22%20target%3D%22_blank%22%3E%40AB21805%3C%2FA%3E%26nbsp%3BYou%20need%20to%20know%20a%20user%20who%20was%20in%20the%20meeting%20and%20the%20date%20and%20time%20of%20the%20meeting.%20Then%20it%20is%20just%20a%20matter%20of%20searching%20in%20the%20CQD%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20PowerBI%20you%20can%20click%20the%20ellipsis%20(...)%20on%20a%20part%20of%20the%20report%20and%20select%20to%20export%20the%20info%20in%20that%20part.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Contributor

Hi All, 

 

Is it possible as a global Admin can we download previous attendance reports for all teams meetings? and can the organiser of a meeting access the attendance reports of previous meetings held by them? 

 

Please helpp!

15 Replies
best response confirmed by ThereseSolimeno (Microsoft)
Solution

@AB21805 If you add the CQD dashboard to Power BI you are able to export information from meetings held up to 30 days back in time.

Hi @Par Linderoth,

 

Is this the only option? is this easy to do (sorry I'm not the best with Power BI)

 

Has admin not got an option in Analytics and Reports? to pull meeting attendance reports? 

 

Thanks in advance. 

@AB21805 It is fairly easy but if you have never used the CQD before it might take some time to setup and get the date. Once you got the data for that meeting it is easy to export it to a CSV file and use in Excel.

 

Here is some info about CQD in Power BI: https://docs.microsoft.com/en-us/microsoftteams/cqd-power-bi-query-templates

 

From what I know it is not possible to do in Analytics and Reports.

Hi @Par Linderoth 

 

I have managed to add CQD but i have no clue on which query to use! can you help? 

 

Thanks in advance

Hi @AB21805 

 

It seems that we are offthe track on the Thread. For meeting Attendance reports currently only the meeting attendance report can be downloaded during the meeting. For all the past meetings for which we need to have the meeting attendance report we need to wait for the Feature release from Microsoft Engineering Team.

 

Here is the Uservoice for the same

https://microsoftteams.uservoice.com/forums/555103-public/suggestions/33989875-view-or-export-a-list...

https://microsoftteams.uservoice.com/forums/599053-schools-and-universities/suggestions/39969796-dow...

 

Hope this answers the query.

 

With Regards,

Satish U

Hi @Satish2805,

 

Thank you so much for this! So in the mean while till this feature is done, is it possible through Power BI? Using the CQD report templates for attendance reports for meetings?

 

Thanks in advance

Hello AB,

No there is no method currently available to download the reports.

With Regards,
Satish U

@AB21805 If you go to CQD and use the CQD Helpdesk Report you can do it. Search for the user who organized the meeting. Right-click and choose Drill through -> User Activities.  Find the meeting and right-click and choose Drill through -> Conference details. You will now see the participants of the meeting and can export the data to Excel if you like.

Hi @Par Linderoth ,

 

Thanks so much for this, How do I find the name of the team rather than the conference ID or even find out how to find the conference ID for a particular team so I know how to Identify that im looking at the correct team?

 

Also How to I export this as an excel ?

@AB21805 You need to know a user who was in the meeting and the date and time of the meeting. Then it is just a matter of searching in the CQD information.

 

In PowerBI you can click the ellipsis (...) on a part of the report and select to export the info in that part.

Hi @ThereseSolimeno 

 

Is there a place like this but for instance at a school Year managers would like to see activity through a CSV format for all classes rather than just one or a few. This would make it a lot easier to manage. 

I wonder how we can download the multiple meeting attendance reports in bulk, instead of clicking them one by one in the channel...

@AB21805 

MicrosoftTeams-meeting_attendance_reports.png

Thank you!

Hello, if not using the above 'best response' approach this is currently the option you got. But I believe you will like the following roadmap id scheduled for release this month (still in development stage though).

Attendee Dashboard - Measure meeting and webinar registration and attendance data in the reporting dashboard.

https://www.microsoft.com/en-ww/microsoft-365/roadmap?filters=Microsoft%20Teams&searchterms=66585
Thanks a lot for your prompt tips! Looking forward to it.