Orion SDK, DIFF transaction

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?

Find more posts tagged with

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)

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)

Hey tdanner, im not able to make this query work. May i get a query that shows me a table with the recordings on an agent.

That query should do it. What error are you getting?

Source entity [Orion.SEUM.Recording] not found in catalog

Thanks for your help.

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)