What table are RITM's stored in

[joshmorris]

Im trying to report on RITM's however I am not sure what table I would select to report on these

[Dr Atul G- LNG · Accepted solution]

Hi @joshmorris 

sc_req_item

[Juhi Poddar]

Hello @joshmorris 

By reporting on the sc_req_item table, you can get a detailed view of the individual request items and their statuses.

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps others find the solution more easily and supports the community!"

Thank You
Juhi Poddar

[BillMartin]

Hi @joshmorris, 

To report on RITMs (Requested Item), you need to use the sc_req_item table in ServiceNow. This is the table where all RITMs are stored.

When creating your report:

1. Go to Reports in ServiceNow.
2. Select sc_req_item as the table.
3. You can then filter by fields such as Request Number (RITM Number), State, Assignment Group, Assigned To, or any other relevant field.

If you need to include data from the parent Requests (REQs) or associated Tasks (SCTASKs), you can reference related tables:

• Requests (REQ): sc_request table
• Catalog Tasks (SCTASK): sc_task table

Let me know if you need step-by-step guidance or help creating a specific report!

for in depth tutorials you can watch my free full training course about ServiceNow Fundamentals.