The Requested Item [screqitem] table is the correct source for this report. Each time a user orders an item from the Service Catalog, a unique Requested Item (RITM) record is created. This record contains all the specific details of that order, including the catalog item ordered and the values selected for its associated variables, such as 'extra memory'. Therefore, to compare how many requests for the 'Computer' item included extra memory versus the base configuration, one must report on the screqitem table and group the results by the specific variable that captures the memory choice.

A. Build report on SC Task table, Group by Variables for Computer > Extra memory: The Catalog Task table (sctask) contains fulfillment tasks. Reporting here is unreliable as an item may have multiple tasks or none at all.

C. Build report on Task table, Group by Variables for Computer > Extra memory: The Task table (task) is a base table for all tasks. It is too generic and does not directly contain catalog variable information.

D. Build report on Request table, Group by Variables for Computer > Extra memory: The Request table (screquest) is a high-level container for one or more requested items and does not store item-specific variable data.

E. Build report on Catalog Item table, Group by Variables for Computer > Extra memory: The Catalog Item table (sccatitem) stores the definition of the item, not the transactional data of individual orders and their selected options.

1. ServiceNow Product Documentation

"Reporting on service catalog variables": This document explicitly states

"You can report on service catalog variables that are associated with a requested item." It guides users to select the Requested Item [screqitem] table as the data source when building such reports. (ServiceNow Product Documentation

ITSM

Service Catalog

Doc ID: KB0718148

Section: "Procedure").

2. ServiceNow Product Documentation

"Service Catalog data model": The official data model illustrates that the Requested Item [screqitem] table is the central record linking a Request (screquest) to a specific Catalog Item (sccatitem) and its associated Variables. This confirms it as the correct table for transactional reporting on ordered items and their options. (ServiceNow Product Documentation

ITSM

Service Catalog

Section: "Service Catalog data model").

3. ServiceNow Developer Documentation

"screqitem table": The API documentation for the screqitem table describes its purpose as managing "individual items in a request

" which includes the variables chosen for that specific item instance. (ServiceNow Developer Documentation

API Reference

Tables

screqitem).