Alert when 2 Player locations show a web transaction down

Sure. Bear in mind that in Solarwinds terms, a "Transaction" entity is the combination of a Location and a Recording. So, you're asking about cases where you have one Recording in two Locations, and both of those Transactions are down.

Here's how to do it:

1. Create a new alert.
2. For "I want to alert on", choose "Custom SWQL Alert (Advanced)".
3. For "Set up your SWQL condition", choose "Transaction".
4. You'll see the next field change to the beginning of a SWQL query:

   SELECT Transactions.Uri, Transactions.DisplayName FROM Orion.SEUM.Transactions AS Transactions

5. In the field below that, add this:

   WHERE RecordingID IN

   (

   SELECT RecordingId

   FROM Orion.SEUM.Transactions T

   WHERE Status = 2

   GROUP BY RecordingID, Status

   HAVING Count(RecordingID) >= 2

   )

6. Finish setting up your alert actions, etc.

This part of the query finds all Recordings there are at least two instances of the recording (that is, two Transactions) and both instances have a status of 2 (Down):

SELECT RecordingId

FROM Orion.SEUM.Transactions T

WHERE Status = 2

GROUP BY RecordingID, Status

HAVING Count(RecordingID) >= 2

This part of the query finds all transactions that use that Recording:

SELECT Transactions.Uri, Transactions.DisplayName FROM Orion.SEUM.Transactions AS Transactions

WHERE RecordingID IN ()