Advance Group Alert

All,

I'm probably overthinking this or over complicating it at the least, so I'm asking the experts to bring me back down to earth. Using these posts, I'm trying to create a group alert that lists the group members in a table with their status within the e-mail. I'm using the "Group is in warning or is in critical" alert as my starting template. The second post shows exactly what I'd like to see in the body of my alert.

Re: Send group members statu on alert

Re: Group View member nodes list

Anyone have any ideas or thoughts on how to do this? I keep getting an error: "MACRO SQL ERROR - Object reference not set to an instance of an object."

Find more posts tagged with

group status

email alerts

npm 12.2

Accepted answers

All comments

m-milligan

Which version of Orion and SAM are you using? This seems to be an error introduced in the latest update to Orion. I had similar alerts configured and working. After the upgrade, this error started appearing.

deverts

I saw a posting referencing this very issue, and yes, I'm on all latest versions. I was hoping I was doing something wrong.

jordan.swan

It looks like the latest Hotfix for the Orion Platform has fixed this issue.

I have not installed the hotfix yet, but I am planning on it soon and I will verify if this issue is fixed or not.

https://support.solarwinds.com/Success_Center/Network_Performance_Monitor_(NPM)/NPM_12.2_Hotfix_3

Orion Platform 2017.3 Hotfix 3 issues

SolarWinds Orion Platform 2017.3 Hotfix 3 addresses the following issues:

DPI / QoE overloads SQL database by queries
When agent deployment fails because VC++ runtime requires repair, the repair does not run automatically
Alerting: macro parsing issues
Cloud widgets not available in the Orion Web Console
NetFlow query failing in PerfStack
No default metrics for Azure VM in PerfStack
Load Average metrics not available in the default PerfStack template
Perfstack charts don't match associated statistics
User-defined dependencies are immediately auto-managed
In Diagnostics, the case ID field displays NetSuite ID, not the required SalesForce ID
The Manage Entities page shows a server error

deverts

jordan.swan,

Many thanks for the info, I saw in another posting it was available also. The issue now is...do I install the HF or just upgrade to 6.5? hhhmmm...

m-milligan

We installed the HF here last night, and it fixed this problem.