mrxinu

Outstanding! I'm glad it's all worked out. =)

Oh no! Of course that'd cause a problem. I can't believe I didn't catch that. Yes, change the type of property to node. =))

That's just odd. Try disabling all your other alerts and leaving one enabled? I'm thinking corruption at this point. Have you tried running the configuration wizard to have it run its sanity check against the database?

That looks good to me!

Quick follow-up. I did have to convert the return from the SWQL query into an ArrayList before it'd work, but that did it: $myArray = New-Object System.Collections.ArrayList$result | %{ $myArray.Add([int]$_) }Invoke-SwisVerb $swis Orion.Dependencies RemoveDependencies @(,$myArray) | Out-Null

Also, what did you put in the script arguments box? If it's working like the others the arguments need to be comma delimited as opposed to space delimited. SAM splits on the comma and feeds them to the interpreter as arguments under the covers. This would be interpreted as one argument: foo bar baz This would be…

Are you running this in SWQL Studio or somewhere else?

Create a node custom property called cpu_threshold and then use the complex condition to compare the current CPU consumption to the custom property for that node.

That is amazing. Thanks madhavan​! *goes through every other cmdlet to find hidden treasures*

My pleasure; I'm always learning new things. =)

I got nothing. If you're available tomorrow to do a quick GotoMeeting, shoot me a PM.

If it's returning 74 it should be returning 74 in the alert. Can you post a screenshot of the poller details page once you've clicked 'select' there?

You, sir, are a PowerShell demigod.

Boom. :micdrop:

When I tested this I produced the same results in either SWQL or SQL (remove the Orion. from the SQL version) Can you share the results from both queries as well? I'm wondering if you're only getting the same results because both produce a single row.

Hey vfrancotecel​, no the individual CPU load information is tracked on a per-node basis. The first query targets that one machine and grabs the most recent information and is able to pull the current load on each core. The odd thing is that the identically-named view in the database produces different results. Very…

Hey silverbacksays​, thanks for the quick reply! Maybe it's because you're crossing the streams, using SWQL for one aspect and SQL for the other. Were SWQL an option for embedding the details in the email message I'd definitely go that route. Unfortunately it looks like SQL is the only game in town. I've done this kind of…

Check out this thread: http://thwack.solarwinds.com/message/176458#176458

It's probably best to filter by custom property. If you have a branch custom property, for example, you could adjust your query like this: ...) AS UpTimeTablewhere outageDurationInMinutes IS NOT NULLAND Nodes.Branch = 'YourBranchNameHerre'ORDER BY Caption ASC, DownEventTime DESC

Just dovetailing on what cdh asked - once you get them grouped what do you hope to accomplish? Do you need to send email to different people depending what group the alert is in? If so, there are some dynamic ways to do that don't involved creating multiple node down alerts. More information please! =)

Thanks for the ping mesverrum​! anisah​, definitely helpful to see what you were actually sending to the API endpoint, but that error looks a lot like you did "SELECT * FROM Orion.Nodes WHERE Vendor = 'Cisco'" and SWQL doesn't support the * wildcard for SELECT statements.

Thanks for giving this thread a kick in the pants! =)

Thanks for the ping mesverrum​! Hi xtraspecialj​, the authentication you need to use with the SolarWinds API is called "basic auth". The tutorial above mentions it early on but it's just a header made up of your username and password with a colon in the middle and then base64 encoded to remove any issues with special…

How do you usually invoke this sql agent job? Can you execute if from the command line or from a vbscript? If so they you could setup an advanced alert trigger action to run your job when a node response time is greater some value. You set this up in the Advanced Alert Manager. Isn't that what I just said? Madness I tell…

+1 on migrating to the API. REST ftw.

What gourav baweja​ said, but if you're in a hurry you can call customer support (option 1) and they'll do it for you.

Excellent! I'm glad to hear it. Make sure you come back to this thread and click the big green 'Mark as Answer' button so other folks can find the solution later! -- Steven W. Klassen Programmer Analyst @ Loop1 Systems http://www.loop1systems.com/ http://www.linkedin.com/in/mrxinu

That's one of the nice things about SWQL - most of the entities (i.e., Orion.VIM.Hosts) also come with "linking" properties that can be used to reach into neighboring entities for their related information. SELECT v.HostID, v.HostName, v.Node.IPAddress, v.VMwareProductName, v.VMwareProductVersion FROM Orion.VIM.Hosts v In…

Sorry, I should have been more specific. That's a SWQL (SolarWinds Query Language) query. You can use it in reports, custom query resources, and advanced alert trigger/reset conditions. So in your case you'll want to create a Custom Table report of type SWQL and paste that query in. -- Steven W. Klassen Programmer Analyst…

I dig it, man. Very cool.