Hi, is there a quick or easy way to edit caption field to match a custom property in Orion?
Thanks
Have used the following to update manually
UPDATE NodesData SET Caption = 'High Street 3' WHERE IP_Address = '192.168.0.111'
I prefer to use powershell, take a look at the post by @KMSigma.SWI (+) PowerShell to Update Captions - What features am I missing? - Orion SDK - The Orion Platform - THWACK - SolarWinds Community If I were writing your script, I would Connect to Orion, pull in a list of nodes to check, loop through each to see if the name in Orion is like the name you want from the caption. I do some similar to this script removing the domains from FQDN, and there are a few places taht I build location based names from properties
A third way is to use an alert action.
Actually Caption isn't one of the fields that can be modified using this method.
Yes and the Caption field is also not open to edit when modifying Custom Properties (View/Edit Values)
Thanks, will look into this!
The above is directly in the SQL database. Although at first glance this will work, I avoid making direct database edits like the plague - too many things can go sideways. If you use the API, you are insulated from breaking (most) things.
Had to do this today so here is how: How To: Powershell Script that allows you to Bulk Edit Captions from a spreadsheet - Forum - Network Performance Monitor (NPM) - THWACK (solarwinds.com)
