OCS – how to retrieve user information using SQL queries
There might be a situation where you would like an overview of the SIP URIs of the active users connected to one of the OCS servers in a pool, their last logon and what client version they are using. All these kind of information can be retrieved using SQL queries in the SQL Management Tools, connect to the RTC database on the backend server and run the selected queries below. Get a list of active …