Is there a query that i can use to display the differences in transactions in two wpm boxes? Is there a way to have them identical?
This query should list all of the recordings on agent #1 and agent #2. (I don't have a WPM environment handy to test it.)
SELECT R.RecordingId, R.Name AS RecordingName, R.Transactions.AgentId, R.Transactions.Agent.Name AS AgentName
FROM Orion.SEUM.Recording R
WHERE R.Transactions.AgentId IN (1, 2)
Argh! That's what I get for posting a query without testing it. Typo - it should be Orion.SEUM.Recordings. Like this:
SELECT R.RecordingId, R.Name AS RecordingName, R.Transactions.AgentId, R.Transactions.Agent.Name AS AgentName
FROM Orion.SEUM.Recordings R
WHERE R.Transactions.AgentId IN (1, 2)
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.