gregthompson

Need this!

...when in doubt, build it yourself... thwack.solarwinds.com/.../3738

Anyone know if this is possible to pass data/variables between conditions whether they be alert conditions or trigger conditions? That would be useful if you needed to formulate something and massage some data then use it in the next condition/step...

No, I can't send to the script because they may contain single or double quotes, hence the need to sanitize prior to sending.

Can data be passed from primary to secondary sections in the alert trigger?

I bet everyone is so quiet because there IS a way, right?

This is no longer needed.

The idea is to have the primary conditions be any legitimate alert, secondarily to then check if the node in question already has an active unacknowledged alert. I have the SWQL for the secondary and obviously since this should work for any Node based trigger, for it to work the secondary section would need to know which…

It will create 64 subnets spanning the entire supernet.

Yeah I can script a big "thing" but I was hoping for a singular verb.

Subnet Allocation Wizard will take a supernet address and create a desired set of subnets based on the cidr size you choose. So if I put in a /16 and tell it to create all the /22's within that /16, it creates the supernet and nests all the /22's within it. It would be awesome to be able to bulk add supernets to be broken…

Yeah I did that already, not a thing in SWQL.

Works for me, just deleted a supernet, re-added it with this method and everything is visible. We're running IPAM 2022.4.1

...or is it not a thing in Solarwinds products?

The issue in basing it on new switches would be when we change the scope of what's to be disabled, as well as discovering new active interfaces potentially turned "on" after being administratively down. So scheduled task makes the most sense I suppose if an Alert can't be utilized. Since we only want to target specific…

$dbserver = "server.domain.com" $database = "SolarwindsOrion" $queryWhere = "where (displayname like '%transceiver%' or displayname like '%bias%' or displayname like '%receive%'or displayname like '%transmit%' or displayname like '%supply voltage%') and isdisabled = '0'" $cn = new-object…

What I wrote here basically... https://thwack.solarwinds.com/product-forums/the-orion-platform/f/alert-lab/97535/single-instance-of-an-alert Because potentially thousands of interface sensors are created as nodes are added I wanted to use an Alert that looked for ANY that met our criteria to be disabled since we need some…

Now I'm sad.

I'm not passing anything from the Alert to the script. Think of the Alert like a watch dog, if ANY of our interface sensors are found to be enabled matching the names listed in the condition, run the script to find and disable them. The reason I'm not passing the data to the script is that each time we add a Switch,…

You see where I'm going with this though right because it sounds simple enough... "IF triggered only run 1 time and 'hibernate' for X minutes before you can be re-triggered"

So the idea is to find any sensors matching the criteria, and only run the powershell script 1 time, because the script does a SQL query (same as the trigger condition basically) and gets ALL the sensors and sets them to disabled. (ignore the variable being passed to the script)

Standard alert... this is what it's using to detect the trigger conditions.

Ok, so far this is what I've done with bizarre results only because of the quote on ${Name} that doesn't work, but also somehow isn't required?? FILTERMethodResultDifferenceGroups.Name = '${Caption}'Added via GUIFailed to show on Mapsingle quotesGroups.Name = ${Caption}Attempted via GUIWon't let me saveno quotesGroups.Name…

Yeah I don't want to get that deep either, we're new to SW but I've been doing this stuff for 1000 years in other systems. So now I'm in SWQL and this will update the specific filter value for a single worldwide map widget. I'm trying to see what I can put in here to have it work. Set-SwisObject $swis -Uri…

Is there a way to make a copy of an the existing Worldwide Map Widget so it can be edited and tweaked and maybe have the filter piece updated to accept the variable, or see where in the DB it's storing it's code, etc... ? Or, a way to make a worldwide map via custom html that uses the group data?

So the title and subtitle parse the variable but the SWQL filter (where we need) won't??? That can't be right... lol. What about the fact that the group itself has lat/long attached to it already, it doesn't use that either?

I did, and now a month later I have been told it's not possible in the ticket and now I have been told it is possible and am getting nowhere. 

In the script, if you change this: $IPAMSubnet = Get-SwisData -SwisConnection $swis -Query "SELECT SubnetId, ParentId, Address, FriendlyName, uri FROM IPAM.Subnet WHERE Address LIKE '%$IPAMSubnetAddress%'" to this: $IPAMSubnet = Get-SwisData -SwisConnection $swis -Query "SELECT SubnetId, ParentId, Address, FriendlyName,…

Just found this, let's see! thwack.solarwinds.com/.../295860

I'll take that as a no. Would be nice to move an existing discovered DHCP scope to another group within the same hierarchy.