mrxinu

I have a bug to report and was just looking for the smoothest way to do this. I totally think having a section where we can submit steps to reproduce makes sense. Let's do it!

Thanks! Glad to be here! Y'all are great.

adatole​ - on Daemon & Freedom, yes a thousand times yes. I've re-read those books at least 3 times each. Thanks for the other recommendations - I was just about to need a reload on my reading list and this hits the spot!

If you mean to send an email to a different person depending on the type of device then there's another way. Create a node custom property called 'Contact_Email' (or something similar) and populate it with comma-delimited email addresses (i.e., foo@example.com,bar@example.com). Create your alert, but in the 'To:' field of…

I do believe if I lost my phone I would head home immediately. #gameover

rschroeder​ - Uh oh, what's S/F? I want to be entertained.

Hi there, Because you only have access to your own information, that's all you'll get back based on your login's permissions. As for using a global administrator account, that's all the documentation would tell me when I wrote the SAM templates originally but I think that a colleague was able to whittle down the…

It needs to get some attention before it comes off the bottom of the pile. Get your colleagues to vote it up!

You're too kind my friend.

I would say monitoring, but I'm not sure what you're referring to. Can I get a screenshot?

Are you using modern auth on your account?

print(results['results'][0]['EngineID']) maybe?

You've broken my brain. Any chance you want to have a real-time conversation about this?

Yay for immense help! I'm glad you worked it out and thanks for sharing the solution! I've added it to my list 'o tricks.

print(results[0]['EngineID'])

For sure, and that's how the other functions made their way into SWQL. Open a feature request and we shall vote it into existence!

Hey @"hebron1212"! Your original query did provide a count of the distinct messages that matched the '%Max%' pattern, that's true. The issue is that this doesn't help you alert on a node. To alert on a node you have to associate what you uncover in the query with a specific node. I assumed you wanted to know how many…

Hey there, @"christycooper" was right - I didn't see the whole def query business. Did you try their suggestion of converting that to a string from a function?

Hey there! No, Get-SwisObject was what I was shooting for - that'll give you all the details about the group (Orion.Container) so you know what the existing values are. Then you would use the verb to update only the portions that you want updated. The update portion of the process is here:…

Outstanding advice all around! I added the ones I was missing!

Best reference ever.

You the real MVP.

Hey there! Are you looking to see if two strings have an identical case, or that they're equivalent despite the case? If it's the former, you may be stuck converting this query to SQL. If it's the latter, convert both strings to lowercase with ToLower(string) and then compare them.

Well done! I've gotten tagged to write some queries for F5 before but this is so much more awesome!

I was just talking to someone about must-have tools the other day. I don't know that this will apply to everyone, but given that there's an awful lot of cool stuff you can do with the SolarWinds API, a proper development environment wouldn't hurt. So, onward... * Visual Studio Code* I like this over ISE because it does a…

You write a mighty fine post! And the organized edit notes at the bottom? :chefkiss: perfection!

Hey @"hebron1212"! You've got a little overlap going on between the static portion of the query in the top box and what you've provided in the bottom box (they both have SELECT statements). You need to use the same maneuver (awkward, I know) that you did in the thread you referenced that starts the portion in the box…

You could use SECONDDIFF and January 1st, 1970 to get that value like this: SELECT TOP 1 SECONDDIFF('01-01-1970 00:00:00', GETUTCDATE()) AS UnixTimeStamp FROM Orion.Nodes

I don't believe this has changed, maybe @"tdanner" can verify, but this issue/PR suggest that it's set to 30s on the server side and can't be adjusted. https://github.com/solarwinds/orionsdk-python/issues/18

Hey there, You're assigning the current row to 'row' and then you're not using it in your variable. Change EngineID in the curly braces to row.EngineID.