The most recent content from our members.
I have been struggling to find a way to alert on Application status, but provide Component status in the alert e-mail. I know that there are several macros that give me some of this information (ComponentsWithProblems, etc), but that is not enough. I want the error message associated with each component. I found the field…
Hi folks, I am trying to build a SQL Variable in Advanced Alerts that will list the first three characters of a string/line. What i'm trying to achieve is having a disk label C:\, D: \ or E:\ be displayed in the alert message, instead of Volume ID, serial and what not. A Volume Variable according to the administrator guide…
Hi there, can anyone assist me? I am trying to set up an Alert within Solarwinds advanced alert tool to monitor servers and alarm me by mail when capacity has reached 90%. the only thing is i cant understand how to do this as the value setting under trigger conditions does not allow a % - only a numerical figure (which i…
Hello, is ist possible to use custom SQL variables in the To: field of an e-mail action? For example: ${SQL:Select dbo.getAppAlertMail(${Node.NodeID},${ID})} Perhaps there is a problem with the colon in the SQL variable definition (${SQL:). In the field "Target" within the table "ActionDefinitions" a colon seems to be used…
I'm trying to set up an advanced alert to trigger when a node is added or removed from Orion. I've gotten the custom sql query correct Select Message, EventTime From Events Where (EventTime BETWEEN 40917 AND 40924.625) and (Message like 'removed%' or Message like 'added%') But, I can't seem to get the variables correct for…
Hi I'm currently working on re-vamping my company's alerting and am in the process of creating an alert on the WAN response time using the following custom SQL statement: WHERE ( (Nodes.ResponseTime > ((Nodes.AvgResponseTime * 2) + 1)) AND ( (Nodes.SysName LIKE '%rtr%')) ) I had previously been using the following in a…
Hello everybody, Can someone say me what tables on the orion NPM database are need to verify boundaries and send alert about traffic (receive and send), response time, packet loss. Please I want this information as soon as you can send it me. It is very important for me for Monday (tomorow). I hope, you will help me soon.…
Can the SQL variables used in alerts be used to run an UPDATE query? I've been attempting to set up an alert that posts a message to the NPM Event Log and runs an UPDATE query to change the value of a custom property and it's not working. The query seems correct, as I can run it in Enterprise Manager. I have a custom…
Help, I need to build an advanced SQL query report on a custom poller and I have no clue about sql queries. I have a custom poller for OID 1.3.6.1.4.1.9.9.23.1.2.1.1.6. It is pulling the CDP neighbors table, and it is working great. I now have a need to run a report that will list each host device and in a seperate column…
I have an alert that is triggered when response time of my routers are greater than 400ms. In the email that I receive, I would like to be able to report a few different items and I am not sure how to do so. I would like the email to look like this: Node ${NodeName} ${IP_Address} has an average response time of…
It looks like you're new here. Sign in or register to get started.