Is there a way to bulk rename alert definitions? We are going through some changes in the naming convention and need to update ~200 alert definitions. It'd be great if I could do it in bulk/SWQL/SDK way.
Thanks
Is there a way to bulk rename alert definitions? We are going through some changes in the naming convention and need to update ~200 alert definitions. It'd be great if I could do it in bulk/SWQL/SDK way.
Thanks
This may help you get started with the API, although tedious, it may be more efficient to do this through the UI.https://thwack.solarwinds.com/product-forums/the-orion-platform/f/orion-sdk/44001/proper-way-to-export-import-alert-configurations-via-sdk/174337#174337
And if you want to do it really fast the way we would do it in the long lost era of '17 would be in database manager, something to the effect of:
select ac.name as oldName, concat('NEWNAME - ',ac.name) as newName -- update ac set ac.name = concat('NEWNAME - ',ac.name) from alertconfiguration ac where ac.name like '%alerts I want to change%'
The trick there is you can run the script as is and tweak the where conditions and the newname syntax to make it just right, then when you are happy you move the newname stuff until the update line, highlight everything after the -- and hit F5 to run just that part of the code to make the change
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.