Bulk updates of database

[Sigurd Mytting]

Hi!

Due to organizational changes I need to update names of about 250
locations and change organization on about 800 devices, is there any way
to do this without removing/adding them all?

My first thought is SQL, is that the way to go? If so, there is 375
tables in the database, hints on what to update would be appreciated!

Cheers,

-Sigurd

[Morten Brekkevold]

Hi!
Due to organizational changes I need to update names of about 250 locations
and change organization on about 800 devices, is there any way to do this
without removing/adding them all?

With the new SeedDB, you cannot change the names of locations, but you
can move rooms from one location to another in bulk (edit rooms, check
the checkboxes for a set of rooms and click the "Move" button).

The same thing can be done for devices whose organization you wish to
change: Edit IP Devices, check the devices you wish to move to another
organization and click the "Move" button.

My first thought is SQL, is that the way to go? If so, there is 375 tables in
the database, hints on what to update would be appreciated!

If you really need to _rename_ 250 locations, it won't be any easier
with SQL, unless your renames have a common pattern. The locations are
stored in the table called "location".

Beware that if you have any maintence tasks planned in NAV for any of
these locations, these will likely not be updated when you rename.