Updating Custom Properties Directly in SQL

I hope so I do it all the time in APM to be able to use custom properties within the dynamic queries...

ditto.  I think the only time you have to worry is if you have something auto populating the custom property.

Adding information into the Custom Properties columns should not be an issue. Adding new columns to the Tables would cause issues.

Adding information into the Custom Properties columns should not be an issue. Adding new columns to the Tables would cause issues.

Thanks Sean! 

This is what I thought but figured better to play it safe and verify first.

Can you expand on this a bit more please:

"Adding new columns to the Tables would cause issues"

Custom properties are represented by columns in given table and also by metadata stored in Information Service. If you add your own column we will have no information about them. It can later caused some issues (e.g. during upgrade) etc.

What about doing the following:

create a table and call it "MyAPMTemplateCustomProperties"

then write alerts / reports in sql referencing the extra table for my custom properties.

This could then be extended to :

• MyGroupsCustomProperties
• MyAPMComponentCustomProperties
• ...

?

I have already done something similar by adding an export from a CMDB as a separate table and then using writing sql to generate a report that shows the difference between the two tables.

Chris

It sounds reasonably. Of course Orion doesn't know anything about your tables so if you add any new Orion entity (let's say Group) there will be no corresponding record in your table etc.

But if you write your SQL queries carefully there should be no problem.

Hi,

i would like use same query to update node's custom property, could you please help me to text a query, and one more thing same query i can use as a batch file so same could be auto.

thanks

K