I need to change the custom location string of every device. Does anyone know of an easier way of doing this, other than through the web GUI? I tried changing to location column under the device_locations table but that doesn't work. My assumption is that I would just make changes somewhere in the Observium database but I can't seem to find where the custom location data is stored.

Any Ideas?