Where are variable answers stored for catalog items (sc_task)?

[sschleicher]

Variables for incidents appear to be stored in the table question_answer. For any incident sys_id using direct web services, I can retrieve the list of questions and corresponding answers from this table (works just fine). It appears I cannot, however, do the same thing for variables attached to catalog items (sc_task). They don't appear to be stored in the same question_answer table. Does anyone know what table these values could be retrieved from by the sc_task sys_id similar to how variables for incidents are retrieved?

Thanks,

[Jim Coyne]

Check out the Variable Ownership table (sc_item_option_mtom).

[sschleicher]

Thanks for the response. I also came across this link that indicates use of a view with that same table to achieve what I'm looking for. Might help others as well. https://wiki.servicenow.com/index.php?title=Reporting_on_Service_Catalog_Variables

[johnram]

The ServiceNow Wiki content is no longer supported. Updated information about this topic is located here: Service Catalog Variable Reports

Visit http://docs.servicenow.com for the latest product documentation