Can We Search on Data Within Task Variables?

[ajlabate]

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?

[ajlabate]

I retrieved the update set, previewed it (got 2 errors that I had a newer local update set), then committed it. Where do I go to see this? I'm not sure how to invoke it.

>>> Aaron Anderson <community-no-reply@servicenow.com> 7/18/2014 11:13 AM >>>

( https://community.servicenow.com/?et=watches.email.thread )

Can We Search on Data Within Task Variables?

reply from Aaron Anderson ( https://community.servicenow.com/people/Aaron?et=watches.email.thread ) in Support - View the full discussion ( https://community.servicenow.com/message/711205?et=watches.email.thread#711205 )

If this helps you out and answers your question/requirement, please remember to mark this as answered

Reply to this message by going to ServiceNow ( https://community.servicenow.com/message/711205?et=watches.email.thread#711205 )

Start a new discussion in Support at ServiceNow ( https://community.servicenow.com/choose-container.jspa?contentType=1&containerType=14&container=2008&et=watches.email.thread )

Following Can We Search on Data Within Task Variables? ( https://community.servicenow.com/message/711205?et=watches.email.thread#711205 ) in these streams: Inbox

( https://www.facebook.com/servicenow ) ( https://twitter.com/servicenow ) ( http://www.linkedin.com/company/servicenow ) ( http://www.servicenow.com )

"This electronic mail message contains information which may be confidential, privileged and protected from further disclosure. Such information relates to and is used for all purposes outlined in the statutes below, including Peer Review, Performance Improvement, Quality Assurance and Claims Management and Handling functions and/or Attorney-Client Communications. It is being produced within the scope of all Georgia and Federal laws governing record confidentiality, including (but not limited to) Official Code of Georgia Annotated Sections 31-7-15; 31-7-130; 31-7-131; 31-7-132; 31-7-133; 31-7-140; 31-7-143.

If you are not the intended recipient, please be aware that any disclosure, photocopying, distribution or use of the contents of the received information is prohibited. If you have received this e-mail in error, please reply to the sender immediately and permanently delete this message and all copies of it. Thank you.

Communication of electronic protected health information (ePHI) is protected under the Health Insurance Portability and Accountability Act (HIPAA) Act of 1996. Electronic mail (e-mail) communication is not encrypted or secure. The HIPAA Security Rule allows for patients to initiate communication of personal health information over this medium and for providers to respond accordingly with the understanding that privacy of communication is not guaranteed."

[Inactive_Us1976]

You should see a new table under your Service Catalog Application Menu.   You will have to mark all the variables that you want to report on within the variable.   The OOB update set only applies to requests created after the update set is applied and the check box is check within the variable.   I took the script from the update set and set it to a scheduled run, and ran it on all my existing variables to populate the table with everything that already existed.

[ajlabate]

I'm still a bit lost. This is a screen shot:

The "Catalog Variable Log" is new, but I'm still confused on where to go from here.

>>> pduff <community-no-reply@servicenow.com> 7/18/2014 11:28 AM >>>

( https://community.servicenow.com/?et=watches.email.thread )

Can We Search on Data Within Task Variables?

reply from pduff ( https://community.servicenow.com/people/pduff?et=watches.email.thread ) in Support - View the full discussion ( https://community.servicenow.com/message/711209?et=watches.email.thread#711209 )

You should see a new table under your Service Catalog Application Menu. You will have to mark all the variables that you want to report on within the variable. The OOB update set only applies to requests created after the update set is applied and the check box is check within the variable. I took the script from the update set and set it to a scheduled run, and ran it on all my existing variables to populate the table with everything that already existed.

Reply to this message by going to ServiceNow ( https://community.servicenow.com/message/711209?et=watches.email.thread#711209 )

Start a new discussion in Support at ServiceNow ( https://community.servicenow.com/choose-container.jspa?contentType=1&containerType=14&container=2008&et=watches.email.thread )

Following Can We Search on Data Within Task Variables? ( https://community.servicenow.com/message/711209?et=watches.email.thread#711209 ) in these streams: Inbox

( https://www.facebook.com/servicenow ) ( https://twitter.com/servicenow ) ( http://www.linkedin.com/company/servicenow ) ( http://www.servicenow.com )

"This electronic mail message contains information which may be confidential, privileged and protected from further disclosure. Such information relates to and is used for all purposes outlined in the statutes below, including Peer Review, Performance Improvement, Quality Assurance and Claims Management and Handling functions and/or Attorney-Client Communications. It is being produced within the scope of all Georgia and Federal laws governing record confidentiality, including (but not limited to) Official Code of Georgia Annotated Sections 31-7-15; 31-7-130; 31-7-131; 31-7-132; 31-7-133; 31-7-140; 31-7-143.

If you are not the intended recipient, please be aware that any disclosure, photocopying, distribution or use of the contents of the received information is prohibited. If you have received this e-mail in error, please reply to the sender immediately and permanently delete this message and all copies of it. Thank you.

Communication of electronic protected health information (ePHI) is protected under the Health Insurance Portability and Accountability Act (HIPAA) Act of 1996. Electronic mail (e-mail) communication is not encrypted or secure. The HIPAA Security Rule allows for patients to initiate communication of personal health information over this medium and for providers to respond accordingly with the understanding that privacy of communication is not guaranteed."

[Inactive_Us1976 · 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.

[ajlabate]

Thank you for your help. My Catalog Variable view is getting populated. Is there a way I can get these variables to appear in someone's Task list, or their My Work, or My Groups Work views?

>>> pduff <community-no-reply@servicenow.com> 7/18/2014 11:55 AM >>>

( https://community.servicenow.com/?et=watches.email.thread )

Can We Search on Data Within Task Variables?

reply from pduff ( https://community.servicenow.com/people/pduff?et=watches.email.thread ) in Support - View the full discussion ( https://community.servicenow.com/message/711228?et=watches.email.thread#711228 )

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.

https://community.servicenow.com/servlet/JiveServlet/downloadImage/2-711228-11925/ScreenShot2014-07-18at10.54.02AM.png ( https://community.servicenow.com/servlet/JiveServlet/showImage/2-711228-11925/ScreenShot2014-07-18at10.54.02AM.png )

Reply to this message by going to ServiceNow ( https://community.servicenow.com/message/711228?et=watches.email.thread#711228 )

Start a new discussion in Support at ServiceNow ( https://community.servicenow.com/choose-container.jspa?contentType=1&containerType=14&container=2008&et=watches.email.thread )

Following Can We Search on Data Within Task Variables? ( https://community.servicenow.com/message/711228?et=watches.email.thread#711228 ) in these streams: Inbox

( https://www.facebook.com/servicenow ) ( https://twitter.com/servicenow ) ( http://www.linkedin.com/company/servicenow ) ( http://www.servicenow.com )

"This electronic mail message contains information which may be confidential, privileged and protected from further disclosure. Such information relates to and is used for all purposes outlined in the statutes below, including Peer Review, Performance Improvement, Quality Assurance and Claims Management and Handling functions and/or Attorney-Client Communications. It is being produced within the scope of all Georgia and Federal laws governing record confidentiality, including (but not limited to) Official Code of Georgia Annotated Sections 31-7-15; 31-7-130; 31-7-131; 31-7-132; 31-7-133; 31-7-140; 31-7-143.

If you are not the intended recipient, please be aware that any disclosure, photocopying, distribution or use of the contents of the received information is prohibited. If you have received this e-mail in error, please reply to the sender immediately and permanently delete this message and all copies of it. Thank you.

Communication of electronic protected health information (ePHI) is protected under the Health Insurance Portability and Accountability Act (HIPAA) Act of 1996. Electronic mail (e-mail) communication is not encrypted or secure. The HIPAA Security Rule allows for patients to initiate communication of personal health information over this medium and for providers to respond accordingly with the understanding that privacy of communication is not guaranteed."