Which MDB table will list Active Remote Control sessions information ?

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

 

 

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