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

[rog]

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.

[Adam Stout]

If you joined metrics to incidents and SLAs you would have to make sure you only get one SLA since this would create lots of records that looked like metrics.

[Akash4 · Accepted solution]

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

[rog]

Thanks for the reply.

The requirement here is that we need to join the metric to incident and SLA. So that we have the details about state change, and also details of SLA like breach time, has breached etc.

[Adam Stout]

You can create a new join, but be very careful as if you pick more than one SLA or metric to look at, you'll see duplicates which you'll need to handle.

[Jon Perkis]

God Bless YOU!!! 🙂 It's what i need 🙂 i tried to find it like 2 mounth and i get it 😛 Thank you