mrxinu

You're very welcome - it's what makes me happy. =) Happy New Year to you as well - be safe!

That would be the cleanest way to do it if that's an option. There's an APM component called "SQL User Experience" - you give it the credentials to the database (a user with sufficient permissions to run that query) and the return is the statistic.

Acknowledged is a Boolean (true/false) field so checking for 0 isn't going to work. Try this instead: SELECT Nodes.Caption AS NodeName ,Interfaces.Caption AS InterfaceName ,Alerts.Acknowledged ,Alerts.AcknowledgedDateTime ,Alerts.TriggeredDateTime FROM Orion.Nodes AS Nodes JOIN Orion.NPM.Interfaces AS Interfaces ON…

That is a problem. I thought you said that the error below came from the server you were having an issue with. Hopefully something pans out - let me know what you figure out. Get-WmiObject : The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

Absolutely. Let me know and we'll keep moving with it.

Try this: SELECT Nodes.Caption AS NodeName ,Interfaces.Caption AS InterfaceName ,Alerts.Acknowledged ,Alerts.AcknowledgedDateTime ,Alerts.TriggeredDateTime FROM Orion.Nodes AS Nodes JOIN Orion.NPM.Interfaces AS Interfaces ON Nodes.NodeID = Interfaces.NodeID JOIN Orion.AlertObjects AS Objects ON Objects.RelatedNodeID =…

Now you have a test you can run repeatedly until the problem goes away. What's different between the server that works and the one that doesn't? Its location in the network? Firewalls in between or on the server itself? Versions of Windows? Missing services? DCOM, as I understand it, uses a random port for part of its…

Did changing the $ErrorActionPreference yield different results?

Here's my first swing at it - since the outage is already being presented in minutes I went to hours & minutes with it: Here's the adjusted SQL: SELECT tbl.VendorIcon, tbl.Caption, tbl.StatusLED, tbl.NodeID, (tbl.SumOutageDurationInMinutes / 60) AS Hours, (tbl.SumOutageDurationInMinutes - ((tbl.SumOutageDurationInMinutes /…

Jonathan Angliss remains one of my very favorite thwackers ever.

That's definitely going to be the smoothest route. You can set up a discovery, run it, and then have access to the DiscoveredNodes and DiscoveredInterfaces entities.

Is that HTML what you're matching? The distance between "secondaryScilearnInputQueue on localhost ==>" and "86%" is more than what you're allowing for. I need to crash out for the night but if you're still having this problem in the morning, let me know and we can fire up a gotomeeting or something. Shoot me an email -…

Until the API has some method of discovering volumes directly (like the DiscoverInterfacesOnNode verb) you have a couple options: * Go and harvest all the details required for the properties to create a new volume. * Create a discovery with the node(s) you want to add (it runs as soon as they're created) and then sift…

Where do you set the ${Node.Contact_Email} property? SolarWinds Orion > Grouping and Access Control > Custom Property Editor. Create a node property of type 'text' with a large size (e.g., 255) and then populate it with space delimited email addresses (support@example.com,engineering@example.com). Sorry byrona - your…

What additional attributes do you want to add?

I have polled several things and daisy-chained one result to the next, but it's not trivial, ends up in a report instead of an alert, and requires some SQL savvy. It's easier to use the enumeration.

Hey, quick question - the rest of the class that goes with that script is concerned with getting the volume information ahead of time so they can be added. Where did you plan on getting that information? Do you have all those bits of volume information somewhere? Another SolarWinds instance for example?

Paste the whole script.

Hey dvanzyl​ - I can't tell at what point in the thread you got involved so I'm not sure if this is a silly question or not, but when you're adding a node are you also adding pollers for the node? The interfaces get added with a default set of pollers so that would explain why those go immediately green if not your nodes.…

Not at all - you'd have gotten an error about '<' being reserved for future use if you had. Now try the same thing against one of the systems that is working.

Well darnit. zackm​! ChrystalT​! What's going on with this guy's installation?

Interfaces don't go down when the node goes down. They go into unknown. If your interface alert is looking for down, it shouldn't be an issue.

Okay, taking another stab at this. If this doesn't help or move us forward I propose we hop on a GoToMeeting session over the weekend and discuss it real-time. I'm determined to help you fix this!

Definitely. Let me square away my client for the day and I'll get something posted.

Right. That's what I was suggesting. See the screenshots posted above for an example. You're assuming I read everything before I post. Madness! That'd just be madness.

It's running now. 1. Please join my meeting. www2.gotomeeting.com/.../662861890 2. Use your microphone and speakers (VoIP) - a headset is recommended. Or, call in using your telephone. Dial +1 (510) 443-0602 Access Code: 662-861-890 Audio PIN: Shown after joining the meeting Meeting ID: 662-861-890 GoToMeeting Online…

mulder85​ That's the beauty of having it out on GitHub. We can contribute all this tasty information we're accumulating.

Good call. Make sure you're using a custom property to identify the critical devices. For that matter, make sure you're using one for the email address. Not many folks know that you can drop ${Node.Contact_Email} in the To: field to make it dynamic.

It's \d, not /d.

Ditto to what asked. Minimum WAN speed?