Can We Search on Data Within Task Variables?

ajlabate
Kilo Expert

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?

1 ACCEPTED SOLUTION

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.




View solution in original post

15 REPLIES 15

tltoulson
Kilo Sage

I believe this article covers what you are looking to achieve: Reporting on Service Catalog Variables - ServiceNow Wiki


darshanr
Kilo Guru

Hi Anthony,



What Travis said is right.But this feature is available in Eureka release.So if you are not in Eureka release you won't be able to see this.



Thanks,


Darshan


Darshan,



Are you sure?   I am in Calgary and I can produce a report on the Variable Ownership table and filter by the Question (in Anthony's case he would be searching for a Requested For variable) to retrieve a list of RITM records.



As I understand, filtering by Variables directly on the RITM table (the first Heading in the Wiki Article) is a Eureka feature (and a fantastic one at that).



But querying on the Variable Ownership table is the legacy method that is backwards compatible with previous versions.



Example from Calgary:



RITM by Variable.png


Hi Travis,



What you showed is right by quering Variable Ownership table.I thought of directly accessing that variables from Requested Item List Layout for users himself/herself after ordering which is available in Eureka release.



Thanks,


Darshan