urlscan.io logo urlscan.io
SecurityTrails logo

thwack.solarwinds.com Open in urlscan Pro
3.217.119.136  Public Scan

Back to summary
Submitted URL: https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/86855/wlc-thin-light-weight-access-point-...
Effective URL: https://thwack.solarwinds.com/products/network-performance-monitor-npm/f/forum/86855/wlc-thin-light-weight-access-point-serial...
Submission: On December 23 via api from US — Scanned from US

Form analysis 2 forms found in the DOM

<form>
  <fieldset class="search" id="header-100_searchFields">
    <ul class="field-list">
      <li class="field-item">
        <span class="field-item-description hidden">
          <label>Search</label>
        </span>
        <span class="field-item-input">
          <input class="search-input" autocomplete="off" type="search" placeholder="Search" aria-label="Search" id="header-100_Search" value="">
          <span class="mag-glass"></span>
        </span>
        <span class="search-close"></span>
      </li>
    </ul>
  </fieldset>
</form>

<form>
  <div id="mceu_8" class="mce-tinymce mce-container mce-panel mce-editor-submittable mce-editor-desktop mce-editor-blur mce-submitpanel-narrow" hidefocus="1" tabindex="-1" role="application"
    style="visibility: hidden; border-width: 1px; height: auto; overflow: visible;">
    <div id="mceu_8-body" class="mce-container-body mce-stack-layout">
      <div id="mceu_9" class="mce-container mce-menubar mce-toolbar mce-stack-layout-item mce-first" role="menubar" style="border-width: 0px 0px 1px; display: none;">
        <div id="mceu_9-body" class="mce-container-body mce-flow-layout">
          <div id="mceu_10" class="mce-widget mce-btn mce-menubtn mce-flow-layout-item mce-first mce-btn-has-text" tabindex="-1" aria-labelledby="mceu_10" role="menuitem" aria-haspopup="true"><button id="mceu_10-open" role="presentation"
              type="button" tabindex="-1"><span class="mce-txt">Edit</span> <i class="mce-caret"></i></button></div>
          <div id="mceu_11" class="mce-widget mce-btn mce-menubtn mce-flow-layout-item mce-btn-has-text" tabindex="-1" aria-labelledby="mceu_11" role="menuitem" aria-haspopup="true"><button id="mceu_11-open" role="presentation" type="button"
              tabindex="-1"><span class="mce-txt">Insert</span> <i class="mce-caret"></i></button></div>
          <div id="mceu_12" class="mce-widget mce-btn mce-menubtn mce-flow-layout-item mce-btn-has-text" tabindex="-1" aria-labelledby="mceu_12" role="menuitem" aria-haspopup="true"><button id="mceu_12-open" role="presentation" type="button"
              tabindex="-1"><span class="mce-txt">Format</span> <i class="mce-caret"></i></button></div>
          <div id="mceu_13" class="mce-widget mce-btn mce-menubtn mce-flow-layout-item mce-btn-has-text" tabindex="-1" aria-labelledby="mceu_13" role="menuitem" aria-haspopup="true"><button id="mceu_13-open" role="presentation" type="button"
              tabindex="-1"><span class="mce-txt">Table</span> <i class="mce-caret"></i></button></div>
          <div id="mceu_14" class="mce-widget mce-btn mce-menubtn mce-flow-layout-item mce-last mce-btn-has-text" tabindex="-1" aria-labelledby="mceu_14" role="menuitem" aria-haspopup="true"><button id="mceu_14-open" role="presentation" type="button"
              tabindex="-1"><span class="mce-txt">Tools</span> <i class="mce-caret"></i></button></div>
        </div>
      </div>
      <div id="mceu_18" class="mce-edit-area mce-container mce-panel mce-stack-layout-item mce-last" hidefocus="1" tabindex="-1" role="group" style="border-width: 0px 0px 1px; position: relative;"><iframe id="fragment-2268_fragment-2268_editor_ifr"
          frameborder="0" allowtransparency="true" title="Rich Text Area. Press ALT-F9 for menu. Press ALT-F10 for toolbar. Press ALT-0 for help" src="javascript:&quot;&quot;" style="width: 100%; height: 60px; display: block;"></iframe>
        <div style="position: absolute; top: 0px; left: 0px;">
          <div class="mceDragDropShade" style="position: absolute; display: none; left: 0px; top: 0px;"></div>
          <div class="mceDragDropMessage" style="position: absolute; display: none; left: 0px; top: 0px;"></div>
        </div>
      </div>
      <div id="mceu_15" class="mce-toolbar-grp mce-container mce-panel mce-stack-layout-item" hidefocus="1" tabindex="-1" role="group">
        <div id="mceu_15-body" class="mce-container-body mce-stack-layout">
          <div id="mceu_16" class="mce-container mce-toolbar mce-stack-layout-item mce-first mce-last" role="toolbar">
            <div id="mceu_16-body" class="mce-container-body mce-flow-layout">
              <div id="mceu_17" class="mce-container mce-flow-layout-item mce-first mce-last mce-btn-group" role="group" style="width: 100%;">
                <div id="mceu_17-body" style="white-space: normal;">
                  <div id="mceu_0" class="mce-widget mce-btn mce-menubtn mce-first mce-btn-has-text" tabindex="-1" aria-labelledby="mceu_0" role="button" aria-haspopup="true"><button id="mceu_0-open" role="presentation" type="button"
                      tabindex="-1"><span class="mce-txt">Edit</span> <i class="mce-caret"></i></button></div>
                  <div id="mceu_1" class="mce-widget mce-btn mce-menubtn mce-btn-has-text" tabindex="-1" aria-labelledby="mceu_1" role="button" aria-haspopup="true"><button id="mceu_1-open" role="presentation" type="button" tabindex="-1"><span
                        class="mce-txt">Insert</span> <i class="mce-caret"></i></button></div>
                  <div id="mceu_2" class="mce-widget mce-btn mce-menubtn mce-btn-has-text" tabindex="-1" aria-labelledby="mceu_2" role="button" aria-haspopup="true"><button id="mceu_2-open" role="presentation" type="button" tabindex="-1"><span
                        class="mce-txt">Format</span> <i class="mce-caret"></i></button></div>
                  <div id="mceu_3" class="mce-widget mce-btn mce-menubtn mce-btn-has-text" tabindex="-1" aria-labelledby="mceu_3" role="button" aria-haspopup="true"><button id="mceu_3-open" role="presentation" type="button" tabindex="-1"><span
                        class="mce-txt">Table</span> <i class="mce-caret"></i></button></div>
                  <div id="mceu_4" class="mce-widget mce-btn mce-menubtn mce-btn-has-text" tabindex="-1" aria-labelledby="mceu_4" role="button" aria-haspopup="true"><button id="mceu_4-open" role="presentation" type="button" tabindex="-1"><span
                        class="mce-txt">Tools</span> <i class="mce-caret"></i></button></div>
                  <div id="mceu_5" class="mce-widget mce-btn" tabindex="-1" aria-labelledby="mceu_5" role="button" aria-label="Bullet list"><button role="presentation" type="button" tabindex="-1"><i class="mce-ico mce-i-bullist"></i></button></div>
                  <div id="mceu_6" class="mce-widget mce-btn" tabindex="-1" aria-labelledby="mceu_6" role="button" aria-label="Numbered list"><button role="presentation" type="button" tabindex="-1"><i class="mce-ico mce-i-numlist"></i></button></div>
                  <div id="mceu_7" class="mce-widget mce-submitpanel mce-last" role="presentation" aria-haspopup="false"><span class="suggest-field"><input type="checkbox" id="fragment-2268_suggest" class="suggest"><label
                        for="fragment-2268_suggest">Suggest as Answer</label></span>
                    <div class="mce-widget mce-btn mce-primary mce-btn-has-text mce-submitpanel-button" id="mceu_7_send" tabindex="0" role="button"><button style="width:100%; height:100%;" tabindex="-1" type="button"><span
                          class="mce-txt">Reply</span></button></div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
    <div style="position: absolute; z-index: -1; height: 1px; width: 1px; overflow: hidden;"></div>
  </div><input type="file" multiple="" accept="" style="display: none;"><textarea id="fragment-2268_fragment-2268_editor" style="display: none;" aria-hidden="true"></textarea>
  <script type="text/javascript">
    jQuery(function() {
      jQuery('#fragment-2268_fragment-2268_editor').evolutionHtmlEditor({
        width: '100%',
        height: '60px',
        submittable: true,
        contentTypeId: 'f586769b-0822-468a-b7f3-a94d480ed9b0',
        enterToSubmitPrompt: 'Enter to Reply',
        submitLabel: 'Reply',
        beforeSubmitHtml: '\u003cspan class=\"suggest-field\"\u003e\u003cinput type=\"checkbox\" id=\"fragment-2268_suggest\" class=\"suggest\" /\u003e\u003clabel for=\"fragment-2268_suggest\"\u003eSuggest as Answer\u003c/label\u003e\u003c/span\u003e',
        afterSubmitHtml: '',
        placeholder: '',
        autoResize: true
      }).on('evolutionHtmlEditorSubmit', function(e) {
        (function() {
          jQuery.telligent.evolution.messaging.publish('telligent.evolution.widgets.thread.submit', {
            from: 'fragment-2268-nested'
          });
        })(e.html);
      });
    });
  </script>
