Saturday, 19 May 2018

CUIC custom report

CUIC standalone custom reporting server.

I have been meaning to write about this for a while. I don't know why Cisco play sneak peek with customer reporting. I'm going to keep it very simple and basic. Plus, still learning and work in progress.Here it goes. Custom reporting in human language.A list of this you need.

1. CUIC standalone server.
* Please install similar version as your CCX if you are planning to create the report on CUIC and then import it to the CCX.
* But if you plan to use CUIC as the reporting server. Please feel free to install the latest version on CUIC.

2. Add your CCX server under CUIC source.
*It should be pretty simple plus, Cisco was kind enough to provide instruction for that.

3. Familiarize yourself with Simple SQL query.

*SELECT "Column1","Column2" FROM "TableName" WHERE "Your Condition goes here"

4. Get CCX Cisco dbSchema.Click here
* Go through schema table & know waht table provide what information and their column type.

5. Know the word ValueList, Anonymous block, Store Procedure, Field, Parameter etc.

*ValueList -
*Anonymous Block-

.......Will be back soon