Bulk update Orion Maps behaviour URLs

tobyw_loop1

Does anyone know how to update Orion Maps behaviour URLs en masse? At the minute having trouble actually finding where those are stored in the database

Use case - we want to change the URL from using an IP to just /Orion/ so it works with a customer loadbalancer accessed via their domain. We have updated the majority but they have over 200 maps and we want to try and speed up the process. Majority are already converted but we want to try and verify

tobyw_loop1

For anyone reading this, I spoke with some colleagues internally and the following should get the data you need 

SELECT
    DisplayName
FROM
    Maps_Projects
WHERE
    Data LIKE '%clickUrl%192.168.1.10%'

The data is in XML format in the Data column in Maps_Projects table.