</form>

Text Content

THWACK
 * Search

 * Sign In

 * Search




 * Community
   Community
   
   Find all you need to begin your THWACK journey, including documentation,
   missions, blogs, community groups, events, and media.
   
   Command Central
    * Getting Started
   
   MVP Program
    * MVP Program
   
   Monthly Mission
    * THWACK Wrapped Puzzle
   
   Blogs
    * Community Announcements
    * Product Blog
   
   Groups
    * DevOps Discourse
    * Data Driven
    * See All Groups
   
   Events
    * SolarWinds User Group
    * THWACKcamp
      * ↪ 2024: On Demand
    * Bracket Battle
   
   Media Vault
    * Movies & Mainframes
    * TechPod
    * THWACK Tech Tips
    * THWACK Livecast
    * SolarWinds Lab Archive
    * THWACKcamp Archive
    * See All Media

 * Products
   Products
   
   Find the best place to learn and ask questions about your SolarWinds
   products.
   
   Observability
    * Observability Solutions
    * SolarWinds Observability SaaS
    * SolarWinds Observability Self-Hosted
    * SolarWinds Platform
   
   Network Management
    * Network Performance Monitoring
    * NetFlow Traffic Analyzer
    * Network Configuration Manager
    * IP Address Manager
    * User Device Tracker
    * VoIP & Network Quality Manager
    * Log Analyzer
    * Engineer's Toolset
    * Network Topology Mapper
    * Kiwi CatTools
    * Kiwi Syslog Server
    * ipMonitor
   
   Application Management
    * AppOptics
    * Loggly
    * Papertrail
    * Pingdom
    * DevOps
   
   IT Security
    * Access Rights Manager
    * Identity Monitor
    * Security Event Manager
    * Patch Manager
    * Serv-U FTP & MFT
   
   IT Service Management
    * SolarWinds Service Desk
    * Web Help Desk
    * DameWare Remote Support
    * DameWare Remote Everywhere
    * DameWare Mini Remote Control
   
   System Management
    * Server & Application Monitor
    * Virtualization Manager
    * Storage Resource Monitor
    * Server Configuration Monitor
    * SolarWinds Backup
    * Web Performance Monitor
   
   Database Management
    * Database Performance Analyzer
    * SQL Sentry
    * Database Performance Monitor
    * Database Mapper
    * Task Factory

 * Content Exchange
   Content Exchange
   
   Find downloadable files and templates other users have built and found useful
   to share with others.
   
   SolarWinds Platform
    * Alerts
    * Custom HTML
    * Custom Queries
    * Modern Dashboards
    * Reports
    * Scripts
   
   Server & Application Monitor
    * API Pollers
    * Application Monitor Templates
   
   Database Performance Analyzer
    * Custom Alerts
    * Custom Metrics
    * Custom Queries
   
   Server Configuration Monitor
    * Policies
    * Profiles
   
   Network Performance Monitor
    * Device Pollers
    * Universal Device Pollers
   
   Network Configuration Manager
    * Config Change Scripts
    * Device Templates
    * Firmware Upgrade Templates
    * Policy Documents
   
   SQL Sentry
    * Advisory Conditions
   
   Web Help Desk
    * Style Sheets

 * Resources
   Customer Portal
   
   Create individual user accounts for your team, manage your licenses, download
   your SolarWinds software, create and track support tickets, and more.
   
   Academy
   
   A one-stop-shop for world-class training for SolarWinds products through
   on-demand videos, and instructor-led classes. All SolarWinds Academy content
   is included with every software purchase.
   
   Support
   
   Get help when you need it from a world-class support team, available to
   assist with technical product issues 24 hours a day, seven days a week, 365
   days a year.
   
   Partner Portal
   
   Accelerate SolarWinds Partners’ ability to drive digital and IT
   transformation for customers with powerful tools, resources, and increased
   profit potential.

 * Free Tools & Trials
 * Store


 * Products
 * 

