Add "custom properties" to "active alert details" page

Greetings all,

I've been lurking here for a few weeks trying to find an answer to a question, so apologies if I've overlooked it.

I'm trying to figure out how to add custom properties to the active alerts details page that comes up when you click an alert. I thought it would be a relatively simple thing to make visible, but almost 3 weeks later, after baking my brain digging through the finer details of custom querys, SWIS, and SWQL/SQL (which I've been avoiding my whole career because it kind of terrifies me), I've been unable to determine what variable to use in a query to represent the relative value for the NodeID that triggered the alert, or if I'm going about this all wrong.

Here's where I'm stuck at.

SELECT
N.NodeID AS NodeID,
N.CustomProperties.Device_Type,
N.Caption,
N.CustomProperties.Owner,
N.CustomProperties.Phone_Number,
N.CustomProperties.Site_Location
FROM
Orion.Nodes N
WHERE
NodeID = ${N=SwisEntity;M=NodeID}

When I substitute

${N=SwisEntity;M=NodeID}

with a hard-coded NodeID, it spits out exactly what I'm looking for.

Any assistance anyone can offer would be much appreciated.

Find more posts tagged with

swql query

Custom Properties

swis

active alert

Accepted answers

sum_giais

Typically when trying to populate variables in the web, you are restricted to what the webpage can provide you for default variables and they usually don't follow that syntax - e.g. instead of ${N=SwisEntity;M=AlertObjectID} it would be just ${AlertObjectID} -- note I haven't actually tested that so who knows maybe it would work?

Looks as though these values populate

${AlertObjectID}
${RelatedNodeId}
${RelatedNodeDetailsUrl}
${RelatedNodeCaption}

Give this custom query a go (in a custom query widget) and let us know if it works or not - just update the Node custom property text "cp_prop_name_here" to a valid custom property in your environment.

SELECT
	 aa.AlertObjects.Node.Caption
	,CONCAT('/NetPerfMon/images/Small-', aa.AlertObjects.Node.StatusLED) AS [_IconFor_Caption]
	,aa.AlertObjects.Node.DetailsUrl AS [_LinkFor_Caption]
	,aa.AlertObjects.Node.IP_Address
	,aa.AlertObjects.Node.CustomProperties.cp_prop_name_here
FROM Orion.AlertActive AS aa
WHERE aa.AlertObjectID = ${AlertObjectID}
AND aa.AlertObjects.RelatedNodeId = ${RelatedNodeId}

Good luck!

All comments

monitoringlife

To clarify, are you trying to add a resource to the SolarWinds webpage for alert details view?

Or add extra payload to your alert execution, EX: email/team/service-now/webhook?

The format "${N=SwisEntity;M=NodeID}" is only used by the alert engines actions (trigger/reset).

LWBeez

I'm trying to add an object (whether it be a new widget, or a field that can be enabled in one of the already present widgets, or something of the like) that will indicate on the active alert details page what the selected custom properties of the node are (i.e. phone number, asset owner, location).

We've already updated the email alert to include this information, but I think some of the personnel responsible for notifiying the relevent parties aren't looking at the emails and are instead just calling my shop because there's no owner & contact info listed in the active alert details.

sum_giais

Looks as though these values populate

${AlertObjectID}
${RelatedNodeId}
${RelatedNodeDetailsUrl}
${RelatedNodeCaption}

SELECT
	 aa.AlertObjects.Node.Caption
	,CONCAT('/NetPerfMon/images/Small-', aa.AlertObjects.Node.StatusLED) AS [_IconFor_Caption]
	,aa.AlertObjects.Node.DetailsUrl AS [_LinkFor_Caption]
	,aa.AlertObjects.Node.IP_Address
	,aa.AlertObjects.Node.CustomProperties.cp_prop_name_here
FROM Orion.AlertActive AS aa
WHERE aa.AlertObjectID = ${AlertObjectID}
AND aa.AlertObjects.RelatedNodeId = ${RelatedNodeId}

Good luck!

LWBeez

You are a genius. This gets it done! Much appreciated.