AlexSoul · The Magician! · ✭✭✭✭✭

We are awakening sleeping dragon Gentlemen. Orion is a platform, not a tool. What it means is that you can shape and mould workflow and presentation of alerts the way you want it. It does allow you to write your own custom queries, custom reports, engage SDK, add automation and do millions other exciting things to adopt it…

Hey Rob, nice to hear from you my friend Unfortunately I haven't been able to crack this one yet... I believe there is some kind of new way of getting this done in the latest edition, but I didn't explore this area yet.

Hmm, interesting, I will dig a little bit... What I have notice (need some more tests however) if node is ICMP only Rediscovery process will not try to update "MachineType" field in Node table, therefore we can directly modify this field in SQL and use separate view just for this particular MachineType. Unfortunately this…

Wow, this is exactly what I need, thank you. Would you be able to give a bit more details on how to set this up?

Hi k1gaudineer, I am have exactly same requirement. Did you ever find a solution to it?

Hi sean.martinez‌ Thank you for your reply. I have no intentions to modify anything directly in any SQL tables, however, I am looking to report on those interfaces that either do not have this checkbox at all or do not have it ticked. So, I need a way of querying SQL for this info (without modifying anything). Would you…

On your last point - it depends on "Zoom" level. You can try to display 2 million elements on one screen - it will no doubt fail to load. However, if you group them together - this will take much faster to load. If you then group those groups .... yee, you may end up with just one object - not a biggie to load I guess.…

Basically, what you are saying in the above filter is: "Hey, Mr. SolarWinds, would you please show me Volume Utilisation if EITHER Node Name not one of those I have listed OR Volume Type is not RAM. And, yes, only show me top 10 of them . Thank You" Here is a follow-up question for you my friend: What will happen if on…

no, no, don't be scared... be excited. These queries allow you to build your environment the way YOU want it Here is a few examples: Filter out some nodes by name: NodesData.Caption NOT IN ('Server1','Server2','Server3') Filter out some nodes by ID (you can get ID from the Node's URL): Volumes.NodeID NOT IN ('1','2','3')…

here is similar script for SysLog COUNT if anyone finds it useful

after initial few tests it looks like this is working. I will need to run it longer to see if this indeed is picking up all of them. To save others typing - copy-paste same SQL script below: SELECT n.Caption ,n.IP_Address ,n.MachineType ,h.HostName ,h.VMwareProductName AS 'Host Type' ,h.VMwareProductVersion AS 'Host…

also, I do not have [ComponentStatisticData] nor [ErrorMessage] fields in Orion.APM.CurrentStatistics table:

Hi lukas.belza, Unfortunately this didn't work. Yes, I do need data which is being produced by VBScript (both message and statistic) for a given component. Would oyu please be able to point me to the right direction where do I dig for this data. I really need this to setup regardless of complexity Thank you, Alex

Thanks Rob, I really appreciate your help to understand this. So, it will take 20 min for PacketLoss to become 0 again, after node has been Down and came back Up... Thanks for confirming this I am not quite clear though on SELECT statement. So, what you are saying is that it is impossible to do the same thing in Advance…

Hi aLTeReGo and thank you for your reply. Ah, ok, I get this - 1 ICMP ping every polling interval (2 minutes in my case) Would you be able to help with understanding over what interval does the average is being calculated and how can I configure this value (if possible). You gave and example of 4 minutes above... where is…

Wow, this is cool. Just bumped into this post while trying to alert on Unmanaged nodes. I am trying to setup few alerts for unmanaged objects and trigger an email. Obviously because object is unmanaged - email doesn't get's through. I was just wondering if there is a way to fire actions (such as sending email for example)…

Thanks Rob

aLTeReGo​ quick question if I may: If I will run the following script, which is part of app stack migration to new host, will it potentially stop original app host from messing up with the data should it come back to live? DECLARE @oldHostname nvarchar(max) SET @oldHostname = 'OLDHOST' DECLARE @newHostname nvarchar(max)…

Awesome, thanks Alterego, this just confirms my gut feeling that we should be super cautious here with our DR test runs

bang on!

dhanson‌ 1. Solution: Automatic Dependencies Based On Custom Properties (Node Location) 2. +1 vote from me on the idea, although I am already triggering actions dynamically (sending emails to the right team) based on custom properties with the help of SQL macros in TO/CC fields 3. I agree, although this does not answers…

I have just published a report, which we use to trigger problem records. Report is an awesome stuff and will highlight issues immediately. With a bit of tweaking (I can help if needed) you can use same principle (based on same SQL query) to fire problem record. Have a a look: Repetitive Email Alerts (Noise) - MUST HAVE…

This SQL script will not track nodes, it will track alerts instead. Basically, it will give you all your alerts and number of time they have been triggered - you can then decide yourself how many triggers and in what time window means PROBLEM for you. Because it will only track alerts themselves, not condition - this will…

As far as I know SolarWinds has two ways of monitoring DBs - one is with SQL AppInsight (which requires 50 licenses of SAM per instance) and another one is more deeper and dedicated products DPA (interestingly you have also mentioned it as well) I guess if you give your DBAs below links to play with - they will get an idea…

You can ... easily! You just need to create report for it with any columns you wish and then export the result of the report output into Excel/CSV. You can start with default "Inventory Report" to get your initial base line and fine-tune it to your liking

what is this "copy-paste" stuff from? scom? why would you do that? are you working for marketing department at Microsoft? If I will copy-paste everything SolarWinds can - you would not have enough RAM to load on your desktop... At a quick glance - all this CAN be monitored using custom apps and templates.

sort of... this is what I have received from SolarWinds support: ------------------------------ Hi Alex, We changed the way how to create tge gauges for specific components. I collected information how to add the gauge on the Summary page. Steps: - Customize page - Click the + - Add Custom Object Resource click Add Seleted…

Just cheaping in... I generally aim at 100% polling rate, with 99.9% being acceptable and anything below requires furher investigation into why we are not at 100%. 95% rate is way below my (personal) acceptable criteria

mattoz, thank you for the clue. I have found the below PDF guide, which is explaining this solution in more details, specificity for Orion Database http://www.lifeboatdistribution.com/Content/images/promotions/solarwinds/NF-for-Orion-Database-Solutions-Sheet-v2e.pdf

This is great, thanks Rob... we are getting there. I haven't heard about FoE before and by the first look of it - it seems exactly what I was looking for