Network Performance Monitor (NPM)
Forum WLC Thin [Light Weight] Access Point Serial Number. Display & Report?
 * Newsroom
 * Forum
 * Content Exchange
 * What We're Working On
 * Feature Requests
 * More

 * New




 * State Not Answered
 * Locked Locked
 * Replies 2 replies
 * Subscribers 37 subscribers
 * Views 3238 views
 * Users 0 members are here


Options
 * Share
 * 


Related
 * SWQL report to generate Serial and Model number of WAP devices
   Is there a script (SWQL) that can generate the WAP devices serial and model
   number?
 * Cradle Point Monitoring
   Does anyone monitoring cradlepoint devices using solawinds NPM OR SAM. Need
   to know the exact approach how the cradlepoint devices being monitored since
   they support API.
 * Trying to query number of devices by status. Getting false positives.
   So I'm brand spanking new to SWQL and SQL , I'm currently creating a
   Dashboard with a widget that'll allow me to see the number of devices with a
   status of Up, Down/Critical or Warning. I have all of my...
 * Does Message Center also search/display past or inactive alerts?
   We're trying to investigate an alert that we havebut we can't find it in
   Message Center. I suspect the reset condition has been met, so it no longer
   appears in the active alerts.. but I also can't find...
 * External Web access (through load balancer or public URL) to Solarwinds web
   console
   I have setup an additional web server and through it the web console works
   fine. On top of AWS, I am trying to setup load balancer with WAF, but when I
   access the URL through LB IP or hostname, some...


