I was needing to build a report containing the number of surveys sent to customers and what percentage of them was successfully answered. I found the Survey_Stats table, having these fields:
I've identified two fields above (cyc_counter, sub_counter) that could be useful for me. In a chat with an CA analyst, he did some tests and verified these fields indeed register the number of survey that was sent to customers.
My question is: what's the difference between cyc_counter and sub_counter fields? What means a notification to be "approved"? Note: in all environments I checked, the two fields contained the same number for each SDM.
I believe it is as follows:
The cyc_counter counts the number of cycles for which that survey has been sent out.
The sub_counter counts the nubmer of surveys that have went out during a given cycle.
I think this may help as well:
Survey - CA Service Management - 17.0 - CA Technologies Documentation
Diogo, I think the cyc_counter is the current counter of current cycle of the survey...for example, let us say the survey cycle is 5, then cyc_counter will start from 1, next 2, next 3, next 4 and next 0 and so on...that is, whenever and suvey
is checked to see if we should send it, it is checked by (cycle-cyc_counter) and if that is 0, send the survey and reset
cyc_counter to 0 and start over again. For sub_counter, it simply records how many of this survey have been sent so far.
Hope this helps. Thanks _Chi
Thanks Chi_Chen - this is a much better explanation than mine!!
@diogo.nobrega - does this help you out more?