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
Technology Tips and News
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
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
Best Regards,
Amy
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
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
In addition, here is a related article below for you:
A Closer Look at the RD Connection Broker Database in Windows Server 2012
Best Regards,
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