This discussion has been locked. The information referenced herein may be
inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar
question you can start a new discussion in this forum.


WLC THIN [LIGHT WEIGHT] ACCESS POINT SERIAL NUMBER. DISPLAY & REPORT?


dc4networks over 6 years ago

Fellow THWACK’sters,



I have been fortunate enough to find the OID shown below that I have now
assigned to the 12 Cisco 5500 Series WLCs via the UnDP App on the Main Poller.



                MIB Name:     AIRSPACE-WIRELESS-MIB: bsnAPSerialNumber

                OID:                1.3.6.1.4.1.14179.2.2.1.1.17

                Description:     "AP Serial Number."



When testing this OID against each of the WLCs, there was the full List of the
Thin [Light Weight] Access Points that are connected to the WLC Shown with their
Serial Number.



Task 1; Find and Test Thin [Light Weight] Serial No. OID; DONE.


Task 2a; Display the Thin [Light Weight] Serial No.’s for all of the Thin [Light
Weight] Access Points on the WLC Node Page?



Task 2b; Display the Thin [Light Weight] Serial No.’s on the Thin [Light Weight]
Access Points Node Page?

This will probably only be possible if the Thin [Light Weight] Access Point is
also a Polled Node by ICMP and there is a ‘binding’
within the SQL Database with the Access Point IP Address… Maybe?



Task 3; Add the Thin [Light Weight] Access Point Serial Number to the Nodes
Bespoke SQL Inventory Report that is ran on the 1st of Each Calendar Month.

We may need to Add All of the Thin [Light Weight] Access Point Nodes to the
Nodes being Monitored and Polled by SolarWinds.

