SQL Query help

rmurphy1313

Hi everyone,

I am looking for SQL query help.  I have been tasked with getting a report (somehow) on our devices we monitor

Management wants to know:

what is being monitored on each device/interface

I have 15000 devices in my environment

I know we monitor the following:

Node - up/down status

Interface - up/down status

Applications

Components

Email - notifications

but is there a way to get a list of the nodes - what alarms are actually being monitored on each node

same for interfaces, applications, components

jeilers

I can see there is a report to get each alert per node but not sure how I can get it for all nodes. In reports you should see built in "All Alerts this Object can trigger". Not sure how to get it to work for all nodes or if that is even possible. I do think a report like this could be useful.

EDIT: I found this thread that is probably more useful than I am. GENERATE A REPORT WHICH TELLS YOU NODE AND ALERT(NAME AND MESSAGE) CONFIGURED FOR ALL NODE : NOTE REPORT SHOULD NOT INCL…