Alerts - action - email a web page -> doesn't work if SWQL resource

njoylif

I'm probably missing something...

WPM -> transaction alert trigger sends "email a web page" but doesn't seem to execute the custom SWQL...

this is the email I get:

trx get.PNG

this is the section I want (circled):

trx detail.PNG

This is the custom SWQL table on the web page for the trx that alerts:

trx wrote.PNG

Here is the code for custom SWQL resource:

SELECT

'' as stat, StatusName as Status, ts.DisplayName as Step,

'/Orion/StatusIcon.ashx?entity=Orion.SEUM.TransactionSteps&id=0&status='+toString(ts.status)+'&size=Small' as [_iconFor_stat] ,

'' as [_LinkFor_Step],

LastDuration as ms

FROM Orion.SEUM.TransactionSteps ts

JOIN Orion.StatusInfo s on ts.status=s.statusID

Where ts.RecordingID=${RecordingID}

Find more posts tagged with

Alert

SWQL

custom swql resource

email_a_web_page

Accepted answers

All comments

njoylif

bump, anyone run into this?

njoylif

tdanner‌, would you take a quick look? trying to send "detached resource" SWQL table in alert action -> send web page... is this possible?

thx

mwb

I'm staring at the same thing currently. Rather than being emailed the page as it would display in SAM, I'm being emailed the text of the SWQL query.

njoylif

ok; probably time to open a ticket then. If you do as well, please post ticket number here.

Thanks!

mwb

Curious if you ever got a resolution on this? I stumbled across it again trying to send a very specific list of data through an alert on a trigger. Can't send a web report on a trigger, should be able to send a web page - one with my SWQL query resource, but again I'm seeing this email as just the text of the query itself rather than any results.

njoylif

I just ended up using a native resource and it fell off my radar.

12 is RC though. when I get a chance, I'll test and post back...though it will probably take a while.

mwb

This seems to have busted fully in the sense that in SAM 6.3, the only way to email a webpage is now as an attachment - so there's not even a way to sent SWQL results on a page into the body of an email. I've opened another ticket.

ecklerwr1

If I'm not mistaken I have seen tdanner refer to this issue before which would explain the 3 bugs that are posted. If you want to look at it it's all up on github.