Is it possible to change SAM component thresholds with SDK?

I need to change the warning and critical thresholds of over 300 application components (HTTP and HTTPS monitors). Instead of doing this by hand I was wondering if there was any support of doing it through the SDK? I looked at the documentation and it doesn't look like there is a SWIS verb for changing component thresholds. Does that mean I am out of luck? Are there any other options?

Thanks.

Find more posts tagged with

threshold

sam

Component

sdk

Accepted answers

All comments

mrxinu

Hey @mesverrum, didn't go a few rounds with these thresholds recently?

mesverrum

So the SDK doesn't directly expose this for us to modify, you can Read them via Orion.APM.Threshold or Orion.APM.ThresholdsByComponent but the tables don't support any edits via SWQL.

With that said, you definitely can manipulate them in SQL, and you can use the SDK as your gateway to the SQL if you don't want to have to write your own tooling to get into the database.

The below SQL query will show you the relevant tables you'd be interacting with, Basically if you want to edit a threshold at the template level you just update the value for the template entry on thresholds, but if you want to create an application level template over ride you need to insert a new row into thresholds with istemplate = 0. This whole process can get sketchy in a hurry so back up your DB before you do anything fun.

SELECT top 100
n.Caption as Node
, a.Name as Application
, c.Name as Component
, t.*
, tt.*

FROM nodes n
join APM_Application a on a.nodeid=n.nodeid
join APM_Component c on c.ApplicationID=a.ID
join apm_componenttemplate ct on c.TemplateID=ct.ID
left join APM_Threshold t on c.id=t.id and t.IsTemplate=0
left join APM_Threshold tt on tt.id=ct.id and tt.istemplate=1

mrxinu

@mesverrum You're a genius, sir.