- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2014 11:58 AM
Some of our catalog requests require the user to enter their name (and other important info) into variables that get included in the Request, RITM, and Tasks. Often times we need to find who the request is for. However, that information is contained within a variable and we don't know how to search for it (short of opening each request one at a time until we find the one we want). Is there a way to include those variables in a list so we can search on them? If not, is there another method that would be helpful?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2014 08:55 AM
So it creates a new table (should be the one you are seeing...I don't see your screen shot). That's actually the table you will run reports off of...but it should be empty at the moment.
So the way the table gets populated, is you go into a variable for an item and you should see a new true/false check box "Visible on variable log". You will have to switch this property to true for every variable you want to be able to pull a report on... If you have a lot and want to run it on all, I'm sure a script could take care of that. Our instance is relatively new, so I just did it in mass. What should occur now is that everytime an item is ordered...any variable with that box checked will create a new record in the new table with the request item number and any variable you want logged attached to it. So it only applied to requests created from now forward...
We wanted to pull reports on everything we've ever done, so I took the script that came packaged with the update set, and put it into a scheduled job and ran it. This populated the table with pretty much every variable ever filled in by anyone on our instance, and the attached request item. So we can pull full reports on the variables now.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2014 07:44 AM
I would search for "Catalog Variable Reporting" on Share. I've implemented this in our prod instance and it's very well done! We've already switched all of our billing reports over to use this. It produces much nicer results than the variable ownership table.