Which MDB table will list Active Remote Control sessions information ?
book
Article ID: 185332
calendar_today
Updated On:
Products
CA Client Automation - Asset Management
CA Client Automation - IT Client Manager
CA Client Automation
CA Client Automation - Remote Control
Issue/Introduction
Which MDB table will list Active Remote Control sessions information ?
Environment
Client Automation - All versions
Resolution
SQL Table urc_active_session contains the list of active and terminated RC sessions
Following SQL Query could be used to get the details of active and terminated RC sessions.
SELECT
dateadd ( ss, datesessionstarted + datediff(ss,getutcdate(),getdate()), convert(datetime,'19700101')) 'Start Time',
strhost 'Host',
strviewer 'Viewer',
strremoteuser 'Remote User',
iduration 'Duration',
strstatus 'Reason Session Closed',
strdescription 'Description'
FROM urc_active_session
ORDER BY 1 DESC
Example :
By default Domain Manager keeps only the RC sessions history of last 24 hours with a maximum of 20000 sessions
But this could be configured in a configuration policy applied on Domain Manager.
In the configuration policy under DSM/Remote Control/Manager :
Age of sessions to purge (number of seconds)
Maximum number of sessions
![](https://api-broadcom-ca.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=1337073542220)
For example for a sessions history of 180 days with a maximum of 100000 sessions :
Age of sessions to purge = 15552000
Maximum number of sessions = 100000
Feedback
thumb_up
Yes
thumb_down
No