Reports

[Anantha27]

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

[Sai Krishna6147]

Hi @Anantha27 

You can get this by using database view under System Defintion

please Refer this links

Refer:

 Creating database views for reporting (servicenow.com)

Database view - How to correctly join a table using a document_id field - Support and Troubleshootin...

Please mark my answer as correct and helpful if it works for you.

Thank you

[Aditya02]

Hi @Anantha27 

You can combine data from the Incident and Problem tables using a Database View.

Here’s the process:

1. Navigate to System Definition > Database Views and create a new Database View.
2. Add both the Incident and Problem tables.
3. Set up the relationship between the two tables, such as matching common fields (e.g., caller_id, assignment_group, or opened_by).
4. Save the Database View with a unique name.

Once your Database View is set up, you can create reports based on it like any other table. If you don’t need to join the data, you could also create separate reports for both tables and add them to a dashboard.

===================================***************=========================================

"If you found my answer helpful, please give it a like and mark it as the accepted solution. It helps others find the solution more easily and supports the community!"

Thanks & Regards,

Aditya

=====================================***********==========================================

[thullurishalini]

Hi @Anantha27 

1. Create a Database View: - Go to System Definition > Database Views.
- Create a new database view, then add the Incident and Problem tables.
- Define the join requirements to properly link the tables.

2. **Create the Report**: - Navigate to Reports > Create New.
- Choose the database view you established as your data source.
- Set up the report as desired, including filters, grouping, and visualisation choices.

3. **Save and Run the Report**: Run the report to display the combined data from both tables 

Please mark my answer as correct and helpful if it works for you.

Thanks,
Shalini.
.

[Harish Bainsla]

Hi @Anantha27  yes it is possible by creating data base view . For more details ho to create check below video

https://youtu.be/syC8-0beVjQ?si=lLX5vpmI-AHI20UC