Query: Running Reports restricted to VERY short time window by WCS
Can anyone help, or am I just encountering a rather annoying performance issue in WCS?
Our network is 800 AP, typically 2000 unique users at the peak and I want to run a Detailed Client Report, specifying only protocol and Authentication as the required columns/data in the report. this is in order to to find out who is logging in using 802.11b so we can try and manage 802.11b off the network.
However when I run the report, specifying a time period of 4 weeks, the WCS comes back with an error telling me that there are too many records available and to reduce the serach criteria.
I have done this and find that the only useful report I get is one covering the last 5 days, which I think is pretty poor indeed. Am I missing some method of getting the WCS performance to improve to a level one would expect or is the product just poor at producing management information reports?
Re: Query: Running Reports restricted to VERY short time window
Did you ever find a solution to this? I run 220.127.116.11, and I'm encountering the same issue. If I try to run a Client Sessions report for anything longer than the last 2 weeks, WCS pops up a window saying, “The report you are trying to generate contains more than the supported number of records (100000). Change the report criteria to generate a report with fewer records.” For just the last 2 weeks, the total number of records is under 13,000, so I did some experimenting, and long story short, I discovered that I only encounter this problem if I try to run a long term report that includes any part of the last 7 days within the time frame.
What is it about the most recent 7 days' worth of data that is bogging down the report? I'm wondering if this has something to do with what's configured in Administration > Settings > Client. Here's what the documentation has to say about it:
In the Data Retention section, enter or edit the following data retention parameters. Client association
history can take a lot of database and disk space. This can be an problem for database backup and restore
functions. You can configure the retaining duration of a client association history to help manage this
· Client (days)—Enter the number of days that you want WCS to retain the data. The default is 7 days. The valid range is 1 to 365 days.
· Client (records)—Enter the number of client records that you want WCS to retain.
· Client session history (days)—The default is 31 days. The maximum is 365 days.
· Client session history (records)—The default (and maximum) is 1 million records.
Perhaps the "Client" records contain a lot more data and are included in the sessions report? The only problem is, there's no explanation of what the difference is between "Client" records and "Client session history" records. Does anyone know more about this? The documentation is a bit vague...