WPM Transaction Step Status (SWQL)

Version 3

    One of the request I had received was to create a query to display the status of the transaction steps which is customizable.

     

    Easily done with SWQL.  The hard part was figuring where the icons were.

     

     

    SELECT

    TS.Transaction.DisplayName as [Transaction]

    ,'/Orion/SEUM/images/StatusIcons/Small-Transaction-' + TS.Transaction.StatusDescription+'.gif' AS [_IconFor_Transaction]

    ,TS.DisplayName as Step

    ,TS.DetailsUrl as [_LinkFor_Step]

    ,'/Orion/SEUM/images/StatusIcons/Small-Transaction-Step-' + TS.StatusDescription+'.gif' AS [_IconFor_Step]

    ,TS.LastDuration

    ,TS.LastErrorMessage, tolocal(TS.LastPlayedUtc) as LastPlayed

    FROM Orion.SEUM.TransactionSteps TS

    where

    TS.Transaction.DisplayName like '%${SEARCH_STRING}%' or

    TS.DisplayName like '%${SEARCH_STRING}%'  or

    TS.StatusDescription like '%${SEARCH_STRING}%'

     

     

    Thanks

    Amit