Sentinel: Filter Incidents by responsible user

  • 3811358
  • 06-Dec-2006
  • 26-Apr-2012

Environment

Microsoft Windows Server 2003 Standard Edition
Microsoft Windows 2000 Server
RedHat Linux
Solaris 9

Situation

How can I filter incidents by responsible user?

Resolution

Currently, there is no easy way to group by person responsible in the Sentinel Control Center. This can only performed via SQL command.

select users.name, incidents.*
from incidents, associations, users
where associations.table1='INCIDENTS' and associations.table2='USERS'
and incidents.inc_id = associations.id1
and users.usr_id=associations.id2
order by users.name