Thanks for the script. Is it possible to show which users/connections are connected via the edge server? Mainly on the -includeusers output if you could show FE Connection – Edge Connection that would be nice. Thanks

Hi Pat,

Thank you for an excellent script.

Is it possible to show the hostname or IP address of the client connection? This would be a great help in tracking down machines running older client versions.

Thanks.

I get some errors.. Only lists connections on the server where I run the script..

.\Get-CsConnections.ps1 -Pool lyncpool

Checking these pool servers in pool: lyncpool.VUC.NO
mslync01.vuc.no
mslync02.vuc.no
Exception calling “Open” with “0” argument(s): “A network-related or instance-s
pecific error occurred while establishing a connection to SQL Server. The serve
r was not found or was not accessible. Verify that the instance name is correct
and that SQL Server is configured to allow remote connections. (provider: SQL
Network Interfaces, error: 26 – Error Locating Server/Instance Specified)”
At C:\Scripts\Get-CsConnections.ps1:181 char:18
+ $connection.Open <<<< ()
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : DotNetMethodException

Exception calling "Fill" with "1" argument(s): "A network-related or instance-s
pecific error occurred while establishing a connection to SQL Server. The serve
r was not found or was not accessible. Verify that the instance name is correct
and that SQL Server is configured to allow remote connections. (provider: SQL
Network Interfaces, error: 26 – Error Locating Server/Instance Specified)"
At C:\Scripts\Get-CsConnections.ps1:190 char:31
+ $recordcount=$sqladapter.Fill <<<

I just want to say thanks for an awesome script. This gave me EXACTLY what a manager wanted to know.

Cheers!

Hi Pat, not sure if this helps but I receive the same SQL Exception error, but only on one server. It works fine on my other Front-End in the same pool – I’m using the Powershell as Administrator and using the same login credentials on both servers.

I don’t want to just post the negatives though! This script is fantastic and it’s helped me quite a bit thus far! Thanks very much.

I was gettign teh error mentioned above, so i changed the
#Define SQL Connection String
[string]$connstring = “server=$server\rtclocal;database=rtcdyn;trusted_connection=true;”
to
#Define SQL Connection String
[string]$connstring = “server=\;database=rtcdyn;trusted_connection=true;”

This got rid of that connection error, but now I get ‘Nothing returned from Query’. Perhaps that isn’t the right value to change if I want to hard code the SQL server? Any ideas on what would cause the ‘Nothing returned from Query’?

Pat, tremendous script – many thanks! Can I make a suggestion? Have the script output all connections and their version in a table? That would be easier than asking the script to tell me every connection with a specific version. Cheers!

Oh, one other thing about the Installation: the because RTCLOCAL is a named instance, and assuming you’ll be connecting via TCP/IP, not named pipes (because TCP/IP normally has a higher priority when the connection type isn’t specified), the firewall needs to allow UDP 1434 (not TCP), the SQL Browser service needs to be running (I’m guessing that this is the most common connection problem) and the port that the instance is actually listening on (which can be seen in the SQL config) also needs to be open on the firewall – or just allow SQL Server. Named pipes isn’t then needed. However, if the client uses named pipes, not TCP/IP, the SQL instance does use the default named pipe, so in theory the SQL Browser shouldn’t be needed, just File and Printer sharing in the firewall. The former method doesn’t require changing the SQL server config, so I’d generally go for that.
HTH

I just wanted to leave a short note to say thanks for creating this script, it is excellent!!

It’s a good job there are people like you around to help the respective community in these cases where Microsoft fall short.

Many thanks…

R.

Hi,Pat

Does the rtcdyn database containing the user information from which edge server it connect to ?

If you get ideal the on which table in which column containing that information ,please share with me ,thanks

It would be awesome if this script had an option to get user information for all Pools in a domain. Then, if it had another option for how to organize that information either collectively or organized by pool, that would be amazing. Also, presumably, you should be able to get the version of Lync (2010 or 2013) and switch between differing SQL queries depending on version of the pool.

Nice work Pat!

Great script! Excellent! Thank you.

I have one question according to this subject. Is there a possibility to get information about which user is doing what – I mean e.g. User1 is using Audio now, User2 is sharing his desktop etc.?

Great script, thank you!
I’m sorry but I don’t know “-clientversion” usage. I can’t use wildcard? I can’t see list of users who is using device/version.

Hi Pat, does this work for pool pairing where we have 2 STD servers in one site?

