report on catalog task variable

salu
Mega Guru

Hello All,

I need to get a report which gives the RITM Number Task Number and Variables in one record.I have created a database view with sc_item_option_mtom and sc_task table.Now it is coming like below.

find_real_file.png

Is there any way to get the report like RITM,Task,IP address,Class,LifecyclePhase etc.

Please suggest on the same.

10 REPLIES 10

Brad Tilton
ServiceNow Employee
ServiceNow Employee

In Fuji you can report on variables as columns from the requested item or catalog tasks table. Just scroll to the bottom of the available fields list and select variables. It'll then ask you for a specific item to grab variables from.



0051ad67d5.png


Hello Brad,


Thank you for the reply.


We are using Eureka only .Is there any way in eureka for this?


Hi Saranya,



I believe the Catalog Variable Reporting may help you out: https://share.servicenow.com/app.do#/detailV2/6a1dc27d2b2bf5004a1e976be8da15de/overview  



Thanks,


Berny


Hello Berny,



Thanks for our reply


I am not able to login in to it as I don't have share or hi credentials



Thanks