Hello! I'm new to Solarwinds, so please feel encouraged to point out if I'm going about this in a stupid way.
TL;DR, how can I bulk update the Script Arguments for ~400 applied monitors to include the custom property tag "${Node.Custom.SITE}"?
Currently, we have a monitor template that's applied to just over 400 Nodes. Let's call it 'Website Monitor'. The monitor runs a Powershell script every polling interval, and returns statistics about how long each site takes to respond and if it fails to return an 'HTTP OK' status. The script is populated with Script Arguments set on each Node, piping in the URI and other details.
Because we rotate between environments from time to time via Netscaler, certain Nodes will either be considered Active or Standby depending on whether they are actually seeing traffic. We don't want our Operations team sounding the alarm if a Standby server drops offline, especially overnight as it results in a phonecall to on-call techs. In order to accomplish this, we've updated the script to parse whether the server is live or not, but this involves changing the Script Arguments! Remember how I said they were set on each Node? As I see it, I could spend the better part of an afternoon opening ~400 tabs and adding the custom property tag "${Node.Custom.SITE}" to each one, but that gives me the strong suspicion that I'm going about this in the wrong way. An alternative would be to edit in SQL: the monitors' ScriptArgs are stored in [SolarWinds].[dbo].[APM_ComponentSetting], but I need to correlate those with the associated Template and I'm not sure which tables to join to accomplish that.
Any suggestions would be much appreciated.
