McDewey

Storage Description Field Name int NULL Number of agents who are in the talking state. talkingagents int NULL Number of agents who are in the reserved state. reservedagents datetime year to second NULL The date and time that this table’s statistics get collected. startdatetime varchar(25,0) NULL Average talk duration in HH:MM:SS format. convavgtalkduration varchar(25,0) NULL Average wait duration in HH:MM:SS format. convavgwaitduration varchar(25,0) NULL Longest talk duration in HH:MM:SS format. convlongesttalkduration varchar(25,0) NULL Longest wait duration in HH:MM:SS format. convlongestwaitduration varchar(25,0) NULL Oldest call in the queue in HH:MM:SS format. convoldestcontact RtICDStatistics Database table name: RtICDStatistics The RtICDStatistics table contains real-time summary statistics about Unified CCX. This table gets updated automatically when real-time snapshot data writing for this table is enabled through the Unified CCX Administration pages (Tools > Real-time snapshot configuration menu option). The updating frequency is based on the configured data writing interval. Table 63: RtICDStatistics Table Fields Storage Description Field Name nvarchar(50,0) NOT NULL Primary Key Contact Service Queue type that identifies the contact type it services. It can be either voice or e-mail. type int NULL Number of CSQs configured. totalcsqs Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 89 Database Schema RtICDStatistics