Reporting on 4 tables

[mregragui_ext]

Hi everyone can somone please help me with this:

i want to create a report on (incident, probleme, change and RITM) and see the resolved one how can report on 4 tables at the same time ?

[Hemanth M1 · Accepted solution]

HI @mregragui_ext ,

Report on task table (these tables are extended from task anyways ), make sure you apply proper condition to get desrired out (example: RITMs does not have resolved , may be you should closed complete)

Referance report : 

[Riya Verma]

Hi @mregragui_ext ,

Hope you are doing great.

To create a report on multiple tables (incident, problem, change, and RITM) and view the resolved items, we can achieve this using ServiceNow's Reporting module. We will create a new report that combines data from these four tables.

1. Navigate to the "Reports" module in ServiceNow.
2. Click on "Create New" to start building a new report.
3. Select "New" from the "Standard Report" section.
4. Provide a meaningful name and description for the report, e.g., "Resolved IT Items Report."
5. In the "Data" tab, select "Multiple Tables" as the source.
6. Choose the four required tables (incident, problem, change, and RITM) from the list of available tables.
7. Link these tables using relevant relationships. For instance, you may want to link incidents with RITMs, problems with incidents, and so on, depending on your requirements.
8. In the "Filter" tab, apply filters to display only resolved items. You can use a "Resolution" field or a similar status field specific to each table to filter the resolved items.
9. Configure the "Columns" tab to display the desired fields from each table in the report.
10. Use the "Preview" option to check the report's data and layout before saving.