Rogue Access Point Alert - Variables to show SSID and MAC address in Alert message?

I'm setting up the pre-configured alert in NPM under Advanced Alerts for "Alert me when a Rogue access point is detected"

I am having it email me an alert.

In the alert text, what is the variable to show the Rogue Access Point SSID and MAC Address?

Find more posts tagged with

rogue_access_point

Alerts

variable

Accepted answers

Capt._Obvious

Try these:

SSID: ${SQL: select Rogue_SSID from NPM_NV_WL_REPORT_Rogues_V where npmnodeid = ${NPMNodeID}}

MAC Address: ${SQL: select Rogue_MACAddress from NPM_NV_WL_REPORT_Rogues_V where npmnodeid = ${NPMNodeID}}

All comments

Capt._Obvious

Try these:

SSID: ${SQL: select Rogue_SSID from NPM_NV_WL_REPORT_Rogues_V where npmnodeid = ${NPMNodeID}}

MAC Address: ${SQL: select Rogue_MACAddress from NPM_NV_WL_REPORT_Rogues_V where npmnodeid = ${NPMNodeID}}

ts_tech

After turning on the alert, I got few messages say "Alert me when a rogue access point is detected" with the object name appears to be an SSID. When I opened the alert message, nothing shwon.

What does this alert mean? how can I get more detail about this?

Thanks

ts_tech

One more thing. How does NPM identify an AP is "Rogue"?

FormerMember

hey! after we applied an orion NPM update recently, that alert syntax stopped working.

The support department at Solarwinds helped me create a new one with this syntax:

Rogue Access Point Count: ${RogueAPsCount}

SSID: ${SQL: select Rogue_SSID from NPM_NV_WL_REPORT_Rogues_V where npmnodeid = ${NPMNodeID}}

MAC Address: ${SQL: select Rogue_MACAddress from NPM_NV_WL_REPORT_Rogues_V where npmnodeid = ${NPMNodeID}}

FormerMember

also, not exactly sure what their definition of rogue is... sorry

bshopp

We don't do anything special for rogue, we report back what the controller detects and reports