However, I may find the Table/s and Column/s within the SolarWinds SQL Database
that can be joined to the Bespoke SQL Inventory Report that is ran…



Can any of you fellow THWACK’sters Help Me with the Tasks shown above?



Please do not hesitate to ask for any further clarification.



Thank you in advance for your help.







STATUS UPDATE 1…



I have found the Thin [Light Weight] Access Points within the 2 Tables
Following;



     [dbo].[Wireless_AccessPoints_View]

     [dbo].[Wireless_AccessPoints]



And the UnDP has been found within the Tables as shown below.



     [dbo].[CustomPollers]

     [dbo].[CustomPollerAssignmentView]



However, this UnDP is shown Assigned to only to the 12 WLCs. (No Surprise).





          [dbo].[Wireless_AccessPoints_View]  = NodeID =
[dbo].[CustomPollerAssignmentView]



          Where the NodeID is the NodeID of one of the 12 WLCs.



Is there a Table that will show the Thin [Light Weight] Access Points Serial
Number, that will share a Common ID with one of the Tables show above?



Or any other Table for that matter?





STATUS UPDATE 2...



In addition to the other THWACK Posts I believe to be related to this issue I
have reviewed the OID Assignment via the UnDP App again to find that there is a
'Row ID' Column and 'Test Result' Column shown.



Assumptions...



The 'Row ID' Column contains a Unique Number in linked to the Thin [Light
Weight] Access Point Serial Number shown within the 'Test Result' Column.



Where is the Table with this information to then 'LEFT JOIN' to the Bespoke SQL
Inventory Report?





STATUS UPDATE 3...



After some changes to the SQL Script Found with the THWACK Post;

Cisco Wireless Lan Contoller Serial Number Report (SQL Query, Required Custom
Poller)



I have had some progress.



The progress being that it appears that the Cisco Thin [Light Weight] Access
Point Serial Numbers are being shown using the SQL Script shown below.



However the Description, IP Address, Machine Type and Node Names are the Cisco
5500 Series Wireless Controllers and not that of the Cisco Thin [Light Weight]
Access Points.



SELECT DISTINCT
CustomNodePollerStatus_CustomPollerStatus.Status AS Serial_Number,
Nodes.Vendor AS Vendor,
Nodes.Description as Description,
Nodes.IP_Address AS IP_Address,
Nodes.MachineType AS Machine_Type,
Nodes.Caption AS Node_Name,
CustomPollers_CustomPollers.UniqueName as Poller_Name

FROM
(Nodes LEFT JOIN CustomPollerAssignment
CustomNodePollerAssignment_CustomPollerAssignment
ON (Nodes.NodeID = CustomNodePollerAssignment_CustomPollerAssignment.NodeID))

LEFT JOIN CustomPollerStatus CustomNodePollerStatus_CustomPollerStatus
ON (CustomNodePollerAssignment_CustomPollerAssignment.CustomPollerAssignmentID =
CustomNodePollerStatus_CustomPollerStatus.CustomPollerAssignmentID)

LEFT JOIN CustomPollers CustomPollers_CustomPollers
ON (CustomNodePollerAssignment_CustomPollerAssignment.PollerID =
CustomPollers_CustomPollers.PollerID)

WHERE
(( Nodes.Vendor = 'Cisco') AND (CustomPollers_CustomPollers.UniqueName =
'bsnAPSerialNumber'))

ORDER by Node_Name Desc



When I get the Cisco Thin [Light Weight] Access Points Details output from the
SQL Database I intend to replace this Script.



In the meantime if there is another THWACK'ster out there who can add the
appropriate THWACK Post URL



or would like to make the appropriate changes to the SQL Script,



where we can also still see the Cisco 5500 Series WLC that the LWAP is Managed
by within the Report.



Thank you in advance for your support.



My Next Steps;

I will be reviewing the full content of each Table referenced within the Script
above.

All being well I will find what I am looking for to be added to the Cisco Light
Weight Access Points Report.



Message was edited by: Dan Collins Again, Again and Again...


attachments.zip



