Where does the CVP reporting server gets the app session data from ? For example call detail report has the info related to each element like its name and exit state,etc? I'm aware that the reporting server uses the DB but then how does the db gets this applicaton data? Could you please brief me up on the reporting methodology in CVP.What all the app developers should do in the code to get the data into CVP reports (CUIC) ? Thanks so much for your time,.
I would suggest you read up the reporting server guide and documents to understand this:
Thank you Jameson.
The reporting guide has the following note:
This table contains one record for each VXML 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.
Though we'll the addToLog method, we should set the filters in OAMP - Correct? Otherwise the data will not appear in VXMLCustomContent table? Thanls for all your responses.
Oops, looks like I was mistaken.
Yes, the AddToLog method will output data to the VXMLCustomContent table. It looks like you do not need to set up filters in OAMP for this to occur.
You would use the filters if you wanted to add any element or session data to the database. It looks like these values would be stored in VXMLElementDetail and VXMLSessionVariable tables.
Ok Thank you Jameson. Should we have premium license to execute custom queries on these tables? For example If I need to write a query that would populate data from both VXMLElementTable and CustomContentTable. Is that possible without premium license? I don't want to rely solely on stocl reports.
I see the following note in reporting guide but I guess it applies to only stock reports modification using CUIC app - Correct?..
"If you have a Premium license for Unified Intelligence Center, you can also modify the SQL query for the report definition, and design custom reports and report definitions using Save As."
Application summary reports (15, daily, and weekly),
Call detail report,
Call traffic reports (15, daily, and weekly),
Current and historical callback reports,
Trunk group utilization report