cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

Need help with a query to retrieve SW alert details, node and interface details

Hi Team,

 

I'm new to running sql queries.I would like to write a SQL query that shows you all of the active alerts with alert message,severity,ObjectType,ObjectName . If it is a Node,then I need to have the following info

- Node IP Address

- Node Name

- Node Status

- Severity

and  if it is an Interface

 

- Interface Name

- Status

- Severity

 

I really appreciate any help you can provide.

thank you

0 Kudos
0 Replies