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

    Extracting IPSLA status changes with SWQL query



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






      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?