Dashboard Incident - Asset action swap, retire, update/repair

DanMa
Tera Contributor

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

1 REPLY 1

ericward
Mega Guru

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.