AlexSoul · The Magician! · ✭✭✭✭✭

Well, yes, this will work, but I need to be able to define HTML tags within SQL value, not outside of it.

Yes, you can use Node as your base object and simply JOIN traps in SQL query (see below): copy-paste below for convenience: JOIN Traps t ON t.Hostname = Nodes.Caption WHERE t.Hostname IN ('Router1','Router2') AND t.TrapType = 'BGP4-MIB:bgpTraps.0.2' AND t.DateTime > DATEADD (minute, -2, Sysdatetime()) Note: This will work…

Hi Manu, Ah, sorry, screenshot above is from SAM. I don't have DPA here, but if alerts are routed via Advance Alerting you can still use delay option on a trigger tab

OK, this is good, you are pretty much on latest version. There are two options to consider: (1) Build report in GUI * Hover over HOME tabe, then click on Reports. From there, got to Manage Reports > Create New Report * Select Custom Table > Select & Continue * I want to report on Alert Object (now, logically I would pick…

aLTeReGo​ I would dare to disagree ... Creating a separate alert for just this one disk is hugely inefficient. This is just one example - Tomorrow pat_m will need need another disk to trigger at 12TB, and then next Monday yet another disk to trigger at 10GB ... Are we talking about creating new alerts all the time this…

I am afraid this is not the case. I have added "Windows Scheduled Task" as a resource on Node page and I have enabled it through "List Resources" on a particular node. The trouble is - this resource does not appear on node page and when I go back to List Resources - Windows Scheduled Task stays un-ticked ( as if when I…

just for the record - you do not need to have MIB in database to be able to poll over SNMP

6 years old - that's' like Forever in SolarWinds terms... what was it back then... NPM 10.x?

I will need to prepare separate article for this as I believe this will be very valuable for others as well. Give me few days, I will publish it here:The Magic Of SQL Scripts: Do What Counts, Don't Count What You Do

Please post a separate thread as a question and explain in details what you need. Please also pay particular attention into WHY you are doing this - request from boss, some other particular need, etc. Pretty much anything can be done in multiple different ways - knowing what you are trying to solve will help. Besides...…

lol you can always chop-chop-chop

Yes, I do. I have reports designed in Report Writer which will lookup for Site ID in my Auxiliary table and will then output all address details on Node's page dynamically. This is shown in bonus section here

* you have typo in your first URL - should be double "ss" * use <a></a> html tags to make your url readable. For example: <a href="${N=Alerting;M=AcknowledgeUrl}">This is much more readable acknowledge URL</a>

Good, you now have to dig-in and understand what is inside your txt file. To help you with this you need MIB for your device (which you can most likely obtain from manufacture). Open it up with any text editor and just look for Objects IDs (OIDs) which you would like to monitor. Once you identify them - you can proceed…

Thanks njoylif and Vinay BY, This is interesting way of approaching it. In my environment I have a bunch of alerts enabled and some of them disabled, but they are still present in the list of alerts. By running the above SQL query - how do I keep track of which alerts have been enabled before I have disabled them? ... I…

No problem, nobody offended here Check All Services Which Set To Automatic Mode Are Running

My Friend, it sound that this is exact question you need to answer yourself. If you want to alert on all errors - this is what you have done. If you are not happy with the amount of errors that you receive and you want to filter only those that you want to receive - I guess you are the only one who can really answer this…

Hi Joshua, It looks like in my environment it picks up all VMs as well. I have checked VIM_VirtualMachines table and it is empty (I am on NPM 11.5) - that's why I guess. What did you mean by "IVIM module is set up correctly"?

Not yet my friend... but thanks for bumping it up!

... just on the same subject, we also do additional checks to identify these sort of issues: Watch The Watcher... Or Self-Monitoring For MSMQs

Have you ever found a way to hack this to display custom property on the node tooltip?

Yep, thanks aLTeReGo‌, this is exactly what we do as well. We monitor overall CPU > we wait 30 minutes for the condition of high CPU to sustain > we then trigger execution of the program which extracts processes info > we then send email to Infra with all this information In your trigger action step do this: 1. Execute…

Hi Danielle, I have actually figured it out: PRODUCT FORUMS > {PICK PRODUCT} > CONTENT EXCHANGE > DOCUMENTS Thanks, Alex

When you configure Alert for your CPU, at the TRIGGER CONDITION TAB you have an option to delay - it is what you have mentioned as "Condition must exist for more than XX minutes". Set it to 30 for CPU and leave 5 minutes polling - this will also keep Database smaller. Or you can shrink it to 2 minutes CPU polling and 15…

Sorry, I haven't done it myself before, maybe someone else will advise better... ... but please do take a look at web-based interface for building reports. When you click on "NEW REPORT" the first radio-button choice you will see is between CUSTOM CHART and CUSTOM TABLE. I would pick CUSTOM CHART in your case and just play…

OK, I am answering first part of my own question. Below - is how to trigger an alert when value of the custom property changes. The other question still remains: How do I clear off alert straight away as soon as it has been triggered?

What information you would like to see on CPU/MEM/Disk? Current usage? Think about table (like excel spreadsheet). What column will you have there? If you want to stick all the above into one report with one set of columns, then some of those columns will not be applicable for all records, such as [disk space usage] for…

Thanks Joe for your help on this. I have actually found a native way of achieving what I wanted. In my DB value is stored in seconds and I needed to display them in milliseconds. Well, using Data Unit I can do exactly that. I have set units to display in ms and values stored in DB as seconds - that did exactly what I…

Also check this: SAM 6.0 Beta 3 - Introducing AppInsight for SQL