Reporting on Incident Variables

[Michael Kaufman]

What table are incident variables stored?   Like if you create an incident from a record producer, the variables, what table or field are they in?

The variables for Requested Item Variables is in the Variables Ownership [sc_item_option_mtom] table, but where do incident variables end up?

Reporting on Service Catalog Variables - ServiceNow Wiki

[Bhavesh Jain1]

I think the life of variables end when the record producer is submitted. The purpose of record producer is to map the variables to the fields of incident form after which it is of no use. In case you would like to refer to them later, you can write a script in the record producer to update it in incident field.

I dont think reporting is possible for record producer variables.

[TJW2 · Accepted solution]

Variables on Record Producers are stored in the 'question_answer'   table.

[Michael Kaufman]

That is correct.   Thanks!

[janestone]

And what table is it that holds the value for the answer? The question_answer table only holds an id for the value.