Question: any way to extract/report on IC form data for existing logged Requests?

[Berto2002]

One of my team has been asked to "extract the answers from the Questions field in all the tickets of a certain type". This is IC form data that the workflow has not committed to custom fields (as I could have done if reporting was a requirement :-)

1. Is there any way to do this other than manually? I.e. is IC data stored anywhere?

2. If I want to store all the answers to the IC form questions in a single field, is there a fastpath aproach in the BPM nodes following a "GET PCF Answers" node to be able to this?

[Steve Giller]

That sounds like a rather odd and overly generic request, and is probably going to gather a lot more data than is necessary.

However, the starting point for this would be the h_itsm_questions table.

[Berto2002]

Thank you

[Steve Giller]

Sorry - I forgot point 2

There would be no real benefit to this as the data is in its own table, so reproducing it in another table would be inefficient - and the data would probably not be human-readable without a huge amout of manipulation anyway.