Cisco Cisco Customer Voice Portal 8.0(1)

   AND Call.CallGuid=VXMLSession.CallGuid

   AND VXMLSession.SessionID=VXMLElement.SessionID

   AND VXMLElement.ElementID=VXMLElementFlag.ElementID;

Where CallGuid is replaced by the value of the CallGuid for which information is desired.

VXMLCustomContent Table

This table contains one record for each VoiceXML custom event. This event occurs if a custom

component programmatically calls the addToLog method of the Session API. The event will

also occur when an element whose configuration contains entries in the Add To Log table in

the General tab is run.

The unique id of a visited

element

Indexed FK

(Composite index

No

int8

ElementID

ElementID,

CallStartDate)

Date of the call, for data

purging purposes

FK (Composite index

ElementID,

CallStartDate)

No

date

CallStartDate

The name of the custom event

variable

No

No

nvarchar(51)

VarName

The value of the custom event

variable

No

Yes

nvarchar(255)

VarValue

Date and time when the

variable is changed

Yes

No

datetime YEAR to

FRACTION(3)

EventDateTime

The date and time of the

database operation (when the

Yes

No

datetime YEAR to

FRACTION(3)

DBDateTime

record was inserted). This is

useful for debugging purposes

to determine lags between

when the event occurred

versus when it was written to

the database (for example, a

long lag may indicate

problems with the reporting

server).

VXMLElement Table

This table contains one record for each VoiceXML script element visited by a call. For example,

if the same element is visited twice in an application script during a call, there will be two

separate element records.

Reporting Guide for Cisco Unified Customer Voice Portal Release 8.0(1)