Dashboard Incident - Asset action swap, retire, update/repair
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2024 07:47 AM
Hi,
Can you please advice how to build dashboard/report for incident asset action swap, retire, update/repair?
Does anyone of you create similar report?
Thanks/
Regards
Dama
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-07-2024 01:09 PM
If all you are looking to do is to see if the affected CI's of an incident were either swapped, retired, updated/repaired, or 'no action' then that is simple enough to do by building a report on the task_ci table. Build it on task_ci, and filter it on the Task field to only show records that start with INC (incident records). From there you can dot walk into the Task record (Incident) to grab more data as you need. You can then group by different asset actions and spruce it up as desired.