02-24-2020 10:54 AM
Are there any stock reports available that shows the wrap up codes for UCCE 12 CUIC? Any recommendations on how to create this report?
07-29-2020 01:01 PM - edited 07-29-2020 01:05 PM
Did you ever get this resolved? I need the same report!
07-29-2020 01:46 PM
Wrapup Data are not Codes - is a free string and so anything can be entered - even if Finesse only allows you to enter a wrap up string - pre configured by an admin. This makes it less easy to make a summary report.
iWrap up data is not in any summary table (i.e. the interval tables - such as Callltype, Agent, Skillgroup etc.)
It is stored in the Termination Call Detail table (TCD) and so you have a record for each agent transaction.
You can of course create a summary report by grouping values etc from this table - but this will be an SQL query which could take some time and be intensive (from a SQL / CPU point of view) - so you might want to export the TCD table and create your own.
Below is a TCD SQL query which gives you a row per TCD record which includes the wrap data column.
You could create one specific to wrap up Data with groupings and counts etc. - which would make sense for a wrap data report. It would not be too hard to do.
http://orourke.tv/web/doku.php?id=vendors:cisco:uc:icm:sql:tcd-tcv
Gerry
07-29-2020 06:26 PM
Gerry's,
Comment is spot on. There's really nothing out of the box for what you're looking for and if you want multiple wrap up codes there's even less help. A recent project of mine involved creating a separate gadget which went to a separate DB which allows multiple wrap up codes and at that point the reporting was so much simpler.
https://photos.app.goo.gl/BwkoDzDBLcc7DtFe6
david
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide