Alert action script to update Solarwinds database

Hi, I am looking for a script to update a record in the Orion Containers table via alert action. I've checked the SDK but not much success. Can anyone assist ?

Find more posts tagged with

triggered_alerts

script

Accepted answers

coreys

Const DB_CONNECT_STRING = "Provider=SQLOLEDB.1;Data Source=<Server>\<DB Service>;Initial Catalog=<Database>;User ID='Admin';Password='Pass'"

Set myConn = CreateObject("ADODB.Connection")

Set myCommand = CreateObject("ADODB.Command" )

myConn.Open DB_CONNECT_STRING

Set myCommand.ActiveConnection = myConn

myCommand.CommandText = "UPDATE <Table> SET <Column>=<Value> WHERE <Column>=<Value>"

myCommand.Execute

myConn.Close

All comments

coreys

I found one.

RichardLetts

Would you share it?

coreys

Const DB_CONNECT_STRING = "Provider=SQLOLEDB.1;Data Source=<Server>\<DB Service>;Initial Catalog=<Database>;User ID='Admin';Password='Pass'"

Set myConn = CreateObject("ADODB.Connection")

Set myCommand = CreateObject("ADODB.Command" )

myConn.Open DB_CONNECT_STRING

Set myCommand.ActiveConnection = myConn

myCommand.CommandText = "UPDATE <Table> SET <Column>=<Value> WHERE <Column>=<Value>"

myCommand.Execute

myConn.Close