Bulk Update Resource Name

Bulk Update Resource Name

The decision has been made to rename all the phone assets.

  • There are ~600 phone assets so bulk updating would be preferred
  • We have been using the existing phone assets and need to keep the history. I believe that exporting, making the change and importing the assets won't carry the history over (and duplicate the assets)
  • The updated  will use existing data; for example setting the display name to be the serial number
  • We are using SQL Server 2008, Manage Engine 9.1 Build 9120

I can see in the database that the Resources.RESOURCENAME and CI.CINAME both contain the asset name that we want to update, are there other places that need to be updated?