Something akin to:
SELECT TOP 100
DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), a.LogDateTime)
, '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + a.ObjectID AS [DetailsURL]
FROM Orion.dbo.AlertLog a
INNER JOIN Orion.dbo.AlertDefinitions d on d.AlertDefID = a.AlertDefID
ORDER BY a.LogDateTime desc
The AlertLog table is not currently available through SWIS.