SCTASK associated with RITM

[miquel2]

Hi,

I only access to Reports, and I need do a report with the status of the SCTASK associated with a RITM. I'm searching in all tables but I don't find it.

Thanks a lot.

Miquel

[Josh Cooper · Accepted solution]

Depending on your access try:

Create a report and look for the sc_task (Catalog Task) table.   Try searching with *sc_task - you may not have rights to view it depending on permissions in which case it would need to be added by one of your company's NOW admins.  

If you can get to that table, you can either add a filter for "Requested Item" "is" "(the number you want)" or add a filter for something like "Created On" "This week" (or Requested Item.Created On This Week)   and then Group by Requested Item, to get a list of all the tasks created for each Requested Item.

That should give you what you need!

[miquel2]

Thanks!!!!!