Hi Richard, the last module for retrieving and displaying the assigned server order has a few bugs. 1) need to prefix sip: otherwise it is interpreted as the SamAccount. 2) Seems the selection of machineid and fqdn does not work for that property, at least it fails when running the command directly. Removing the select-object portion displays the FQDN of the machines. Appreciate all your efforts and sharing.
Cheers,
JeffCSP

Thank you for this script – it gives some great information that I have been looking to gather. Works well on Lync 2013 for me

Hi Pat Richard, I am starting to learn PowerShell. I would like to know if is possible to out the results to a file, but not the detailed information, just the informations that I see when I run the script and see the results on the screen. When I try to use the parameters -FilePatch I get the detailed results and when I use “| out-file -filepath [c:\example\example.txt] it throughs only the information, not the “headers” that shows when I see the output on the screen. Can you help me? Thanks

Hi Pat

Thanks for this script, it really is awesome.
I’ve been running 2.2, 2.3 and 2.4 against Lync 2013 on Server 2012 and have been seeing this error. Results are returned, but i suspect some info is not. Do you have any ideas on a way to work around it?

Method invocation failed because [System.Data.DataRow] doesn’t contain a method named ‘op_Addition’.
At C:\Users\administrator\Get-CsConnections.ps1:413 char:4
+ $overallrecords = $overallrecords + $data
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (op_Addition:String) [], RuntimeException

Steve

Hi,

It’s normal that’s not working with sba pool? Do I have to modify something?

Thanks

It works fine on my SBA, after I ran PowerShell as Administrator.

Hi Pat,

I am seeing that error in a number of environments, including my Dev lab where I have the Windows Firewall disabled. I was running the script on one of my FE’s using the -pool parameter only.

The error implies an issue with one of your .net calls.

Steve

Hi! I have three servers in the pool, but only get the users from one of the servers. I get this error: Method invocation failed because [System.Data.DataRow] doesn’t contain a
method named ‘op_Addition’.
At C:\sw\Get-CSConnections\Get-CsConnections.ps1:599 char:4
+ $overallrecords = $overallrecords + $data
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (op_Addition:String) [], Runti
meException
+ FullyQualifiedErrorId : MethodNotFound

Method invocation failed because [System.Data.DataRow] doesn’t contain a
method named ‘op_Addition’.
At C:\sw\Get-CSConnections\Get-CsConnections.ps1:599 char:4
+ $overallrecords = $overallrecords + $data
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (op_Addition:String) [], Runti
meException
+ FullyQualifiedErrorId : MethodNotFound

Just wanted to post and say thanks for this script, the -incudeusers function is used by me a lot, thanks!

Pat – Great Utility. Really useful for us to quickly view how our new deployemtn of Lync 2013 is being used. Keep up the great work!

Andy Cheetham
IT Manager
Morgan Advanced Materials

This would be great if you encompassed the whole thing in it’s own function so that I can put the ps1 on a network share then have my PS profile load the function for use upon opening powershell rather than having to distribute the file and running the physical file everytime i want to use it.

This script has been a real help – thanks so much.

Hi,

Is it possible to run this script and get users connections specific only to a particular OU ?

Thanks,
Kanishka.

