Technical References

ManualsBrandsCisco ManualsCollaboration EndpointsCisco ICM Definity Gateway Feature

Keys and Null Option:Data Type:Description:Field Name:

• N = No, an agent cannot send data.

AK-1, FK NOT NULLDBSMALLINT

The peripheral from which agent data is sent.

PeripheralID

Agent_Event_Detail Table

This table is one of the Agent Detail tables in the Skill Target category (page 456). To see

database rules for these tables, click here (page 510).

This table can become very large. Running custom reporting queries against it while it is on the

HDS can degrade performance. To optimize performance, extract the data from the HDS into

your own custom database on a separate server (one that is not used for other ICM/IPCC

components). Use only DBDateTime (date and time of the record that was written to the HDS

database) to perform the extraction. The table on the custom database can be indexed according

to the custom reporting needs.

Displays agent LOGIN, LOGOUT, and NOT_READY events.

Table 8: Related Tables for Agent_Event_Detail

Media Routing Domain (page 234) (via MRDomainID)Agent (page 15) (via SkillTargetID)

Table 9: Indexes for Agent_Event_Detail Table

index_keysindex_descriptionindex_name

RecoveryKeynonclustered, unique, unique key

located on PRIMARY

XAK1Agent_Event_Detail

DbDateTimenonclustered located on PRIMARYXIEIAgent_Event_Detail

DateTime, SkillTargetID, MRDomainID,

TimeZone

clustered, unique, primary key

located on PRIMARY

XPKAgent_Event_Detail

Fields in Agent_Event_Detail Table :

Keys and Null

Option:

Data Type:Description:Field Name:

PK NOT NULLDBDATETIME

The date and time (in Central Controller local time) that the transition for

the event occurred.

DateTime

IE-1 NULLDBDATETIME

The current date and time stamp when the records are written to the HDS

database. The logger database has NULL for this column.

DbDateTime

NULLDBINT

Duration in seconds associated with the EVENT:

Duration

LOGOUT: Number of seconds the agent was logged into the Media

Routing Domain.

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)

Chapter 2: All Tables

Agent_Event_Detail Table