My suggestion would be to go to Settings > Manage Custom Properties. Then Group By object on the left hand menu, select Nodes, select all the Node custom properties and use the 'Export values' to export it to Excel.
From the Custom Property manager, clear out all the drop down options for the custom properties you would like to scrub the data for
Fix the data in Excel, and use the 'Import values' in Settings > Manage Custom Properties.
That should do it without any DBA help
Hi HolyGuacamole - love the name BTW!
I'll play around with that and much appreciate the "out of the box" thinking
Thanks, Paul. Please post your findings back to the discussion.
You can do this from the web GUI as well. I've used Country as an example in my lab but the same methodology applies to any other custom property.
Note: The instructions below are taken from using the Custom Properties Editor but you can do the same from the Manage Nodes screen as well.
- Click on Settings and then Manage Custom Properties. (or Manage Nodes)
- Select a custom property and click View/Edit Values.
- On the Custom Property Editor page, select the particular custom property from the Group By drop-down menu. This will let you filter the nodes based on their current assigned value. Note the [Unknown] represents nodes that haven't had a value applied. (if you are going via Manage Nodes, you should be able to group by Nodes Custom Properties - "customproperty").
- Select the values on the left you want to replace and you can either change the values manually on the right pane, or select all the values and click Edit multiple values. The count on the left will automatically update once you save the changes. Please be aware that custom property drop-down values not in use will not show in this list.
- Once you have all your values set, you can go back to Manage Custom Properties, and edit the particular custom property.
- On the Edit Custom Property page, click the X next to the values you want to remove from the drop-down menu. Note the system will warn you if you try and delete a value currently in use - for these cases you can then quickly go back and use the method above to locate and change those devices.
- Any alerts/reports/views/accounts that use the custom property as a filter should be double checked to verify that the conditions match your remaining values. i.e. if you have an alert filtered by "APC 7900", change it to filter on "APC AP7900".