Where are Catalog Item Variables stored for a catalog item?

[Steve42]

I have a catalog item that I would like to find out where the variable values are stored, or are they only stored in memory until the REQ and RITM get created then destroyed.  Asking as I would not like to regex the out of the description field if possible.

[Steve42]

We are doing a AD to SNOW integration for creating accounts as we don't have the integration hub, so needed to obtain the variables from the catalog item with the information so we can get the ac account created.

I think what you have given with the tables might just work.  Thank you.

[Mark Roethof]

Hi there,

Did this solve your question? Or do we need to follow-up on this?

Please mark this answer as correct if it solves your question. This will help others who are looking for a similar solution. Also marking this answer as correct takes the post of the unsolved list.
Thanks.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[Jundan_ Ahmad]

Hi,

I also been looking for how to get variables created for a catalog item. I tried to get the information from the tables you provided:

sc_item_option
sc_item_option_mtom
sc_multi_row_question_answer

I found that the 3rd table didn't return any records

The sample below I hope will give you some information on what I am trying to get:

I created this:

Catalog Category > Access

Catalog Item > Business Applications

Variables (Select Box/Question Choices) > SAP, Travel System, SharePoint 

I am able to get Catalog Category and Catalog Item, but how to get its variables for a catalog item?

Thanks

Jundan