McDewey

MonitoredResourceDetail Database table name: MonitoredResourceDetail The MonitoredResourceDetail table records the actual agents who are monitored. The RemoteMonitoringDetail table records the original agent or the CSQ that the supervisor plans to monitor. Monitoring a CSQ involves monitoring the agents who handle calls for that CSQ. So the actual agents (there can be more than one) who are monitored will be recorded in the MonitoredResourceDetail table. Table 49: MonitoredResourceDetail Table Fields Storage Description Field Name decimal(18) NOT NULL Primary Key Identifier that the system assigns to the call. This identifier remains the same for all legs of the call. It is the sessionID of the IVR call; that is, when the supervisor starts monitoring, the monitoring call itself is an IVR call. The supervisor monitors one or more Unified CCX calls. sessionid datetime year to fraction (3) NOT NULL The date and time when the remote supervisor attempted to monitor the agent. startmonitoringreqtime datetime year to fraction (3) NOT NULL Primary Key The date and time when the remote supervisor began monitoring the call. startmonitoringcalltime int NOT NULL Identifier of the resource being monitored. monitoredrsrcid smallint NOT NULL The session sequence number of the Unified CCX call that is being monitored. monitoredsessionseqnum int NOT NULL Primary Key Identifier of the Unified CCX profile that is associated with this record. profileid int NOT NULL Offset, in minutes, between the local time of the Unified CCX server and Greenwich Mean Time. As the time information is stored in GMT, this field will always be zero. gmtoffset smallint NOT NULL Primary Key Unique identifier assigned to each server in the cluster. nodeid Related Topics Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 73 Database Schema MonitoredResourceDetail