3 users responded in this post

Subscribe to this post comment rss or trackback url
User Gravatar
tpullins said in February 24th, 2011 at 7:56 am

The tool is failing to connect to my Lync backend database server that has the rtcdyn database.

“error: 26 – Error Locating Server/Instance Specified”

On the website it says “Just specify the server name that hosts the RTCLOCAL SQL instance.”

I have my Lync databases on the default SQL instance, could it be that causing the problem?

VA:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)
User Gravatar
chrb said in April 19th, 2011 at 5:36 pm

I had the same problem. -> Go to the Authors website, and download v1.0.2 of his tool. Works like a charm :-)

VA:F [1.9.22_1171]
Rating: 4.0/5 (2 votes cast)
User Gravatar
hhyderi said in September 8th, 2011 at 12:27 am

Great tool however If I run the below SQL query manually on one of the Enterprise Edition FE Servers (RTCLocal), it is either listing no users as no one is connected to that sepcific server in Pool or only the users that are connected to that server.

Use rtcdyn
SELECT UserAtHost, ClientApp, EndpointId, ContactInfo FROM RegistrarEndpoint T1
LEFT OUTER JOIN rtc..Resource T2 ON T1.OwnerId = T2.ResourceId
WHERE IsServerSource = 0 ORDER BY UserAtHost

I am looking for a way to query a central location and find out which user is connected to which server in a Pool.

Like in OCS we could Pull Per-User Reports from Database tab or query the Endpoint+FrontEnd table as it contains the information about all the users connected to any server in that Pool.

VA:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)
Leave A Reply

 Username (Required)

 Email Address (Remains Private)

 Website (Optional)