combined catalog tasks and incidents

raymond jones1
Tera Contributor

How do I combine catalog tasks with incidents in a single report?  Can it be done?

1 ACCEPTED SOLUTION

Allen Andreas
Administrator
Administrator

Hi,

You can create a report on the "Task" table and then filter for task type = incident OR task type = catalog task. There's no need to create a database view, etc.

Please mark reply as Helpful/Correct, if applicable. Thanks!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

View solution in original post

4 REPLIES 4

dmathur09
Kilo Sage
Kilo Sage

Hi Raymond,

It can be possible with a database view. https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/use/reporting/concept/c_DatabaseViews.html

Make sure you have a common junction condition connecting incident with catalog task.

Regards,

Deepankar Mathur

Allen Andreas
Administrator
Administrator

Hi,

You can create a report on the "Task" table and then filter for task type = incident OR task type = catalog task. There's no need to create a database view, etc.

Please mark reply as Helpful/Correct, if applicable. Thanks!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Hi,

I used the Task table and that works.

can you tell me backend name of task table?

There are alot task tables right?