question Create Report of Each User in List Collector in Developer forum

Create Report of Each User in List Collector

Steven Parker — Mon, 21 Apr 2025 18:19:03 GMT

We have a variable on a catalog item that is referencing the User table and that variable is "Reource(s)"

How can I report on this field by each user in the list collector? The idea is we want to see how many tasks/RITMs this user is currently listed as a "Resource" on.

So if we have John, Jane, Andy is one list collector of an RITM and then John and Jane is the 2nd list collector on a different RITM, I would like to see a bar chart with those 3 people listed and counts - John - 2, Jane - 2, Andy - 1.

Basically we trying to see how many RITMs a resource is a part of.

Re: Create Report of Each User in List Collector

Allen Andreas — Mon, 21 Apr 2025 19:50:59 GMT

Hi,

You could try to create a report on the sc_req_item table of type pivot or multi-level pivot and dot-walk to the respective RITM variable and then build it that way. Alternatively, you could create a data visualization using the same concept of type pivot table, etc. and go that route.

The main idea here is that building it off of the RITM table and then drilling down to variable(s) and a pivot style should get you something like what you'd like. You can add other filter conditions to it as well (such as active=true, etc.) and narrow down the results.

Re: Create Report of Each User in List Collector

jcmings — Mon, 21 Apr 2025 21:17:44 GMT

Reporting on list collectors is unfortunately a huge pain in the ____. There is one solution that you may be able to follow here: https://www.servicenow.com/community/performance-analytics-blog/reporting-on-lists-part-3-3-on-conquer-challenging-reports-by/ba-p/2268483