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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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
Highlighted
Frequent 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!

10 Replies
Highlighted
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.

Highlighted

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. 

Highlighted

@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.

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted
Hello AB,

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

With Regards,
Satish U
Highlighted

@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.

Highlighted

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 ?

Highlighted

@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.