Forum Stats

  • 3,727,169 Users
  • 2,245,331 Discussions
  • 7,852,618 Comments

Discussions

OEM - Repository view for severity states

Prasanna Bekal
Prasanna Bekal Member Posts: 1 Blue Ribbon
edited August 2020 in Enterprise Manager

Is there a repository view or table to find the different SEVERITY states for OEM.  I am not able to find a comprehensive list of all the severity states in the documentation.

example Severity

Fatal

Critical

Clear

Advisory

Warning

Answers

  • Nishant Baurai
    Nishant Baurai Member Posts: 215
    edited August 2020

    Hello Prasanna,

    You can query MGMT$INCIDENTS for severity states.

    select distinct severity from MGMT$INCIDENTS;

    select I.SEVERITY, count(*)  from  MGMT$INCIDENTS I

    group by I.SEVERITY;

    Thanks,

    Nishant

Sign In or Register to comment.