line 300 of version 2.8 is not PowerShell 2 friendly:
if (Get-Module -ListAvailable | Where-Object Name -eq “$name”) {

I’m still learning about PowerShell so i do not have a suggestion to replace yet…
… but if I had to guess it would look something like that:
if (Get-Module -ListAvailable | Where-Object { $_.Name -eq “$name”}) | Select-Object {

Hello Pat,

Great script you have here. What I would like to see per user connection what version is being used. This way we can see if the user software is upgraded from like lync 2010 to Lync 2013.

With regards,

Jelle

Hi,
without the parameter -Is2013 it does return anything. 😉

Red.

This script is great and very helpful but I am now getting the error below when I try to run it:

PS C:\> .\Get-CsConnections.ps1
.\Get-CsConnections.ps1 : File C:\Get-CsConnections.ps1 cannot be loaded. A required certificate is not within its validity period when
verifying against the current system clock or the timestamp in the signed file.
At line:1 char:1
+ .\Get-CsConnections.ps1
+ ~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : SecurityError: (:) [], PSSecurityException
+ FullyQualifiedErrorId : UnauthorizedAccess

I downloaded the latest version of the script. Our execution policy is set to remote signed. I get the same error on all 3 front-end servers.

Thanks for the recognition

Thank you, Wonderful Script, working fine, but can it help providing the IP Addresses for each device (Client) if possible

This script is amazing! Would it be possible to add to see which client version a particular user connection is using?

Thanks so much for this 🙂 looking forward to future updates

Hello Pat,

Good job on the script and the whole post for installation,
I have a question related to the connections – is it possible somehow to drop those for specific sipaddress/lync user ?

We have stumbled upon a strange issue which involves both mobile clients and integration with Exchange/IM OWA access.
Basically what happens with the client connections is that if you don’t sign off properly, for example terminate the application on the mobile device or close down the browser without signing off, the presence of this user shows as available when looking up him from the address book, though when you try to message him this generic error pops up:
reference error ID 450 (source ID 239) a message was not delivered and got this error.
This by the way raises as well issues with response groups when the calls are being routed to so called “available users”…

Any ideas, maybe someone had a chance to notice this as well?

Hello, There is a problem with the script. In my environment, I have 3 servers and one of them is in drain mode. Obviously there is no active conference and call hosted on this, (I have checked with the get-cswindowservice). However, when I run the script, i see on this drain-mode enabled server are connections and clients connected :). Can you fix it?

My Skype for Business server pool sometimes gives empty results.
It says: Nothing returned from query!
Sometimes it’s been working fine, but in SfB RTM it’s not working now.

@Animali
To reply to myself. You can use it on Skype for Business 2015 servers just fine.
It seems that it doesn’t always recognize that its a new SfB 2015 server automatically.
Using switch -Is2013 it gives results normally also in SfB 2015 servers.

Good evening,

I would like to know, if is possible to show an outcome like a table, showing like it…
user01 — fe01
user04— fe01
user02 — fe02
user03 — fe02

Hi. It’s a great script, but I need some help.

It’s possible to generate a HTML file of this script?

When I define the output file, there’s some way to only show the information that is generated to the screen and not the information about all users?

Hi,

Im getting this error below, not sure why?

Exception calling “Fill” with “1” argument(s): “The SELECT permission was
denied on the object ‘Registrar’, database ‘rtcdyn’, schema ‘dbo’.”
At C:\Users\username\Get-CsConnections.ps1:284 char:2
+ $recordcount = $sqladapter.Fill($results)
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : SqlException

Nothing returned from query!

Thanks,
Jeff

I found the cause of my problem – Run as Administrator :). Thanks for a great post!!!

Hi Pat, firstly thanks for the script. One query, the -server switch does not work, request to let know if this is known issue already.

Thank you for the response. Yes, it does not query that server, tried from the server itself and also from another FE of the pool. Basically I’m trying to fetch the Sip address of users connected at the moment to the specific Front End. The Pool, client-version switches work well, only server switch says “nothing found from query”.

@Pat Richard

Hi Richard. Well. Probably I was not so clear. When I run the script it show informations with headers in screen. What I need is to get this result and generate an HTML file and attach it to an e-mail and send, but when I try to do this the result is not the same that I see on the screen. I need something like “what you see is what you get”. Only the summary to an HTML file. It is possible?

@Pat Richard
Hi pat, let me know any help on the server switch of the script

many thanks for good script, but is there any coming update for this script to support Skype For Business Clients??

Is it possible to also display the department each user is in. We would like to be able to see how many users in each department are using Lync. Thanks! script is great so much cleaner and more usable then the other 3 i’ve found on the web, THANK YOU SO MUCH!!!!!

@Pat Richard

Also curious how the script determines if someone is connected or not…. I ran the script once and got 91 unique users, I ran it again like 30min later and got 90 unique users. How does Lync determine this for the script? I know its very vague i’m still trying to understand lync backend so please bare w/ me. I’m just trying to determine how the #’s work.

Hello Pat,

the Script Autodetect feature currently doesn’t recognize the new Skype for Business Server but if you use the -is2013 switch it still works.

The Autotectect line should be modified to include the new Server

