combined catalog tasks and incidents

[raymond jones1]

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

[dmathur09]

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 · Accepted solution]

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!

[raymond jones1]

Hi,

I used the Task table and that works.

[Sayali_9822]

can you tell me backend name of task table?

There are alot task tables right?