How to Get Columns in a List Gauge from a Requested Item Variable Editor

[JPlace]

Hello,

I am trying to create a list gauge that includes columns from the variable editor. I think I might have to create a Database View using the Requested Item and Variable Ownership table, but have so far been unsuccessful. If anyone can help point me in the right direction, it would be greatly appreciated!

Thanks,

-John

[JPlace]

Hopefully I am overlooking something, but I am not sure this is going to be possible in ServiceNow. I can report on the variable set using the variable ownership table, but doesn't seem like there is a way to list the variable fields in a gauge and maybe this is due to all the data for question and value being in two columns. I know I could transform the data outside ServiceNow. I am using a the variable set for on-boarding and ideally would be able to list some of these variables as columns in an on-boarding gauge.

[JPlace]

This can be done with Database views.

[mike_allgire]

Were you able to get the Variable Editor as a single column? If so, what table did you pull it from?

[JPlace · Accepted solution]

Hello Mike,

Sorry for the delay. You need to join sc_req_item, sc_item_option and sc_item_option_mtom.

Not sure this is the best way, but here is how we did it.

Table: Requested Item[sc_req_item]

Variable Prefix: req

Where Clause: req_cat_item =   'put item sys_id here'

Options [sc_item_option]

Variable Prefix: test

test_item_option_new = 'put variable sys_id here'

Table: Variable Ownership[sc_item_option]

Variable Prefix: vartest

Where Clause: vartest_request_item = req_sys_id && vartest_sc_item_option = test_sys_id

Best,

-John