how to create reports from two tables

[raviprakash]

how to create reports from two tables?

[Robert Beeman]

Hello Ravi,

Database Views are used for this purpose:

http://wiki.servicenow.com/index.php?title=Database_Views

A database view defines table joins for reporting purposes. For example, a database view can join the Incident table to the Metric Definition and Metric Instance tables. This view can be used to report on incident metrics and may include fields from any of these three tables.

[Swapnil Bhakar1 · Accepted solution]

Hi Ravi,

For create tables from two tables you need to create database views between two tables from which you needs to create reports.

Follow the below steps:-

1. Navigate System Definition->Database View-> New

2. Write Name-> Save.

3. After saving related list will appear as view tables.

4. Click New->select your first table -> Save.

5. Again Click New-> select second table-> Save.

6. Now check in reports your new table will appear which you already created a database view.

Regards,

Swapnil

[KeDix]

@Swapnil Bhakar1 

Do you think this can be used to add to the Dashboard?
Will this be a list only, or can it generate graphs like the View/Run report module in the ITSM?