I would like to have an annotation automatically created when objects (stored procedures, indexes, etc.) are created or changed.
Does anyone already have a script to do that? Or, just point me to the DPA table(s) I will need to insert, and I can do it myself.
The table is CON_EVENTS. The table does have a DBID column and you would want to make sure that you fill this in with the ID of the monitored instance you want to insert the annotation on.
This would be the ID from the COND table. "SELECT ID, NAME FROM COND;" will give you the ID of your registered monitored instances.
ORACLE DATA TYPE
SQL SERVER DATA TYPE
|ID||NUMBER||BIGINT||NO||Yes||The primary key ID. We will need a primary key generator.|
|DBID||NUMBER||SMALLINT||NO||No||The ID of the database that this event belongs to from the COND table.|
|EVENT_DATE||DATE||DATETIME||NO||No||The time of the event down to the minute. This is the DPA server time.|
|TITLE||NVARCHAR2(100)||NVARCHAR(100)||NO||No||The title of the event.|
|CREATOR||NVARCHAR2(50)||NVARCHAR(50)||YES||No||The user that created the annotation.|
|DESCRIPTION||NVARCHAR2(2000)||NVARCHAR(2000)||YES||No||A description of what was done.|
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.