How do add get an alert to display custom detail based on ComponentID?

-SGregory-

Hi,

I am trying to define an alert, to show custom information based on the particular component that triggers the alert.  In the alert definition I have opted to use SWQL to pull the information I need, this works fine, but only if I manually specify the ComponentID field in the SWQL, like this:

${N=SWQL;M=SELECT StringData FROM Orion.APM.MultipleStatisticData WHERE ComponentID =54411}

Is it possible to have the alert retrieve the component ID dynamically?  I thought it was with a query like the below:

${N=SWQL;M=SELECT StringData FROM Orion.APM.MultipleStatisticData WHERE ComponentID = ${N=SwisEntity;M=ComponentAlert. ComponentID}}

But it doesn't work and simply shows the query as typed, instead of the actual data that i'm after.  Does anyone have any ideas?

Thanks in advance for any information you can provide.

Simon

adam.beedell

Yes it's possible and you're doing the method about right, some detail is off

If it spits back the code it means one of 3 things

1) Code's invalid

2) No data found (If you're writing custom, using a CASE or UNION allows this to fail gracefully)

3) You found data, but it doesnt line up well with being in the top left cell

Nothing at a glance screams "obviously wrong" to me, but the component ID macro is an unusual choice. I'd stick that above on an email action and make sure it resolves properly. Might be safer to put some quotes around it.

If it resolves ok, you've kinda checked 2) already

3) will be an issue sooner or later because you've got <10 values per component ID and macros (right now) want to resolve a single cell. You can JOIN or CONCAT or supply a bunch of macros to get rows/columns, or have to use SQL to get proper tables. I'm doing a bit of work in this space at the moment.