5 Replies Latest reply on Aug 13, 2019 9:59 AM by smarks73

    Extracting IPSLA status changes with SWQL query

    smarks73

      Hi,

      The following query outputs the status of IPSLA tests, in the form shown in the picture below.

       

      SELECT

      oa.OperationInstanceID,

      oa.RecordTime,

      oa.OperationStatusID

      FROM Orion.IpSla.OperationAvailability oa

       

       

      I'm trying to modify the output so that it only shows rows where OperationStatusID has changed.  i.e. in this example, only the highlighted rows should be in the output.

       

      After much searching, the only approaches I can find are SQL examples that either use functions that SWQL does not have, or requires a subquery within a WHERE clause, which is also not supported by SWQL.

       

      Is there any way this can be achieved, without resorting to directly querying the db with SQL?