This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Need help adding CustomPropertyValues in Orion

ltakacs over 6 years ago

Hello -

I am just looking for a simple answer - and NOT a complicated solution with sql triggers etc

We have a custom field defined, I can see the values in the dbo.CustomPropertyValues table.

When they're added from SolarWinds GUI, they're usable. I need to be able to add new values from a SQL query - but they don't show up in the GUI as an option if I add to the table from SQL, why? Is there another table I need to add these values to?

-----

This is the query I am using to insert:

INSERT INTO dbo.CustomPropertyValues(TargetTable,Name,Value) VALUES ('NodesCustomProperties','Custom_Application','Powerscribe');

When I run the select query, it shows as a value. When I check the GUI, it does not display as an option in the dropdown.

The values look the same as those added by the GUI, no additional spaces or special characters.

Top Replies

0 tdanner over 6 years ago

There's probably some cache in the website that doesn't notice your database change. I expect that after a restart (iisreset or recycle application pool) it would pick up the new properties.
The preferred way to handle this would be to use the API. This will broadcast an internal message that will invalidate these kinds of caches so the change appears without a website restart (if you have the custom property editor open in a browser, you will probably need to refresh the page - the broadcast doesn't extend that far).
I documented the API way to do this, including a sample script for the specific case of adding a new value, here: https://github.com/solarwinds/OrionSDK/wiki/Managing-Custom-Properties#modifying-custom-properties . The example uses PowerShell syntax, but you can accomplish the same thing with the REST API endpoint if that is a better fit for your environment.
Cancel
Vote Up +2 Vote Down

Cancel
0 ltakacs over 6 years ago in reply to tdanner

Hi, I looked over your powershell script. Unfortunately, I don't have a 'CustomProperties' table.
I'm also running into trouble deleting entries, even from the GUI.
What fields does the CustomProperties table have?
Cancel
Vote Up 0 Vote Down

Cancel
0 tdanner over 6 years ago in reply to ltakacs

My script works through the Orion API, not the database. The entities in the API do not always correspond directly to database tables.
Cancel
Vote Up +1 Vote Down

Cancel
0 ltakacs over 6 years ago in reply to tdanner

Thank you, that would make sense.
I was able to get your PowerOrion module installed, but I cannot figure out which folder to move to Modules to install to run the original code you referenced (for connect-swis).
Cancel
Vote Up 0 Vote Down

Cancel
0 tdanner over 6 years ago in reply to ltakacs

Just run "Install-Module SwisPowerShell" and let powershell handle downloading and installing it.
Cancel
Vote Up +1 Vote Down

Cancel
0 ltakacs over 6 years ago in reply to tdanner

Your code works wonderful! Thank you so much for your help with this.
Cancel
Vote Up 0 Vote Down

Cancel