For Example:
Old: if (($PoolFqdn -and (Get-CsService -PoolFqdn $PoolFqdn -Registrar).Version -eq 6) -or $Is2013){

New: if (($PoolFqdn -and ((Get-CsService -PoolFqdn $PoolFqdn -Registrar).Version -eq 6 -or (Get-CsService -PoolFqdn $PoolFqdn -Registrar).Version -eq 7)) -or $Is2013){

Also a -noupdate switch would be nice. It is sometimes annoying if you have to do multiple different queries and always get asked for the update check.

Greetings

Mike

Hi Pat,
Amazing, Just amazing. Was looking for a cmdlet to show active users and boom !! Your site came up. It would be a plus if It could separate external users from Internal users. But awesome job.

Hi Pat

Love your script, it’s fantastic.

Is there a way of suppressing the update check?

Steve

Useful script..Thanks Tracey and Mahmoud

Hi Pat! first of all thank you for you script!

Is there any way to manually specify a list of Servers? The thing is that I have multiple Registrar Servers to query (most of them are SBS), and as each of them is a pool itself I need to query one by one with the actual script.

Thanks in advance for your answer!

Hi Pat
Thanks for a fantastic script
Do you know how to remove at connection for a user, when the user has lost his device?

This script proved to be most useful in troubleshooting today. We had the FE service on one of our servers lock up, and could not figure out why some users could not connect. I ran this script and it listed all the FE servers in a particular pool except one, that was our culprit. We have five Lync pools globally, two with ten FE servers each, the other three with 3-5 FE servers each. Is there a way to make this query all configured Lync pools? My management would like me to automate this, and I have everything except getting all the information in a single file.

Hi,
I was running this script and got the following error:
Exception calling “Fill” with “1” argument(s): “The SELECT permission was
denied on the object ‘Registrar’, database ‘rtcdyn’, schema ‘dbo’.”
At Get-CsConnections.ps1:284 char:2
+ $recordcount = $sqladapter.Fill($results)
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : SqlException

Is it possible to see connections coming in via edge server?

I have 2 Enterprise Edition pools. Each is configured identically. The script pulls data for pool A, but I get no data returned from query for Pool B. I have checked all settings on each server and they are identical as far as the SQL Server Configs. Firewalls are set to allow 1434. What could I be missing. I know that users are connected to Pool B. Thanks for the help and the script is awesome on the pools it works on. Great work.

@Pat Richard
My Issue……..

So I have 3 servers in my FE pool.

I issue the drain command to the one I wish to patch/reboot/pick a function.

I can run this script to find out Who and What Cs-User is registered to the FE I wish to work on.

Short of killing the services on the server how do I gracefully move the active connected client/users to a different front end?

Ideas?????

Dear Pat, congratulations this is a great script. It help me a lot!.

I tested it on Skype Server 2015 and worked fine.
Also work fine using a SBA pool.

Even this work fine detecting phone firmware. I am using Snom Phones on my deployment and the script can identify the firmware versión of the devices.

best regards,
Javier

Hey Pat – is there any way to suppress the “This version is older than 90 days , do you want to check message”? If you run this in a scheduled task it hangs up on this.
Thanks
Dino

Hi Pat,

would it be possible to add the functionality to check multiple pools at once?
We would like to add an array of pools as standard value in the param block, but unfortunately that doesn’t work without changing the whole script.
We have two enterprise pools and a consolidated view would be great.

Hello Pat

I had some remote SBS/SBA where the Firewall port was blocking the Script from Running, I checked online for a while and I was able to put together this code to Remotely Enable the Ports on the Firewall on the assumption that the WinRM is configured to allow remote management WMI

Thanks to Allen White Blog Post

http://sqlblog.com/blogs/allen_white/archive/2011/05/21/find-your-enabled-sql-server-network-protocols-using-powershell.aspx

The Code below might be useful for you

Function OpenRTCPorts {
Param(
[Parameter(Mandatory=$True, HelpMessage=”Server Name: “)][string]$Server)
Function RTCDynamicPort {
Param(
[Parameter(Mandatory=$True, HelpMessage=”Server Name: “)][string]$Server)
[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SqlServer.SqlWmiManagement”) | out-null
[System.reflection.assembly]::LoadWithPartialName(“Microsoft.SqlServer.Smo”) | out-null
$m = New-Object (‘Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer’) “$Server”
$RTCinst = $m.ServerInstances |? Name -eq RTCLOCAL
$proto = $RTCinst.ServerProtocols |? DisplayName -eq ‘TCP/IP’
$IPALL=$Proto.IPAddresses |? Name -eq IPAll
$DynPort=($IPAll.IPAddressProperties |? Name -eq TcpDynamicPorts).Value
$Output=new-object -typeName psobject
$Output |add-member -membertype NoteProperty -Name “ServerName” -Value $server -Passthru |out-Null
$Output |add-member -membertype NoteProperty -Name “Instance” -Value “RTCLOCAL” -Passthru |out-Null
$Output |add-member -membertype NoteProperty -Name “DynamicPort” -Value $DynPort -Passthru |out-Null
$Output
}
$Serverconnection=RTCDynamicPort $Server -ea SilentlyContinue
$Port=$Serverconnection.DynamicPort
write-host “Connections on this Server will use the SQL Browser UDP Port 1434 and the below Parameters for TCP”
$ServerConnection
if ($port -ne $Null) {
$StaticRule=@”
netsh advfirewall firewall add rule name=”SQL Browser (UDP 1434)” dir=in action=allow protocol=UDP localport=1434 profile=domain description=”Created for Get-CsConnections.ps1.”
“@
$Rule=@”
netsh advfirewall firewall add rule name=”SQL RTCLOCAL Dynamic Port (tcp-in)” dir=in action=allow protocol=TCP localport=$Port profile=domain description=”Created for Get-CsConnections.ps1″
“@
$OldStatic=’netsh advfirewall firewall show rule name=”SQL Browser (UDP 1434)”‘
$OldStaticValue=iex “Invoke-Command -ComputerName $Server -ScriptBlock {$OldStatic}”
$OldDynamic=’netsh advfirewall firewall show rule name=”SQL RTCLOCAL Dynamic Port (tcp-in)”‘
$OldDynamicValue=iex “Invoke-Command -ComputerName $Server -ScriptBlock {$OldDynamic}”
write-host “Trying to configure the Dynamic TCP Port: $Port”
if (($OldDynamicValue -match $port).Count -eq 0 ) {iex “Invoke-Command -ComputerName $Server -ScriptBlock {$Rule}”}
elseif (($OldDynamicValue -match $port).Count -gt 0 ) {write-host “Rule already Existing”}
write-host “Trying to configure the SQL UDP Port: 1434”
if (($OldStaticValue -match 1434).Count -eq 0 ) {iex “Invoke-Command -ComputerName $Server -ScriptBlock {$StaticRule}”}
elseif (($OldStaticValue -match 1434).Count -gt 0 ) {write-host “Rule already Existing”}
}
elseif ($port -eq $Null) {write-host “WinRM might not be Enabled for this Server or Server may not be reachable”}
}

Is there anyway to return the IP of a given set of versions. Example: We just released 5.3.2 to our VVX 600 phones. When i run your script i see there are 81 phones out there somewhere that have not taken the update for one reason or another.

Anyway to pull the IP info associated with those 81 endpoints out of SQL?

I suspect that the EVENTZERO product may help with some of this however if some rouge IT person just points a phone at my lync environment and doesn’t point the phone at the EVENTZERO product, i don’t think eventzero would even see this phone, thus this data must be in SQL somewhere.

Great script, but wondering about the -includeUsers option. It seems to be mis-reporting because if I look at my connections it shows 3, but I’m only signed into Lync at one endpoint.

Can you explain that?

Great script!! It is good that you can find what user agents a particular person has, but I am wondering if it is possible to do the reverse – find who is using a particular user agent? I don’t think it is currently a feature of this script. You can find what Client version but not user agent.

I mention this because we use the Lync 2013 VDI plugin which actually reports as the same Client Version as the thick client but the user agent is different.

Our use case is to identify people who need to patch their client in a BYOD environment.

Also ability to check who is connected via Edge would be great!!

Thanks!!

Great script! We use the Lync 2013 VDI Plugin which actually has a different user agent to the main client, however the ‘Client Version’ is exactly the same. As such we cannot easily identify who is using a particular version of the Lync 2013 VDI Plugin – would it be possible to include a filter for User Agent?

Also it would be great to see who is connected via Edge!

Cheers 🙂

I don’t see where this will list out all the ‘Unique Active Users’. Is that possible? Would I be able to show Unique Active Users over the past month? Trying to control licenses.

@Juliano
Hi Do you have the script to send the results through email

Thanks Pat for the script, had some similar SQL queries before, but the convenience of your PowerShell script goes a long way.

People frequently have been looking for the IP address of a device. I’ve only seen it in the monitoring DB. If we take your SQL query and modify it a bit, we get the EndpointID (I’ve also included the ExpiresAt portion since that is helpful for addressing some other items).

Select (cast (RE.ClientApp as varchar (100))) as ClientVersion, R.UserAtHost as UserName, RA.Fqdn, EP.ExpiresAt, EP.EndpointId
From rtcdyn.dbo.RegistrarEndpoint RE
Inner Join rtcdyn.dbo.Endpoint EP on RE.EndpointId = EP.EndpointId
Inner Join rtc.dbo.Resource R on R.ResourceId = RE.OwnerId
Inner Join rtcdyn.dbo.Registrar RA on EP.RegistrarId = RA.RegistrarId
where R.UserAtHost = ‘xxxx@sipdomain.com’
Order By ClientVersion, UserName

Anyhow, once you have this, you have the EndPointID.

Then if you run this against the LcsCDR database on your monitoring server
select TOP 1 IpAddress
FROM Registration
where EndpointId = ‘xxxxxx_from_previous_step_xxxx’
ORDER BY LastModifiedTime DESC

Not sure if it is perfect, but has worked the few times I needed it.

In order to tie into your script, would suspect would need a linked server defined in the RTCLOCAL instance pointing to the monitoring server, etc. Not a trivial undertaking, but the manual queries aren’t horrible if you really need it. Worse case, could add a variable in the script (could be passed param) for the monitoring DB server name and run the query against it in a similar fashion as the first query, just passing in a param from each row of the first query’s results (which would be slow…only recommend when querying against a particular SIP address). But would speed up the manual lookup process at least.

Thanks.

Hi when I do server-work I would sometimes like to know how many users that has been active the last 30 minutes so I can estimate impact on a larger change. Can you add something for this?

Please add support to displaying how many video calls / audio calls / chats are being held

Hi Pat, thanks for the great script. I tested the 3.1 version on a Lync2013 pool, but the Get-CsConnections.ps1 -PoolFqdn poolname -ClientVersion version won’t give any sip addresses of users. Only the amount of connections. Is that part removed?

Yes, that did it! Thanks.

Hi – ive been using this script for ages, and always just worked. However after trying to run against a 2 server SfB pool, I only get one server (server 1) returned in the “FrontEnd Server” section (the bit that shows how many connections per server)

The script does detect both servers though, just doesn’t display both within before mentioned.
If I stop the RTCSRV service on server 1, both show up temporarily, and once the service is stopped, the only server 2 is displayed. When I then start this service again on server 1 – server 2 disappears and server 1 is then displayed again (only).

Any idea?

Hi Pat, just recognized that the signing certificate for the beloved Get-CsConnections.ps1 expired. Might it be possible for you to publish a new signed version? Would be appreciated. Thanks in advance.

Thanks for the new 3.2 version.
However it isn’t working for me…. it errors on line 345

The “=” operator is missing after a named argument.
At C:\lyncscripts\Get-CsConnections.ps1:345 char:40
+ [CmdletBinding(SupportsShouldProcess, <<<< SupportsPaging)]
+ CategoryInfo : ParserError: (:) [], ParseException
+ FullyQualifiedErrorId : MissingEqualsInNamedArgument

Name Value
—- —–
CLRVersion 2.0.50727.5485
BuildVersion 6.1.7601.17514
PSVersion 2.0
WSManStackVersion 2.0
PSCompatibleVersions {1.0, 2.0}
SerializationVersion 1.1.0.1
PSRemotingProtocolVersion 2.1

Ok, hadn’t realised there was a minimum version.
I’ve gone back to v3.1 for now, that’s working fine. Thanks.

Thanks Pat for the new version.

Hi I have the strange problem that I find the same user using multiple versions…
When I do this I find a certain user
./Get-CsConnections.ps1 -Pool lyncpool01.xxx.xxx -ClientVersion 4797 -IncludeUsers
when I do this I find the same user
./Get-CsConnections.ps1 -Pool lyncpool01.xxx.xxx -ClientVersion 4875 -IncludeUsers

Hi Pat. What will be the easiest to get the output sent to an email in HTML?

Hello,

the 3.1 version is not working atm, gives error:

.\Get-CsConnections.ps1 : File G:\Data\Scripts\Skype\Get-CsConnections.ps1 cannot be loaded. A required certificate is not within its validity period when verifying against the
current system clock or the timestamp in the signed file.

Th 3.2 version is working but is also giving an error:

Exception calling “DownloadString” with “1” argument(s): “Unable to connect to the remote server”
At G:\Data\Scripts\Skype\Get-CsConnections.ps1:351 char:5
+ [xml] $xml = (New-Object System.Net.WebClient).DownloadString(“http://www.eh …
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : WebException

I’m using Skype for Business 2015 with November 2016 CU.

What could go wrong here?

Hello,

the 3.1 version is not working atm, gives error:

.\Get-CsConnections.ps1 : File G:\Data\Scripts\Skype\Get-CsConnections.ps1 cannot be loaded. A required certificate is not within its validity period when verifying against the
current system clock or the timestamp in the signed file.

I’m using Skype for Business 2015 with November 2016 CU.

What could go wrong here?

Hello

I need to check the last access of the user in lync, is it possible?

Hello Pat

the new update mechanism ignores the -skipupdatecheck parameter. The servers in question are behind a firewall that blocks most internet access with some exceptions and because of this the script is slow until it runs into a timeout and writes “Exception calling “DownloadString” with “1” argument(s): “Unable to connect to the remote server””

After this message i get the expected result with the connection table.

If -skipupdatecheck is set it shouldn’t even try to establish a connection to the update server.

Greetings

Mike

Hi Pat

It looks like the script (v.3.3) does not support multiple values from the pipeline.
E.g.
Get-CsService -Registrar | .\Get-CsConnections.ps1
picks up only the first pool

Amazing script – I use it every day!

Regards
Mike

@Mike

Hello,

i added the following in function Get-UpdateInfo {}

Line 352 …
[string] $article
)
if (-Not ($SkipUpdateCheck)){

Line 385…
}
} # end function function Get-UpdateInfo

Now it is working if I gibe the parameter -SkipUpdateCheck

hth,
Ralf

+1 for implementing (and honoring) a switch for ignoring the online update check function!

Have you considered publishing this to PSGallery, so it can be installed via Install-Script?

Hi Pat,
Great Script, We tried with Skype For Business Server.Please suggest which parameter we should use to get user connections via Edge Server ?

Thanks for the script

Im getting the following error

The “=” operator is missing after a named argument. Can you help?

Hi pat,
My apologies for being vague but you seem the type of guy that might be able to answer this. I need to replicate the monitoring reports provided in sfb server 2015 but hook them to our org hierarchy – this is simple enough if I had the username – so for example, to replicate the peer to peer registration summary per service, team etc, I would need the detail data for this… is there a way of getting this?? I am aware of the peer to peer session log per user report but it’s quite limited to what it can provide.

Any help/advice is greatly appreciated!

Thanks

Rich

Many thanks for the script and the result of “-ShowTotal” is it possible to save it to a text file? “-FilePath” only saves the total number of users.

Hi,

First off, thanks for providing this excellent script! I am wanting to utilize this script to create .csv files based on Agent type. For instance, I’d like to run something like this to return a list of iPhone endpoints .\get-csconnections.ps1 -showfullclient | where {$_.Agent -like “iPhone”} – FilePath C:\iphone.csv Unfortunately, that bit of code did not achieve the desired result. Is something like this possible? Thanks!

@Austin Caldwell
I answered my own question. As it did not look to be possible to do this directly from the script, I just wrote a separate script which pulls the CSV files which have been generated for each pool with the -ShowFullClient parameter and then appends the desired information to a single CSV document. It then gives me a count of the connected endpoints. In case anyone wants to do something similar, here’s what that looks like:

Write-Host “Creating Endpoint CSV Files”

Import-Csv C:\pool1.csv | Where-Object {$_.ClientVersion -like “*iphone*”} | Export-csv C:\iphone.csv

Import-Csv C:\pool2.csv | Where-Object {$_.ClientVersion -like “*iphone*”} | Export-CSV -Append -Path C:\iphone.csv

Import-Csv C:\pool1.csv | Where-Object {$_.ClientVersion -like “*iPad*”} | Export-csv C:\ipad.csv

Import-Csv C:\pool2.csv | Where-Object {$_.ClientVersion -like “*iPad*”} | Export-CSV -Append -Path C:\ipad.csv

Import-Csv C:\pool1.csv | Where-Object {$_.ClientVersion -like “*Mac*”} | Export-csv C:\mac.csv

Import-Csv C:\pool2.csv | Where-Object {$_.ClientVersion -like “*Mac*”} | Export-CSV -Append -Path C:\mac.csv

Import-Csv C:\pool1.csv | Where-Object {$_.ClientVersion -like “*Android*”} | Export-csv C:\Android.csv

Import-Csv C:\pool2.csv | Where-Object {$_.ClientVersion -like “*Android*”} | Export-CSV -Append -Path C:\Android.csv

Import-Csv C:\pool1.csv | Where-Object {$_.ClientVersion -like “*OWA*”} | Export-csv C:\OWA.csv

Import-Csv C:\pool2.csv | Where-Object {$_.ClientVersion -like “*OWA*”} | Export-CSV -Append -Path C:\OWA.csv

Import-Csv C:\pool1.csv | Where-Object {$_.ClientVersion -like “*SIPE*”} | Export-csv C:\SIPE.csv

Import-Csv C:\pool2.csv | Where-Object {$_.ClientVersion -like “*SIPE*”} | Export-CSV -Append -Path C:\SIPE.csv

Import-Csv C:\pool1.csv | Where-Object {$_.ClientVersion -like “*OC*”} | Export-csv C:\Windows.csv

Import-Csv C:\pool2.csv | Where-Object {$_.ClientVersion -like “*OC*”} | Export-CSV -Append -Path C:\Windows.csv

Write-Host “Counting Endpoints”

Write-Host “iPhone:”
(Import-Csv C:\iphone.csv).count

Write-Host “iPad:”
(Import-Csv C:\ipad.csv).count

Write-Host “Mac:”
(Import-Csv C:\mac.csv).count

Write-Host “Android:”
(Import-Csv C:\Android.csv).count

Write-Host “OWA:”
(Import-Csv C:\OWA.csv).count

Write-Host “SIPE/Pidgin:”
(Import-Csv C:\SIPE.csv).count

Write-Host “Windows:”
(Import-Csv C:\Windows.csv).count

Pause

Suggestion: Be able to report the users or versions connected to a particular server in a FE pool. Found a possible problem with one node, but can’t determine who’s on just that one node, and possibly their client versions (iOS issues…)

Thanks Pat, do you think how this can be modified with the Skype for Business Online version.
it also has the registrapool but I have no idea to retrieve its client version,etc…do you have any suggestion.

wonderful script !!!
i am looking to integrate this with my prtg system for sfb monitoring 🙂

I can get connected users and connections, but is there possible to get computers name a user is connecting from?

(Get-WmiObject -Class Win32_ComputerSystem -Property Name).Name – returns hostname of windows machine.
I can’t think of how to integrate this into the suggested script to print hostname if it is windows pc.

Hi Pat, Thank you so much for this brilliant script!!!
I understood that right now there is no possibility to track Edge users or see external client ip, BUT propably U can suggest what table/parameter I can query (propably to Edge SQL) to see Edge users/external ip?

Script Idea… can you pull the IP address of the connected endpoint? don’t know if that’s buried in the DB somewhere, or if it’s only recorded with the CDR.

I have an issue with v3.4 (did not test with older, but they may also be affected):

Skype Meeting room accounts throw an error (a normal CSUSER was converted into CSMEETINGROOM with Enable-Csmeetingroom):

Get-CsUserPoolInfo : Cannot find user in Active Directory with the following SAM account name:
“sip:CSMEETINGROOM01@domain.com”
At C:\Users\admin\Desktop\Get-CsConnections_v3.4.ps1:1215 char:26
+ $UserPreferredInfo = Get-CsUserPoolInfo -Identity sip:$SipAddress | Select-O …

Is it possible to list up the IPAddresses associated with every user?

Is ther a way to pull a list of users with the client versions they are running per pool?

Thanks for the script Pat! Do you have any scripts for Skype for business online? If yes, could you please share them or send me the link to download please? Appreciate your help in advance.

So, if i’m reading this right, and i very well may not be, it almost sounds as though you need to repeatedly open firewall ports? if i’m missing something, please, let me know. but these dynamic sql ports that you’re assigning, don’t they change every time the services are restarted or the server is rebooted?

Hi Pat
Do you have any figures on performance? ie running against a full pool of 80,000 users and 12 servers in a pool?

Kr

Is it possible to list up the IPAddresses associated with every user?

After last CU key -server stop worked.
-pool work fine and found all server and users, but can’t show single server logging users

Nothing returned from query!

Hi Pat, many thanks for this awesome script.
I have to make a test with one of my users and to do that, she has to be “Offiline” in Skype. She normally uses Skype for Business with a Laptop and an iPhone. If she logoff from both the devices, I still can see a session UP (iPhone app agent) and consequently I see always the user in the yellow state “Away – Mobile” even if she hasn’t any other Apple mobile devices.
Is there any way to kill all the active sessions of a specific user?
Many thanks for the support!

Great script! Any plans to make this work with SfB 2019?

Hi Richard, thanks for the script. Is it possible to get all connected users a day?

@wisu20
If you query the last login time it will reveal who’s logged in within the last ‘n’ hours, which I think meets your criteria?

There are a couple of approaches you can take, either PS or SQL:
https://ucsorted.com/ps-one-liners/
https://learn.microsoft.com/en-us/answers/questions/267274/how-to-list-skype-accounts-with-the-lastlogon-time.html