How to display a variable set variable in a list, for reporting?

tombialkowski
Giga Expert

We have a variable called 'start_date', contained within a variable set for new hires in our service catalog. I would like to create a list of all catalog items requested, and include the start_date as a field in the list for reporting purposes. Can anyone suggest how might I go about this?

1 ACCEPTED SOLUTION

tombialkowski
Giga Expert

Figured it out.



Create a database view between sc_task and sc_item_option_mtom to join the two tables.


Create a report using this view.



Reporting on Service Catalog Variables - ServiceNow Wiki


View solution in original post

9 REPLIES 9

jshafton21
Kilo Guru

If you create your report off the Request Item (sc_req_item). You can add a variable to the List view.



find_real_file.png


Let me correct myself. The variable start_date is actually attached to an order guide, not the items themselve


Ahh in that case you won't be able to report on it unless it carries over into a request item. Order guide variables are essentially temporary. I had this same problem so I created a request item named Order Guide Variables all the variables would carry over to this item, to allow me to run my approvals off the order guides. The Order Guide Variables Item has basically no workflow it starts pauses and stops.


Ravi Prasad1
Tera Guru

On Eureka onwards you can generate reports on variables.



Select the table as Requested Item and in condition select the variables and variable name.