- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-20-2016 07:40 AM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-20-2016 02:05 PM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-20-2016 07:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-20-2016 07:57 AM
Let me correct myself. The variable start_date is actually attached to an order guide, not the items themselve

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-20-2016 08:03 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-20-2016 07:48 AM
On Eureka onwards you can generate reports on variables.
Select the table as Requested Item and in condition select the variables and variable name.