Report on Service Catalog items

[Melanija]

Hi All,

I am pretty new to ServiceNow and have to create two reports below:

Need to create:

1. Report showing the no. of all catalog items

2. Report showing the no. of catalog items marked as favorites

Can someone please help me find out which table to use and how to set up the reports (if any special conditions needed)?

Thanks a million!

M

[Sagar Pagar]

Hi @Melanija,

For reports-

1) You have to create a report on Maintain items [sc_cat_item] table with active is true and additional your conditions.

2) For favorites, is there any field or functionality that you have configured? then you have to create a report on the same.

Thanks,

Sagar Pagar

[chrisperry · Accepted solution]

Hi there,

1. Report showing no. of all catalog items:

2. Report showing no. of catalog items marked as favorites (report on Favorite (App Use) sn_ex_sp_st_favorite table where Category is Request):

[Melanija]

Hi Chris,

thank you so much for your help!

Report for number of all catalog items is working perfectly well!

Just wanted to check the condition for catalog items marked as favorites. Is it 'Category is Request'?

When I select Fav table an add this condition, there are no records to display. Does it mean I am doing something wrong or we don't have any catalog item marked as favorite?

Thanks a lot!

MJ

[chrisperry]

It depends on where you are looking for the catalog items marked as favorite. The table/report that I provided above displays catalog items marked as favorite from Employee Center. So there might not be any catalog items that have been marked as favorite in Employee Center. Are you looking for favorited catalog items from somewhere else that isn't Employee Center?