Request Item variables are not stored directly on the sc_task table. The Catalog Task (sc_task) references the Requested Item (sc_req_item) through the Request Item field.
To export variable values, you can:
Create a report on sc_task.
Dot-walk to the Request Item field (Request Item → Variables), if the required variables are available for reporting.
Alternatively, create a database view or script that joins:
- sc_task
- sc_req_item
- sc_item_option_mtom
- sc_item_option
This approach provides access to all catalog variable names and values associated with the RITM linked to the task.
If you need the data in Excel for a large number of tasks, a scripted export using GlideRecord is usually the most flexible option, as catalog variables are stored separately from the task record itself.
