REPORTING: How to create a report from multiple tables?

[Shawn Horley]

I've been asked how staff (Team Leads) can create reports that show all the work they have done. They are needing a report that includes Incidents, Change Tasks, Problem Tasks and SCTasks(Service Catalog Requests)

I've looked at some previous questions similar to this on the site, but I've not found an answer that shows me how to accomplish this.

Any ides folks?

Cheers

A.

[Phil32 · Accepted solution]

Last time we tried to do this, it ended up being the TASK table you reported on.  All of the ITIL sections interface with the TASK table.

[Shawn Horley]

Greetings Philipscherry.

Thank you for the response! It gave me what I needed!

Cheers

A.

[Karthik Reddy T]

Please use the table task for reporting or else if you want to take report of multiple tables use database views.

https://docs.servicenow.com/bundle/jakarta-performance-analytics-and-reporting/page/use/reporting/concept/c_DatabaseViews.html

[Shawn Horley]

Greetings Karthik

Thank you for your response. That advice was very helpful!

Cheers

A.