Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note

None.

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.

The RtICDStatistics table contains the fields shown in 

longestwaitduration

Longest wait duration.

int

NOT NULL

callswaiting

Number of calls waiting.

int

NOT NULL

enddatetime

The date and time that this table data was last 
updated.

datetime year to 
second

NOT NULL

workingagents

Number of agents who are in the working state.

int

NOT NULL

talkingagents

Number of agents who are in the talking state.

int

NOT NULL

reservedagents

Number of agents who are in the reserved state.

int

NOT NULL

startdatetime

The date and time that this table’s statistics get 
collected.

datetime year to 
second

NOT NULL

convavgtalkduration

Average talk duration in HH:MM:SS format.

varchar(25)

NOT NULL

convavgwaitduration

Average wait duration in HH:MM:SS format.

varchar(25)

NOT NULL

convlongesttalkduration

Longest talk duration in HH:MM:SS format.

varchar(25)

NOT NULL

convlongestwaitduration

Longest wait duration in HH:MM:SS format.

varchar(25)

NOT NULL

convoldestcontact

Oldest call in the queue in HH:MM:SS format.

varchar(25)

NOT NULL