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
