Re: [WIRELESS-LAN] Cisco WCS statistics
Attached is an example of how we are graphing. This graph is one of five on a page showing the number of users using each of our WLANs. This page allows us to select whatever time interval we want graphed (the attached graph is for a 24 hour period). Future plans are to graph the number of users on each radio on all of our 550+ APs. We will add to these as we need new information. As far as the data we are harvesting from the controllers, we are gathering information on the controllers, APs, radios, WLANs, and Rogue APs. We have several search and report pages that use the information from the database. On Wed, 29 Nov 2006, David Wang @ UoG CCS wrote: Date: Wed, 29 Nov 2006 13:52:24 -0500 From: David Wang @ UoG CCS [EMAIL PROTECTED] Reply-To: 802.11 wireless issues listserv WIRELESS-LAN@LISTSERV.EDUCAUSE.EDU To: WIRELESS-LAN@LISTSERV.EDUCAUSE.EDU Subject: Re: [WIRELESS-LAN] Cisco WCS statistics Thanks Todd, I am interested with what kind of graphing you have now. Do you mind share some screenshots or demo? David Wang, Networking Services,CCS www.uoguelph.ca 519-824-4120 x52046 Todd M. Hall wrote: WCS does not provide very customizable statistics. We have found that the best way to get what we want is to write it ourselves. We get our data directly from the controllers via snmp. We store some of the information in a mysql database for reports and the rest of the data is stored in rrd files for graphing. We still have lots to do, but we are making progress. The snmp mibs are downloadable from Cisco's website. On Wed, 29 Nov 2006, David Wang @ UoG CCS wrote: Date: Wed, 29 Nov 2006 09:43:22 -0500 From: David Wang @ UoG CCS [EMAIL PROTECTED] Reply-To: 802.11 wireless issues listserv ** Participation and subscription information for this EDUCAUSE Constituent Group discussion list can be found at http://www.educause.edu/groups/. -- Todd M. Hall Network Analyst Information Technology Infrastructure Mississippi State University [EMAIL PROTECTED] 662-325-0728 (phone) ** Participation and subscription information for this EDUCAUSE Constituent Group discussion list can be found at http://www.educause.edu/groups/. WLAN_users.png Description: Binary data
Re: [WIRELESS-LAN] Cisco WCS statistics
The frustrating part is that this detail is available in WLSE in Cisco's autonomous line- why the LWAPP system would leave these details out is a bit bewildering. (This is not an invitation for Airwave to call me.) Hopefully we see improvements in this area from Cisco very, very soon. Lee [EMAIL PROTECTED] 11/29/2006 2:06 PM Attached is an example of how we are graphing. This graph is one of five on a page showing the number of users using each of our WLANs. This page allows us to select whatever time interval we want graphed (the attached graph is for a 24 hour period). Future plans are to graph the number of users on each radio on all of our 550+ APs. We will add to these as we need new information. As far as the data we are harvesting from the controllers, we are gathering information on the controllers, APs, radios, WLANs, and Rogue APs. We have several search and report pages that use the information from the database. On Wed, 29 Nov 2006, David Wang @ UoG CCS wrote: Date: Wed, 29 Nov 2006 13:52:24 -0500 From: David Wang @ UoG CCS [EMAIL PROTECTED] Reply-To: 802.11 wireless issues listserv WIRELESS-LAN@LISTSERV.EDUCAUSE.EDU To: WIRELESS-LAN@LISTSERV.EDUCAUSE.EDU Subject: Re: [WIRELESS-LAN] Cisco WCS statistics Thanks Todd, I am interested with what kind of graphing you have now. Do you mind share some screenshots or demo? David Wang, Networking Services,CCS www.uoguelph.ca 519-824-4120 x52046 Todd M. Hall wrote: WCS does not provide very customizable statistics. We have found that the best way to get what we want is to write it ourselves. We get our data directly from the controllers via snmp. We store some of the information in a mysql database for reports and the rest of the data is stored in rrd files for graphing. We still have lots to do, but we are making progress. The snmp mibs are downloadable from Cisco's website. On Wed, 29 Nov 2006, David Wang @ UoG CCS wrote: Date: Wed, 29 Nov 2006 09:43:22 -0500 From: David Wang @ UoG CCS [EMAIL PROTECTED] Reply-To: 802.11 wireless issues listserv ** Participation and subscription information for this EDUCAUSE Constituent Group discussion list can be found at http://www.educause.edu/groups/. -- Todd M. Hall Network Analyst Information Technology Infrastructure Mississippi State University [EMAIL PROTECTED] 662-325-0728 (phone) ** Participation and subscription information for this EDUCAUSE Constituent Group discussion list can be found at http://www.educause.edu/groups/. ** Participation and subscription information for this EDUCAUSE Constituent Group discussion list can be found at http://www.educause.edu/groups/.
Re: [WIRELESS-LAN] Cisco WCS statistics
Hi David, If your currently running MRTG or similar, can get authenticated clients with the MIB: 1.3.6.1.4.1.14179.2.1.1.1.38.1 for Wireless LAN Controllers, MIB for a Cisco FAT Access Points is 1.3.6.1.4.1.9.9.273.1.1.2.1.1.1. Doing twice will give the green with blue highlight Target[name-of-device.1]: 1.3.6.1.4.1.14179.2.1.1.1.38.11.3.6.1.4.1.14179.2.1.1.1.38.1:[EMAIL PROTECTED] This shows the authenticated clients on the Wireless LAN Controller, or if Target is a FAT Access Point, authenticated clients on that Access Point. If you wanted clients for each lwap off the Wireless LAN Controller, can get by appending the ethernet address of the lwap to the following MIB: 1.3.6.1.4.1.14179.2.2.2.1.15, ethernet address has to be in decimal though. 1.3.6.1.4.1.14179.2.2.2.1.15.decimal-Ethernet-Address-of-lwap ~example; if ethernet address of lwap in HEX is 00:0b:85:76:ed:40, decimal would be 0.11.133.118.237.64 would then need to snmp query on: 1.3.6.1.4.1.14179.2.2.2.1.15.0.11.133.118.237.64.1 off the Wireless LAN Controller address Target[name-of-device.1]: 1.3.6.1.4.1.14179.2.2.2.1.15.0.11.133.118.237.64.11.3.6.1.4.1.14179.2.2.2.1.15.0.11.133.118.237.64.1:[EMAIL PROTECTED] With old style MRTG log files can also call a script from MRTG configuration file, add all the authenticated clients together, store in a new log file and graph these. Here Blue is access points, lwap and FAT, Green is authenticated clients. thanks! jim - Original Message - From: David Wang @ UoG CCS [EMAIL PROTECTED] To: WIRELESS-LAN@LISTSERV.EDUCAUSE.EDU Sent: Wednesday, November 29, 2006 1:52 PM Subject: Re: [WIRELESS-LAN] Cisco WCS statistics Thanks Todd, I am interested with what kind of graphing you have now. Do you mind share some screenshots or demo? David Wang, Networking Services,CCS www.uoguelph.ca 519-824-4120 x52046 Todd M. Hall wrote: WCS does not provide very customizable statistics. We have found that the best way to get what we want is to write it ourselves. We get our data directly from the controllers via snmp. We store some of the information in a mysql database for reports and the rest of the data is stored in rrd files for graphing. We still have lots to do, but we are making progress. The snmp mibs are downloadable from Cisco's website. On Wed, 29 Nov 2006, David Wang @ UoG CCS wrote: Date: Wed, 29 Nov 2006 09:43:22 -0500 From: David Wang @ UoG CCS [EMAIL PROTECTED] Reply-To: 802.11 wireless issues listserv ** Participation and subscription information for this EDUCAUSE Constituent Group discussion list can be found at http://www.educause.edu/groups/. ** Participation and subscription information for this EDUCAUSE Constituent Group discussion list can be found at http://www.educause.edu/groups/. strwlc01.net.iup.edu.1-day.png Description: PNG image totalapusers-month.png Description: PNG image
Re: [WIRELESS-LAN] Cisco WCS statistics
If the mibs are installed, you can use these... Users per AP interface is as follows: enterprises.airespace.bsnWireless.bsnAP.bsnAPIfTable.bsnAPIfEntry.bsnAPIfPhyTxPowerLevel. Users per WLAN per controller: enterprises.airespace.bsnWireless.bsnEss.bsnDot11EssTable.bsnDot11EssEntry.bsnDot11EssNumberOfMobileStations. Of course, each of these is followed by index values. You can also gather the following information (as well as lots more) Radio channel number Radio transmit power level AP Oper status AP Admion status AP info: name, ethernet mac, location field (we use this to hold inventory info), model, serial number, certificate type. User information: mac address, username, interface used, etc Rogue AP information: ssid, channel, radio type, which internal APs detected it Once all this is stored, you can generate some very useful statistics pages and search pages. For instance, I had a Cisco engineer tell me of a flaw and work around on particular AP model. I can tell where they are in seconds. At a glance, I can see how many APs are on each controller on one page. No more looking at each controller separately in WCS. Note: I received a phone call from someone at Airwave today, I suspect as a result of my posts to this group. On Wed, 29 Nov 2006, David Wang @ UoG CCS wrote: Date: Wed, 29 Nov 2006 15:40:02 -0500 From: David Wang @ UoG CCS [EMAIL PROTECTED] Reply-To: 802.11 wireless issues listserv WIRELESS-LAN@LISTSERV.EDUCAUSE.EDU To: WIRELESS-LAN@LISTSERV.EDUCAUSE.EDU Subject: Re: [WIRELESS-LAN] Cisco WCS statistics Again thanks for sharing Todd. I am digging into these controller MIB files now. Is possible to gather associated user number for each AP (per-ap-interface)? David Wang, Networking Services,CCS www.uoguelph.ca 519-824-4120 x52046 Todd M. Hall wrote: Attached is an example of how we are graphing. This graph is one of five on a page showing the number of users using each of our WLANs. This page allows us to select whatever time interval we want graphed (the attached graph is for a 24 hour period). Future plans are to graph the number of users on each radio on all of our 550+ APs. We will add to these as we need new information. As far as the data we are harvesting from the controllers, we are gathering information on the controllers, APs, radios, WLANs, and Rogue APs. We have several search and report pages that use the information from the database. On Wed, 29 Nov 2006, David Wang @ UoG CCS wrote: Date: Wed, 29 Nov 2006 13:52:24 -0500 From: David Wang @ UoG CCS [EMAIL PROTECTED] Reply-To: 802.11 wireless issues listserv ** Participation and subscription information for this EDUCAUSE Constituent Group discussion list can be found at http://www.educause.edu/groups/. -- Todd M. Hall Network Analyst Information Technology Infrastructure Mississippi State University [EMAIL PROTECTED] 662-325-0728 (phone) ** Participation and subscription information for this EDUCAUSE Constituent Group discussion list can be found at http://www.educause.edu/groups/.