Report with data from two tables (or even three)

[Bumsefar]

Hello All,

I want to create a report (list view type) with data from atleast two tables.

I want the "business time left" column from task sla table, i tried building a report based on task sla table and dotwalked to the task table, and added columns from both "task sla" "task" and "incident" table. 

The issue is that i now can't see all the tickets that has NO sla, and i need to see ALL tickets - SLA or not.

Is this even possible ? 

I am not an admin so what i can do myself is limited in terms of specific steps. 

If i build the report based on TASK table, then i don't know how to add the "business time left" column

Please help 🙂

[Sohail Khilji]

Hi @Bumsefar,

To meger 2 or more tables for the sake of reporting you would need to create a data base view in servicenow.

1.To do so > navigate to > System definition > Datavase Views.

2.click on new > to create a new database view for all the 3 tables that you need.

3. provide the name and lable for you mergerd table 

4 save the record.

5. in the related list you can add table say 2 3 4 etc... to merge them into 1. You can also filter the fields as needed and provide prefix to diffrenciate the tables...

(You can refer a predefined list of database view which are there OOTB  > Ex. change_request_sla)

I hope this helps if yes markthe answer as correct and helpful...

[Bumsefar]

Hello Sohail, 

Is there really no way to do this, without a database view ?
I first of all ask because i myself can't create such a view and getting it... is not easy in my company.

[Sohail Khilji]

The data that you are loooking for are not residing on 1 table, they are from diffrent table hence database view is the only go...

[AndersBGS]

Hi @Bumsefar ,

Nop, not without database view. 

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

best regards

Anders