CIS-ITSM · Question #44
A manager wants to run a report on the Computer catalog items, to see how many requests are being made for the add on extra memory, as compared with those requiring only the base memory. How would…
The correct answer is B. Build report on Requested Item table, Group by Variables for Computer > Extra memory. Reports on catalog item variable data must be built against the Requested Item (sc_req_item) table because that table stores the per-item variable values captured when a catalog item is ordered.
Question
A manager wants to run a report on the Computer catalog items, to see how many requests are being made for the add on extra memory, as compared with those requiring only the base memory. How would you meet this requirement?
Options
- ABuild report on SC Task table, Group by Variables for Computer > Extra memory
- BBuild report on Requested Item table, Group by Variables for Computer > Extra memory
- CBuild report on Task table, Group by Variables for Computer > Extra memory
- DBuild report on Request table, Group by Variables for Computer > Extra memory
- EBuild report on Catalog Item table, Group by Variables for Computer > Extra memory
How the community answered
(32 responses)- A6% (2)
- B75% (24)
- C13% (4)
- D3% (1)
- E3% (1)
Why each option
Reports on catalog item variable data must be built against the Requested Item (sc_req_item) table because that table stores the per-item variable values captured when a catalog item is ordered.
The SC Task table (sc_task) stores fulfillment tasks generated from requests, not the variable data tied to the ordered item.
The sc_req_item table (Requested Items) holds one record per catalog item ordered, along with all associated variable values such as 'Extra memory'. Grouping by a variable on this table correctly counts how many requests were made for each variable option, satisfying the comparison requirement between base memory and extra memory selections.
The Task table (task) is the parent table for all task-type records; it does not store catalog variable data directly.
The Request table (sc_request) stores the cart-level request container, not the individual item's variable data.
The Catalog Item table (sc_cat_item) stores the item definitions and configuration, not individual request or variable response data.
Concept tested: Reporting on catalog item variables using sc_req_item
Source: https://docs.servicenow.com/bundle/washingtondc-it-service-management/page/product/service-catalog-management/concept/c_ServiceCatalogTables.html
Topics
Community Discussion
No community discussion yet for this question.