Given a list of nodes, is there a sql/swql query that will show everything that is in critical status for those nodes,

alexl.charter

that would cover application, component, node and interface? Was wanting to use that possibly as the trigger condition for an alert.

thanks!

i_like_eggs

I  would recommend create alerts individualy, so for:

-nodes

-interfaces

-volumes

-applications

i could be wrong but take a look at the attached guide im sure you will find what you are looking for

http://www.solarwinds.com/documentation/apm/docs/SAMAdminGuide.pdf

Page 877