Reporting on Incident Variables

Michael Kaufman
Giga Guru

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

1 ACCEPTED SOLUTION

TJW2
Mega Guru

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


View solution in original post

4 REPLIES 4

Bhavesh Jain1
Giga Guru

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
Mega Guru

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


That is correct.   Thanks!


janestone
Kilo Contributor

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