Applications Systems

How to move WPM transactions between locations without loss of historical data

Learn how to move WPM transactions between locations without losing historical data.

First published date

8/28/2019 4:21 PM

Last published date

1/7/2022 6:20 PM

Overview

This article describes how to move WPM transactions between locations without loss of historical data.

See also Migrate WPM Players to new systems.

Product section

Web Performance Monitor

Resolution

To move a WPM transaction to a different location, update the record in the Orion database.

  1. Stop all services in the Orion Service Manager.
  2. Use a SQL Server Management tool such as SQL Server Management Studio Express to connect to the Orion server as an administrator. 
  3. Open Database Manager and click Add default server. on the Orion Server Rdp to your main SW poller.
  4. Right-click the Orion Database and locate the SEUM_Transactions -> query table.
  5. Run the select query that auto-populated in Database Manager by right-clicking in the table and selecting top 1000.
  6. Click Enable table editing.
  7. Update the agentId column for the transaction you want to change locations for.


Run the following query in a new query window to check the agentId value for your locations.
SELECT TOP 1000 * FROM [dbo].[SEUM_Agents]

To submit this as a feature request for a future version of WPM, visit https://thwack.solarwinds.com/community/feature-request.