AlexSoul · The Magician! · ✭✭✭✭✭

Case # 604600

[ANSWERED] Found It! Detroiter has offered an absolutely freaking rocking solution here: Application custom properties in advanced alerts works beautifully well together with axillary node property (see below). Here is my final variable to use in CC field: ${SQL${Node.n_x_cln}Select a_ealert_cc FROM…

ye, we have ~40 sites across the globe... should be able to find something. But what happens if for whatever reason latency goes above 250ms? Will poller stop polling? If yes, for how long? Will it start caching? ... WAN is never predictable thing and can fluctuate occasionally if any ISPs in between are messing around

Crazy... I just checked my Interfaces table and I found one with "InterfaceLastChange" date in the future. I guess this is a BUG and probably needs to be picked up by SW Product Team

exactly - I am yet to see the environment where every device is SNMP and on every SNMP device you have correct location field. In my view this is next to impossible to achieve. Therefore - default automation feature is good enough, but the one I am proposing will fit any environment Just give it a go - takes few hours to…

I have been using VBScript to monitor "Automatic" service with no problems. You may want to check this out. Might need to be adjusted to automatically restart services, as we do not do this in case service was stopped for a reason

O, wow, this is super cool, thanks a lot for sharing. I was just wondering what resource do you use to feed this script into?

post scriptum: I personally do not rely on the above values when I need to work on devices by type, for the reasons stated above. I have a special Custom Property which I call "Type". It has the following values: * Virtual Server * Physical Server * Virtual Appliance * Physical Appliance * Network Device * Chasses * UPS…

Valid concern and I can assure you that all your drop down values will be lost and you will need to re-type them all again at the time you re-enable this option. (values assigned to nodes will remain though) ... I just want to re-iterate that I am very reluctant to guide you with this approach as it feels not right... you…

I guess you are talking about your deployment doc (HLD/LLD) over 50 pages. My LLD spanned couple hundreds. What I am referring here is a step by step process of swinging from LIVE to DR site (failover runbook). To me, 5 pages for this doc is very long, with some manual DB tables cleanups, etc. I will publish it here later…

you don't need SQL query. See my post below...

It is not latest either. Latest platform is 2015.something, latest NPM is 11.5.2

OK, thanks aLTeReGo, I have published it in Feature Request forum for SAM: http://thwack.solarwinds.com/ideas/3140

Unfortunately cut-&-paste is not an option - it is not scalable, it is a dirty workaround and there is no way to ensure consistency. Besides, this is just tip of the iceberg of what I want to implement and without this tip there is no iceberg... With Advanced Alerts I use the following in footer: This alert was generated…

I have noticed this behaviour across multiple different SQL servers, where random databases would gone missing. Might be something odd in our environment. Opening case now and will update shortly...

Uups... that might be me who have changed it then ... glad to hear it worked

Now, this is dated back to 2012... 3 years forward - can anyone answer this question now?

I actually agree with you. It is doable and it does the job, but to be able to easily schedule periodic maintenance on the front end and be able to see all schedules and affected objects in one place would be an awesome addition

Hi aLTeReGo, I am glad you have asked this question, because I have a "story" to tell I truly believe that Dynamic Query Feature is Freaking Rock! and it makes SolarWinds much more fun to work with. I think it is brilliant idea to have groups populated dynamically based on certain rule. Thank You! However... certain things…

Johnny, bang on! I was actually under impression that this was already standardised across all resources - hence my assumption that this might be a bug. Well, seems it is not. +1 from me on your feature request

wow, thanks for this tip. Would you mind expanding a bit what exactly this going to change?

ok, I just had a quick check and it may not be possible with report builder. You may need to use SQL/SWQL query instead. Are you comfortable with script? I can give you a SQL script example that will do the job, but you would need to expand it further to include all the rest stuff and custom properties that you need

I advise you to go to Message Center first and understand which exact events you want to output into report. Alerts, Audit Events and Events (such as Node Down) are 3 different things and they are stored in different places in DB. There are many thousands of those in typical database (if not millions in some cases) and I…

That's great, thanks Richard. Would you help to link Orion.AlertHistory to SQL Table? Where in SQL these records are stored

Here it is:

Nice one, glad you found it useful Here is another BONUS TIP #2 To be able to display links and status icon - you can use the following display types on both NODE and INTERFACE columns: * Details Page Link + Enable tooltips * Status Icon (Watermark) plus, you can also add custom properties from node level as well and even…

Yohohoooo this is very very great answer - not something you would expect from licensing question. aLTeReGo - you made my day. SolarWinds as usually - ROCK!

nice one... this is how I would like it to see: P.S. Found it on internet... printed and posted on my vision board ... i_like_eggs will appreciate

OK, I will publish a post in the beginning of next week.. off to Wembley for England vs Peru friendly game

If you need an easy and generic solution - Storage Manager is the best way to go: http://www.solarwinds.com/storage-manager.aspx? If you want to monitor your SAN via SAM - then SNMP monitor will do this, however you will need to build a template, which will monitor a specific OID, which in turn will depends on hardware…