Need to create a database view based on Incident table and Metric instance created on Incident table

rog · ‎09-17-2018

HI,

I have a requirement to create a database view based on Incident table and Metric instance created on Incident table. The metric instance is based on the state field on the incident table.

So basically I need to create a database view report to get all the fields from incident table like assignment group, assigned to, opened etc and also the state change details from the metric report.

Please let me know how to create a database view for the same.

Thanks in advance.

Akash4 · ‎09-18-2018

Yes we can, and for that as well we have an OOB database view - just type in '*incident' with which you can filter out them.

Hopefully, ServiceNow made it easy from their OOB options

Regards, Akash
If my response proves useful, please mark it "Accept as Solution" and "Helpful". This action benefits both the community and me.

View solution in original post

Akash4 · ‎09-17-2018

Hello,

You can try an OOB DB view - "incident_metric - description: Join incident to metric definition to metric instance creating a view that can be reported on for things like: Incidents that were resolved on the first call by category" which may help you here.

https://<instance>.service-now.com/sys_db_view_list.do

Regards, Akash

Regards, Akash
If my response proves useful, please mark it "Accept as Solution" and "Helpful". This action benefits both the community and me.

rog · ‎09-18-2018

Thanks for the reply. Is there any way where in we can club the SLA details in the same database view as well?

BeBold · ‎09-18-2018

What SLA details you want to include?

rog · ‎09-18-2018

Like in the breach time, elapsed percentage etc.