TOP REPLIES

 * dc4networks over 6 years ago in reply to ericmarshott +1
   ericmarshott, Thank you for asking. I am still working on it but not full
   time, hence the delay. It is getting the right SQL Table JOINs to get the
   correct output. On some trials it is the IP and MAC Addresses…


 * Oldest
 * Votes
 * Newest

 * 0 ericmarshott over 6 years ago
   
   dc4networks were you able to amend the query to pull AP details (e.g AP name)
   for each serial number?
   
   
   
   
   
   
   
   
   * 0 dc4networks over 6 years ago in reply to ericmarshott
     
     ericmarshott,
     
     
     
     Thank you for asking.
     
     
     
     I am still working on it but not full time, hence the delay.
     
     
     
     It is getting the right SQL Table JOINs to get the correct output.
     
     
     
     On some trials it is the IP and MAC Addresses of the Clients connected via
     the Access Points.
     
     
     
     When I get it right I will get it Posted and I will send you a message.
     
     
     
     Do you have any feedback that may help?
     
     
     
     Cheers,
     
     DC4Networks
     
     
     
     
     
     
     
     

Edit
Insert
Format
Table
Tools

Edit
Insert
Format
Table
Tools


Suggest as Answer
Reply







SolarWinds solutions are rooted in our deep connection to our user base in the
THWACK® online community. More than 200,000 members are here to solve problems,
share technology and best practices, and directly contribute to our product
development process.


SolarWinds Customer Success Center Certification SolarWinds Lab Link Accounts
About THWACK Blogs Federal & Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security
Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.


Quote
SolarWinds uses cookies to enhance site navigation, analyze site usage and
assist with our marketing efforts. By clicking "Accept All Cookies", you agree
to our use of cookies on your device in accordance with our Cookie Policy. For
more information on how we process your data, refer to ourSolarWinds Privacy
Notice
Accept All Cookies
Cookie Settings




PRIVACY PREFERENCE CENTER




 * YOUR PRIVACY


 * STRICTLY NECESSARY COOKIES


 * FUNCTIONAL COOKIES


 * PERFORMANCE COOKIES


 * TARGETING COOKIES

YOUR PRIVACY

When you visit any SolarWinds website, we may store or retrieve information on
your browser, mostly in the form of cookies. This information might be about
you, your preferences or your device and is mostly used to make the site work as
you expect it to. The information does not usually directly identify you, but it
can give you a more personalized web experience. Because we respect your right
to privacy, you can choose not to allow some types of cookies. Click on the
different category headings to find out more and change our default settings.
However, blocking some types of cookies may impact your experience of the site
and the services we are able to offer. For more information on cookies, see our
Cookie Policy

STRICTLY NECESSARY COOKIES

Always Active

These cookies are necessary for the website to function and cannot be switched
off in our systems. They are usually only set in response to actions made by you
which amount to a request for services, such as setting your privacy
preferences, logging in or filling in forms.    You can set your browser to
block or alert you about these cookies, but some parts of the site will not then
work. These cookies do not store any personally identifiable information.

FUNCTIONAL COOKIES

Functional Cookies


These cookies enable the website to provide enhanced functionality and
personalisation. They may be set by us or by third party providers whose
services we have added to our pages.    If you do not allow these cookies then
some or all of these services may not function properly.

PERFORMANCE COOKIES

Performance Cookies


These cookies allow us to count visits and traffic sources so we can measure and
improve the performance of our site. They help us to know which pages are the
most and least popular and see how visitors move around the site.    All
information these cookies collect is aggregated and therefore anonymous. If you
do not allow these cookies we will not know when you have visited our site, and
will not be able to monitor its performance.

TARGETING COOKIES

Targeting Cookies


These cookies may be set through our site by our advertising partners. They may
be used by those companies to build a profile of your interests and show you
relevant adverts on other sites.    They do not store directly personal
information, but are based on uniquely identifying your browser and internet
device. If you do not allow these cookies, you will experience less targeted
advertising.

Back Button


COOKIE LIST

Filter Button
Consent Leg.Interest
checkbox label label
checkbox label label
checkbox label label

Clear
checkbox label label
Apply Cancel
Confirm My Choices
Allow All