You are talking about DPA, right? If yes, do a query against the repository:
select id, name from COND;
That will show you what's being displayed. You can update that column directly with what you want to see (use _ or other strategies).
update COND set name='INSTNAME' where id = X
Shouldn't take more than just a couple minutes.
what is DPA ?
We are using ORION solution to monitor network, and some external nodes in those nodes definition some contain spaces.... I need to remove space in a faster way to edit all of the by using Solarwinds regular interface....
I see - DPA (Database Performance Analyzer) is the product you posted this under. I think you meant to post it under NPM.
I'd recommend you copy/paste the original question under the NPM product.