Active Conference PowerShell Script

Yesterday was a busy day with e-mails and other tweets from my PowerShell script that I posted but got a lot of follow-up questions.  The number one question, does this work with Lync Server 2010?

Kinda. If you are willing to just run the SQL command directly on the server.  Lync Server doesn’t use PowerShell 3.0 and is missing some of the SQL commands to be able to run it directly from the PowerShell.  So if you run this SQL Command on your back-end SQL Database:

SELECT ActiveConference.ConfId AS‘Conference ID’, ActiveConference.Locked, Participant.UserAtHost AS‘Participant’, Participant.JoinTime, Participant.EnterpriseId FROM ActiveConference INNERJOIN Participant ON ActiveConference.ConfId = Participant.ConfId

And for Lync 2013 you can refer to the PowerShell Script (

One thought on “Active Conference PowerShell Script

  • July 21, 2014 at 11:49 am

    Getting below while executing above command

    Msg 102, Level 15, State 1, Line 1
    Incorrect syntax near ‘‘’.


Leave a Reply

Your email address will not be published. Required fields are marked *