Capturing list of meeting participants in MS Lync 2010
Does anyone know if MS Lync offers a feature whereby users can capture the list of meeting attendees when using Lync to conduct online meetings?  Looking for an export feature of some sort where you can export the names of those that joined the online meeting.
September 1st, 2011 3:47pm

It would be recorded in the monitoring (CDR) server if you have it deployed. The schema is documented here, you would need to look at the FocusJoinsAndLeaves Table It stores information about conference joins and leaves, including users’ role and client version. The samples query actually shows you how to  get the conference participants organized by a given user and in a specific time range.

It's probably more work than you were hoping for :)

 

declare @Organizer nvarchar(256)
declare @StartTime datetime
declare @EndTime datetime
 
set @Organizer = 'luka@contoso.com'
set @StartTime = DATEADD(d, -1, getdate())
set @EndTime = GETDATE()
 
--user join/leave information for signalling
select cu.ConferenceUri, u.UserUri, cv.Version, fjl.UserJoinTime, fjl.UserLeaveTime, r.Role, fjl.IsUserInternal from FocusJoinsAndLeaves fjl 
inner join Conferences c on fjl.SessionIdTime = c.SessionIdTime and fjl.SessionIdSeq = c.SessionIdSeq
inner join ConferenceUris cu on c.ConferenceUriId = cu.ConferenceUriId
inner join Users u on u.UserId = fjl.UserId
left join Users org on org.UserId = c.OrganizerId
left join ClientVersions cv on cv.VersionId = fjl.ClientVerId
left join Roles r on r.RoleId = fjl.UserRole
where org.UserUri = @Organizer and fjl.SessionIdTime between @StartTime and @EndTime


Free Windows Admin Tool Kit Click here and download it now
September 1st, 2011 10:52pm

Yeah....way more complicated than I needed :)  I was able to figure out a way to get what I needed.  In the lync box there are double arrows (more options) next to the paperclip at the top and if you click on those and then select "take notes using one note", the list of attendees will be dumped into one note where you can cut and paste as needed.  Helpful when you need to track participation and send out meeting notes etc.
September 2nd, 2011 3:27pm

Damn those developers, making things too easy! Good to know the functionality is there.
Free Windows Admin Tool Kit Click here and download it now
September 2nd, 2011 3:37pm

Has anyone found a way to do this for PREVIOUS meetings?
I just finished a meeting which my boss missed and now he's asking for "who attended?"

"Uhhh.... a bunch of people?"

May 18th, 2012 6:00pm

If you have an option that saves your Lync conversation history into an outlook folder, you can retrieve it there.  Might not get 100% of the participants (guessing it is a snapshot in time maybe) but might give you a general idea....good luck!
Free Windows Admin Tool Kit Click here and download it now
May 18th, 2012 7:32pm

Hey, THAT's pretty good. Simple (uhh....why didn't I think of that?) and it DOES seem to get all the participants. THANKS!!!

May 18th, 2012 8:29pm

Do you know for sure whether that lists actual paritipants regardless if they joined late or left early, or is that just a list of the participants at a given time, or is it just a list of invitees? I want to know after the fact how many people actually joined and some might join late or leave early. Thanks in advance for any assistance you can provide!
Free Windows Admin Tool Kit Click here and download it now
August 16th, 2012 6:40pm

Unfortunately I believe it is only a snapshot of that given time....
August 17th, 2012 5:59pm

Here are two other alternatives to capture Lync meeting attendees (if OneNote is disabled) on a snapshot in time basis:

1) Use PrintScreen and paste into Word. Although in graphic format vs. text, this will capture the list of attendees.

2) Record the meeting. When you go to save the recording, it dumps the attendees into the filename box which you can highlight and copy (Cntrl+C);then paste (Cntrl+V) into word or email.

Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2013 3:19pm

Anyone that was in the meeting while you were also in it will be captured into your Conversation History record.  If someone joined for just a minute at the beginning of the meeting, and you joined 5 minutes late, you won't have that person, but if their name appeared in your participant list at any time, they will be in the Conversation History too.

Source: I have done this for hundreds of meetings.

January 7th, 2015 5:48pm

Another way to do it is to click on the double sign >> in the Lync window (rigth, top) and to Take Notes using OneNote.

Ok, it is only a snapshot too, but at least you can choose the moment. It only works once. And the list is (in my case) comma separated, so hard to reuse as list of To: in Oulook.

I checked the list archived in Conversation history and people who did not show up are not in it. So it is at least some of the active participants.


Do not forget to give points for good answers ... ;)
  • Edited by kStarbe 17 hours 18 minutes ago ASk for reward
Free Windows Admin Tool Kit Click here and download it now
March 6th, 2015 9:56am

Another way to do it is to click on the double sign >> in the Lync window (rigth, top) and to Take Notes using OneNote.

Ok, it is only a snapshot too, but at least you can choose the moment. It only works once. And the list is (in my case) comma separated, so hard to reuse as list of To: in Oulook.

I checked the list archived in Conversation history and people who did not show up are not in it. So it is at least some of the active participants.


Do not forget to give points for good answers ... ;)
  • Edited by kStarbe Friday, March 06, 2015 2:59 PM ASk for reward
March 6th, 2015 2:55pm

Another way to do it is to click on the double sign >> in the Lync window (rigth, top) and to Take Notes using OneNote.

Ok, it is only a snapshot too, but at least you can choose the moment. It only works once. And the list is (in my case) comma separated, so hard to reuse as list of To: in Oulook.

I checked the list archived in Conversation history and people who did not show up are not in it. So it is at least some of the active participants.


Do not forget to give points for good answers ... ;)
  • Edited by kStarbe Friday, March 06, 2015 2:59 PM ASk for reward
Free Windows Admin Tool Kit Click here and download it now
March 6th, 2015 2:55pm

When you are in the Lync meeting, IM everyone in the meeting via Lync port. Once you leave the meeting, your Conversation History have a record of everyone that ever was in the meeting, even if they called in late and left early.

June 26th, 2015 3:19pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics