report from multiple table for the SLA and time remaining

[chandreshashah]

I am new to the SNOW, i came across one article for the report on extended tables.
https://docs.servicenow.com/bundle/vancouver-now-intelligence/page/use/reporting/task/t_AccessFieldE...

Currently i am using 4 modules of the SNOW
1) Incident
2) Change
3) Problem
4) Request

For all this 4 modules i need to know how much time is remaining for every ticket and if there is any breach of the tickets it should provide on the report.

I would also like to know how to get the table & which table contains what fields, as i have seen SLA is unknown in my SNOW.

Any help greatly appreciated.

[Dr Atul G- LNG · Accepted solution]

Hi @chandreshashah 

1st thing 1st .. it is NOT SNOW, it is SN or ServiceNow.

2nd

1) Incident
2) Change
3) Problem
4) Request

Go to the data base view and create the report (OOTB Solution available)

You these tables in Report and your work is done.

[chandreshashah]

Thank you Atul for the quick response, i have raised the request with my SN team to provide me access to the database view, will respond back once i have the details.

For further progress once i receive access will follow the attached link: https://youtu.be/vk1MYBxTSxY 

Let me know incase if you have different view.

Thank you for your support!

[Dr Atul G- LNG]

Hi @chandreshashah 

In mean time you get access, you can check DB in your PDI easily. 

Please mark my answer as solution accepted if it serve the purpose.