nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
- SolarWinds Academy
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

SWQL report to generate Serial and Model number of WAP devices

junerenab

Is there a script (SWQL) that can generate the WAP devices serial and model number?

Find more posts tagged with

Comments

junerenab

Oh I see yeah it might be a on the MIBs will try to search if there is another than can show the Definition. Thank you very much

stuartd

Honestly I don't know. Somebody better versed in UnDPs may know but I don't.

junerenab

Hi Stuartd,

Good day to you!

I have one question our leadership wants to include the WAP Status and able to setup the MIB on the UDP using bsnAPOperationStatus' => '1.3.6.1.4.1.14179.2.2.1.1.6' and added to the report. Is there way to show the Status definition such as associated instead of number only? Thank you

bsnAPOperationStatus Definition
'1' => 'associated'
'2' => 'disassociating'
'3' => 'downloading'

stuartd

Ahh yes - apologies. That one was written in SQL but glad you got it working.

junerenab

Hi Stuartd,

It's working now using SQL good thing I was able to read some of your old post. Thank you very much

junerenab

Hi Stuartd,

The OIDS or UDP are already set it's just the report that I can't make it work, tried the script but getting Query is not Valid. Thanks

stuartd

So, you can do this but it is a two step process.

You need to create a UnDP (and assign it) to extract the serial numbers from the WLC. The second step is you need to then create a custom SWQL report to list the details out.

For Cisco WLC's the OID we've been using is: 1.3.6.1.4.1.14179.2.2.1.1.17 - so go and create your UnDP (https://solarwindscore.my.site.com/SuccessCenter/s/article/Create-a-Universal-Device-Poller-UnDP?language=en_US) and these are the options we've used:

Then you need to create your repot.

The code we used is:

/* 
Query to get AP Information from the Controllers through the use of UnDPs, because APs are not nodes in Solarwinds but an extra to the Controllers
*/
SELECT DISTINCT (n.caption) AS 'Controller'
	,t1.STATUS AS 'AP Name'
	,t2.STATUS AS 'Serial number'
	,t3.STATUS AS 'Model number'
	,t4.STATUS AS 'Software'
	,t5.STATUS AS 'IP Address'
	,npm.Client
FROM CustomPollerStatus AS cps
JOIN CustomPollerASsignment AS cpa ON cps.CustomPollerASsignmentID = cpa.CustomPollerASsignmentID
JOIN Nodes AS n ON n.NodeID = cpa.NodeID
JOIN NodesCustomProperties AS npm ON npm.NodeID = n.NodeID
JOIN (
	SELECT cps.STATUS
		,cps.CustomPollerASsignmentID
		,cps.RowID
	FROM CustomPollerStatus AS cps
	JOIN CustomPollerASsignment AS cpa ON cps.CustomPollerASsignmentID = cpa.CustomPollerASsignmentID
	JOIN Nodes AS n ON n.NodeID = cpa.NodeID
	WHERE cpa.ASsignmentName LIKE 'bsnAPName%'
	) AS t1 ON cps.RowID = t1.RowID
JOIN (
	SELECT cps.STATUS
		,cps.CustomPollerASsignmentID
		,cps.RowID
	FROM CustomPollerStatus AS cps
	JOIN CustomPollerASsignment AS cpa ON cps.CustomPollerASsignmentID = cpa.CustomPollerASsignmentID
	JOIN Nodes AS n ON n.NodeID = cpa.NodeID
	WHERE cpa.ASsignmentName LIKE 'bsnAPSerialNumber%'
	) AS t2 ON cps.RowID = t2.RowID
JOIN (
	SELECT cps.STATUS
		,cps.CustomPollerASsignmentID
		,cps.RowID
	FROM CustomPollerStatus AS cps
	JOIN CustomPollerASsignment AS cpa ON cps.CustomPollerASsignmentID = cpa.CustomPollerASsignmentID
	JOIN Nodes AS n ON n.NodeID = cpa.NodeID
	WHERE cpa.ASsignmentName LIKE 'bsnAPModel%'
	) AS t3 ON cps.RowID = t3.RowID
JOIN (
	SELECT cps.STATUS
		,cps.CustomPollerASsignmentID
		,cps.RowID
	FROM CustomPollerStatus AS cps
	JOIN CustomPollerASsignment AS cpa ON cps.CustomPollerASsignmentID = cpa.CustomPollerASsignmentID
	JOIN Nodes AS n ON n.NodeID = cpa.NodeID
	WHERE cpa.ASsignmentName LIKE 'bsnAPSoftwareVersion%'
	) AS t4 ON cps.RowID = t4.RowID
JOIN (
	SELECT cps.STATUS
		,cps.CustomPollerASsignmentID
		,cps.RowID
	FROM CustomPollerStatus AS cps
	JOIN CustomPollerASsignment AS cpa ON cps.CustomPollerASsignmentID = cpa.CustomPollerASsignmentID
	JOIN Nodes AS n ON n.NodeID = cpa.NodeID
	WHERE cpa.ASsignmentName LIKE 'bsnApIpAddress%'
	) AS t5 ON cps.RowID = t5.RowID
ORDER BY 'AP Name' ASC

You may need to edit the report code as we used several UnDP names to get a little more info returned. If you change your UnDP names from the default, then you will need to edit them in the above code.

We named ours:

bsnApIpAddress - OID: 1.3.6.1.4.1.14179.2.2.1.1.19
bsnAPModel - OID: 1.3.6.1.4.1.14179.2.2.1.1.16
bsnAPName - OID: 1.3.6.1.4.1.14179.2.2.1.1.3
bsnAPSerialNumber - OID: 1.3.6.1.4.1.14179.2.2.1.1.17
bsnAPSoftwareVersion - OID: 1.3.6.1.4.1.14179.2.2.1.1.8

Quick Links

PALO-ALG - Logging
PALO-ALG - Logging.xmlPalo Alto Networks ALG Security Technical Implementation Guide :: Version 2, Release: 3 Benchmark Date: 27 Oct 2022
Alert HTML Content
Alert Cleared.htmlHello, I would like to share the HTML template details we have prepared so that Solarwinds alarms can become more meaningful. It can list alarm object details and connected device details separately in HTML template. Except for object and device details, you can easily add custom property information…
Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices
Basic SWQL Syntax
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…