Reports

[Anantha27]

I need to create a report that combines data from the Incident and Problem tables. Is this possible...?

[Pradeep Thipani]

Hi @Anantha27 ,

To achieve that you can use DataBase views under system definition.

• Create a database view by specifying the link between the tables to create a virtual table. The default behavior is to show only the results where both of these items have values (e.g. incident_problem_id = problem_sys_id). A left join causes the view to include all Incident records, even those that do not have an associated problem record.

Reference documents:

https://docs.servicenow.com/bundle/vancouver-application-development/page/use/reporting/concept/c_Da...

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0952022

Regards,

Pradeep

[Ramesh Poola]

Hi Anantha,

Please try to create a report on Task table and try to get Incident and Problem records and apply the filter conditions accordingly. 

Regards,
Ramesh

[VishaalRanS · Accepted solution]

Hi @Anantha27 

Yes, it is possible to create a report in ServiceNow that combines data from the Incident and Problem tables. you can create a database view that combines data from both the Incident and Problem tables. This allows you to pull fields from both tables into a single report.

If you prefer not to create a database view, you can also create a report directly from the Incident table and use dot-walking to access related fields in the Problem table. However, this method may not be accessible for all users depending on their permissions.

Please go through the below link for more information:

Solved: Creating a Database View between Incident and Prob... - ServiceNow Community

Thanks, and Regards

Vishaal

Please mark this response as correct or helpful if it assisted you with your question.

[AndersBGS]

Hi @Anantha27 ,

Both incident and problem is extended from task table, hence create a report based on the task table to obtain both task types in a report. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders