Report on all Catalog Items with the variable/variable set and questions

Go to solution
alhicks
Tera Guru

‎11-02-2022 07:23 AM

Hello,

 

Is there any way to report on all our Catalog Items and display the variable and variable sets for that Item all in one report?  

0 Helpfuls
  • 1,864 Views
1 ACCEPTED SOLUTION

Go to solution
Musab Rasheed
Tera Sage
Tera Sage
In response to alhicks

‎11-03-2022 12:03 AM

You have to explore links I have provided and accept the Limitation

Please hit like and mark my response as correct if that helps
Regards,
Musab

View solution in original post

7 REPLIES 7

Go to solution
alhicks
Tera Guru
In response to Musab Rasheed

‎11-02-2022 08:06 AM

Thank you Musab, yeah I saw those.  We were hoping to avoid database views and was concerned that reporting on the sc_req_item table would cause us to miss Items that have not been used yet.  😞   But if that's the only way, then we may have to do that.  Thank you for your reply.  🙂

0 Helpfuls

Go to solution
Musab Rasheed
Tera Sage
Tera Sage
In response to alhicks

‎11-02-2022 09:26 AM

Check these links as well

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0753516

https://www.servicenow.com/community/now-platform-blog/report-on-item-variables-in-the-service-catal...

https://www.youtube.com/watch?v=nk9A6tBQvSA

https://www.youtube.com/watch?v=6Qn8hUuz4Vs

Please hit like and mark my response as correct if that helps
Regards,
Musab
Use #ServiceNow Catalog Item & Record Producer Variables like a BOSS! (ServiceNow Toolbox)
Use #ServiceNow Catalog Item & Record Producer Variables like a BOSS! (ServiceNow Toolbox)
support.servicenow.com/kb?id=kb_article_view&sy...
Variables have come a long way since the early days of ServiceNow. Here we learn how we can leverage variables from Catalog Items or Record Producers in #ServiceNow reporting, business rules, slas, notifications, and scripts. 🔎 Looking for #ServiceNow talent or opportunity? ...
ServiceNow - How to Setup a Report Using a Service Catalog Variable in Kingston
ServiceNow - How to Setup a Report Using a Service Catalog Variable in Kingston
youtube.com/watch?v=nk9A6tBQvSA
Items demonstrated/discussed in this video: * Navigated to Maintain Items and displayed the Catalog Item. * Navigated to and displayed the Variable created. * Showed the Variable on the order form. * Displayed the records in the sc_req_item list. * Navigated to the Reports and showed the report I
ServiceNow - How to Setup a Report Using a Service Catalog Variable in Kingston
ServiceNow - How to Setup a Report Using a Service Catalog Variable in Kingston
youtube.com/watch?v=6Qn8hUuz4Vs
Items demonstrated/discussed in this video: * Navigated to Maintain Items and displayed the Catalog Item. * Navigated to and displayed the Variable created. * Showed the Variable on the order form. * Displayed the records in the sc_req_item list. * Navigated to the Reports and showed the report I

Go to solution
alhicks
Tera Guru
In response to Musab Rasheed

‎11-02-2022 10:56 AM

Thank you Musab, this is very helpful.   We'd like to have a database view without the RITM's.  We really just want a list of all Catalog Items(maintain items) and a list of all the variables/variable sets that are actually on that Catalog Item.  Instead of having to go into each catalog Item to see what variables it has.   Is that doable in a database view?

0 Helpfuls