Is there a way to bulk rename alert definitions?

Question

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

mesverrum · Answer

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

tony.johnson · Answer

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