Creating a Report for List Request Item (RITM or your tasks) for Catalogs "TIC Internal Services"

hernani
Tera Contributor

‎11-14-2024 05:12 PM

Hi guys,

 

Sorry for the basic question, but I would like to know how to create a ticket report that lists the open tickets and the catalog they belong to:

 

image.png

 

I have already tried using the TASK table, but with no success...

 

I appreciate any help.

0 Helpfuls
  • 464 Views
2 REPLIES 2

Community Alums
Not applicable

‎11-14-2024 08:44 PM

HI @hernani ,

You can use "sc_req_item" table at RITM level :

SandeepDutta_0-1731645508832.png

At SCTASK leve, you can use "sc_task" table:

SandeepDutta_1-1731645849560.png

 

0 Helpfuls

hernani
Tera Contributor
In response to Community Alums

‎11-17-2024 02:05 PM

Hi @Community Alums 

 

I tried with both tables (sc_req_item and sc_task) but without success!

I get all the tickets, but I would like to obtain only those that meet the criteria of being listed in the Catalog table (sc_catalog) with 'TIC Internal Services'.

 

My objective is: just report tickets where the Catalog field displays 'TIC Internal Services'

0 Helpfuls