Highlighted
Occasional contributor

App Portal / App Broker

Is it possible to globally update  a Catalog Title name that has a specific common word in each title.  We would like to find the common word and replace /rename it with another.  We have hundreds of Catalog items needing a specific word rename and would not like to open each one to rename.

Thanks!

0 Kudos
2 Replies
Highlighted
Flexera
Flexera

Re: App Portal / App Broker

The catalog item titles are stored in the WD_WebPackages table in the column PackageTitle.. As such, I think that a query similar to the following would work for you.. 

update WD_webpackages
set PackageTitle = Replace(PackageTitle, 'notepad', 'textpad')

The above query will replace the word "notepad" with "textpad" for every row (for each catalog item)

0 Kudos
Highlighted
Occasional contributor

Re: App Portal / App Broker

Hi Charles,

Thanks for the information!  Really appreciate the quick reply.

 

Mike

 

0 Kudos