Is there a method in SQL to make SAM components overide the template?

Question

I was hoping I would be able to over ride some templates in bulk to make the process more scalable, I have about 1,000 adjustments I want to make and clicking them each one by one seems foolish,

I've been poking at the db but it doesn't seem like there is an on/off kind of variable for over riding the template, wherever I have manually done an over ride I see it creates new entries in [APM_ComponentSetting].  I'd imagine that there must be some way I can break this into a two part process, one to effectively click the over ride button and get those entries added to the db, and then a second pass to update their values based on some custom properties I made.

Anyone done this before?

Petr.Vilem · Accepted Answer

Creating record in [APM_ComponentSetting] is really the only change on database side to effectively "override" some of component's setting. If you wish to have it defined as two steps operation then first step could be copying corresponding record from [APM_ComponentTemplateSetting] and second would be updating it's value field. Keep in mind that by inserting incorrect value (e.g. nonexisting option for some enum field) you can break your polling. Also note that values updated directly in database will not be applied until restart of services.