1 Reply Latest reply on Mar 27, 2014 9:58 AM by tdanner

    Does SWIS map to dbo.AlertLog so I can see logged alert actions by SWQL?

    bluefunelemental

      Something akin to:

       

      SELECT TOP 100

      DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), a.LogDateTime)

             AS ColumnInLocalTime

      , d.AlertName

      , a.ObjectType

      , a.ObjectName

      , a.ActionType

      , a.Message

      , '/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