SQL query RDS Broker Database

Hi

I could do with pulling details out of the RDSBroker_DB database, things like who is logged on and at what time and what server in the farm.

I've seen tables like rds.Server, rds.Session; is this possible to do with SQL Server?

Thanks

July 28th, 2015 8:34am

Hi,

I've seen tables like rds.Server, rds.Session; is this possible to do with SQL Server?

Would you please be more specific regarding what do you want to achieve by involving SQL sevrer?

We can achieve high availability by storing RD Connection Broker database on SQL server.

RD Connection Broker High Availability in Windows Server 2012

http://blogs.msdn.com/b/rds/archive/2012/06/27/rd-connection-broker-high-availability-in-windows-server-2012.aspx

Best Regards,

Amy

Free Windows Admin Tool Kit Click here and download it now
July 29th, 2015 8:00am

Hi Amy

What I mean is that I would like to know how to query the SQL database to find out details about what users currently have sessions, such as logon/log off times.

This is so we can write a SSRS report against the tables to easily run reports when needed for management.

Thanks

August 5th, 2015 11:28am

Hi,

What I mean is that I would like to know how to query the SQL database to find out details about what users currently have sessions, such as logon/log off times.

It seems like that we can use a script to dump contents of the RD Connection Broker database, which should be useful to you:

How to read the RD Connect Broker DataBase

https://social.technet.microsoft.com/Forums/windowsserver/en-US/31fb1510-f952-4c94-b343-addcb992d427/how-to-read-the-rd-connect-broker-database?forum=winserverTS

In addition, here is a related article below for you:

A Closer Look at the RD Connection Broker Database in Windows Server 2012

http://social.technet.microsoft.com/wiki/contents/articles/16246.a-closer-look-at-the-rd-connection-broker-database-in-windows-server-2012.aspx

Best Regards,

Free Windows Admin Tool Kit Click here and download it now
August 11th, 2015 4:11am

Hi,

The RDS deployment database really doesn't contain historical information, if that is what you are looking for.  For example, you cannot query it to find out what users logged on last Wednesday, what time each logged off, etc.  For that type of information you would query the logs on rds servers, and if desired you could import this into sql server other database for use with SSRS.

A non-HA RDS deployment uses Windows Internal Database (WID), which you cannot query remotely.

The supported method of viewing information from the RDS deployment is via the RDS powershell cmdlets.  For example, you can use Get-RDUserSession command in an administrator PowerShell prompt on your broker to see current user sessions:

 
Get-RDUserSession -CollectionName "YourCollection"
 

You could create a script to get information from the RDS deployment periodically and import it into sql server if that is something that would be useful to you.

-TP

August 11th, 2015 11:45am

Thanks TP that's sort of what we need, I'll have to go away and look at how we can implement a dumping of the data to SQL every so often.
Free Windows Admin Tool Kit Click here and download it now
August 12th, 2015 3:32am

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

Other recent topics Other recent topics