What table(s) hold the variable and variable values for a request item?

[stevezadroga]

Team,

What table or tables in the database schema hold the variables and variable values?  For example, when I view a Request Item there is a section called variables with fields and values.  I am trying to understand what table or tables holds these values.  Ultimately, I am looking to JOIN these variable fields and values to the sc_req_item table.

[Harsh Vardhan]

adding link here, kindly refer that.

Reporting on ServiceNow Variables

https://community.servicenow.com/community?id=community_question&sys_id=01fff6eddb58dbc01dcaf3231f96...

[stevezadroga]

do you have the backend table names that hold variable names and variable values?  I am looking to make an API call to retrieve this data, but need the backend table names.

[Harsh Vardhan]

have you tried with variable ownership table (sc_item_option_mtom)?

use glide record to Query by the Request Item and you'll get a list of variables for it.

[sath]

Hi @Harsh Vardhan  Do you know which table holds the SCTASK variables and its values?

We have a requirement to copy SCTASK variables to Story and these variables are exclusive to SCTASK and they aren't visible on RITM.