Incident priority upgraded report
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 weeks ago
Hi … I’m trying to create a report that shows only those incidents which were upgraded to Priority 3 (P3) from P4 or P5, and the upgrade happened yesterday.
I’m using the metric_incident DB view to track priority changes. Used below conditions
- The incident creation time differs from the metric record creation time and priority change on previous day.
- My current query brings in all P3 incidents, including those degraded from P2 to P3 — but I want to exclude those and include only upgrades from P4 or P5. Has anyone tackled this before? How can I accurately filter the dataset to show only the incidents upgraded to P3 from P4/P5 on the previous day?
Thanks in advance!
0 REPLIES 0