The closest I've been able to wrangle out of the report tool is the following:
*Run a Client Count report *Report by: AP By Floor Area *Report Criteria: (You can limit to certain campuses, buildings, or floors at this point) *Connection Protocol: (Default is fine, select 802.11a/n or 802.11b/g/n if you don't want to sort out base radios MACs later) *SSID: All SSIDs: *Reporting Period: the period of interest *Export Format: CSV <- this is key Have it email you such a report and you'll get back a CSV table of AP Names, Base Radio MACs, Time slice, Associated Count, and Authenticated Count. You'll then have to do some basic Excel magic to get your average, min and max, but that shouldn't be hard. Remember that the data gets averaged at various time points, so if you want very good data you should be spitting this report out daily and then doing post processing on them as NCS quasi-averaged values on month+ old data isn't very useful for anything but trend analysis. I hope this was helpful. If no one comes back with a better way, we should each put this in as a feature request to our local cisco account folks. An easy to generate Min/95th/Max report for APs would be very handy. -Luke =-=-=-=-=-=-=-=-=-=-=-= Luke Jenkins Network Engineer Weber State University On Apr 29, 2012, at 11:27 PM, Peter Arbouin wrote: > Hi, > > Does anyone know if there is a report in Cisco NCS that lists the minimum, > average, maximum client associations per access-point for a given period of > time? > We do a monthly report and for capacity planning would like to know which > access points have the most clients associated. > > I know that you can see this info per access point in the monitor view, but > have not been able to find a report that meets our requirements. > > > We were hoping for something like this: > > AP Name > Average > Minimum > Maximum > gps04-ap05 > 12 > 0 > 102 > gpb01-ap03 > 10 > 0 > 95 > gpo04-ap01 > 9 > 0 > 87 > gpb01-ap04 > 10 > 0 > 87 > gpap-v0304 > 4 > 0 > 84 > > > Peter. > > Peter Arbouin | Network Engineer > Network Operations Centre | Information Technology Services > Queensland University of Technology > Level 3 | 88 Musk Avenue | Kelvin Grove Campus > Mob: 0402476892 | Ph: +61 7 3138 1030 > Email: [email protected] > > CRICOS No. 00213J > > ********** Participation and subscription information for this EDUCAUSE > Constituent Group discussion list can be found > athttp://www.educause.edu/groups/. > ********** Participation and subscription information for this EDUCAUSE Constituent Group discussion list can be found at http://www.educause.edu/groups/.
