mrxinu

So is it not working then? What response are you getting from the POST?

That's right! I totally remember now. I gave a mini CCNA primer with IP addressing and all that. Small world. Let me know how you get on with that and I'll have another look as soon as I get done with this PowerShell I'm writing this morning. -- Steven W. Klassen Programmer Analyst @ Loop1 Systems…

Nice! Make sure you flag her reply as the answer. =)

You are most welcome.

Outstanding! The next thing to learn is how to format your thwack content. When you're in the editor, click the 'Used advanced editor' link in the upper right: Once you're in there, paste your query like so: And then highlight it and choose SQL from the from the syntax highlighting menu: And voila - it's formatted! SELECT…

Ah, I see what you're saying. The workaround you're using sounds like the way you need to go. Maybe post the scenario in the feature request section and see if they'll come back with some more flexibility.

I see what you did there. #TeamDarkTheme

AH, excellent! Glad you worked it out!

Sounds good - it got late quick tonight so I'll update tomorrow morning with some detail.

Run: netstat -an | grep :161 Do you get something like this? xinu@xv:~$ netstat -an | grep :161 udp 0 0 127.0.0.1:161 0.0.0.0:*

You're very welcome - I'm glad it helped.

Hi there, you need to turn off SSL checking. SolarWinds uses a self-signed cert that won't pass validation unless you replace it with one that does. You would know if you did this. Go to File > Settings and make sure this is set to 'Off' and re-try your query. Also, about the + characters - if you leave them out of the…

So three things: normal check interval, retry check interval, and maximum check of 4 times. Normal Check Interval: Orion checks for these things every 120 seconds during the polling of your nodes. You can set it lower or higher, but right now it's 2 minutes. If you set it to 5 minutes, the alert wouldn't be aware of any…

Yes, but you have to do some work ahead of time. Ultimately you have to give the verb what it needs, but you can query for the NodeID ahead of time. You would submit this JSON to the query endpoint below as a POST with the content-type set to 'application/json':…

Do you have ${SEARCH_STRING} hanging out above your SELECT? If so, that needs to be removed.

If you need the poller to be 0 for 12 hours, this would work. I did the math for 24 hours by mistake, but just halve that.

That worked beautifully. I'll cook up a couple of examples that use the stuff above and send you a PR. Thanks!

Ah, then it's there. Just needs cards now.

You're very welcome! So as for why that line is necessary, let's break it down. Original Line: $Results = Get-SwisData -SwisConnection $SwisConnection -Query $SwqlQuery Explanation of each element: * $Results* Variables in PowerShell start with a $ sign. This variable is called $Results and whatever answer comes back from…

So you had a query string set up and then you used Get-SwisData and then you tried to use Out-File without any use of Get-SwisData. I think wires might be getting crossed. Here's a fully-functioning script that does exactly what you want. Adjust the $hostname, $username, and $password variables accordingly. The resulting…

Crazy! How have I not run into this before now? Thanks for the reference. I'm going to make a snack and read that MSDN article explaining this tomfoolery.

It's my pleasure! Thanks for the invitation. This query is going to give you the CPU statistics for all nodes and CPUs in the last 60 minutes: SELECT cpm.CPUIndex, cpm.AvgLoadFROM Orion.CPUMultiLoad cpmWHERE MINUTEDIFF(cpm.TimeStampUTC, GETUTCDATE()) < 60 So that information isn't terribly useful without its corresponding…

Right on! Glad to hear it. Make sure you tag a correct answer so folks can find it. Maybe also share your report definition in the content exchange for others to use?

BTW, this also has the issue with the SSL certificate from your other thread.

I have a gig coming up that's going to require doing a bit of old history merging after a migration, so I'll keep you updated. I would have done the same thing, being the off roader I am, but now it seems a little research is in order. =)

Does it work in Postman?

I'm not getting any errors and I'm running the same query. Having NULLs isn't necessarily a bad thing unless you're trying to do something with the column (like math/aggregates) that wouldn't work with NULL values. In which case you can just swap those values out with a CASE or ISNULL() call to make them something that's…

Do you really need to restart the server to sort out a squid problem?

Oh, that alert manager. Yeah, that's where you create the alert. So the process above has two stops - one in the Custom Property Editor to create and populate your interface property and then in the Advanced Alerts application to configure your alert using the new custom property.

I did and that doesn't seem to make a difference. I went ahead and created the node in the GUI, took stock of all the pollers assigned to it (and their Enabled settings) and mimicked that exactly in the code. Same result. https://gist.github.com/mrxinu/223c73c6f3636ff489a4/revisions -- Steven Klassen Developer Analyst @…