Enterprise Wireless Usage Reports
- are emailed out on the first of each month
- contain usage information for the previous 31 days (this is a change from our previous software, which sent reports for the previous calendar month)
- are sent from SCLSWifiReports@scls.info
- have a subject line of “Report: Client Sessions - <agy> - Client Sessions” (where <agy> = your library’s 3-letter delivery code)
- arrive as a .csv or .zip file (a .zip file will unzip to multiple .csv files which can be opened in Excel)
- contain this information:
- Client Username –
- blank for users of the “Library-Wireless” signal
- (in the future) will display the username or computer name for users of the “Staff” signal
- Client IP Address – IP address of the connecting device
- Client MAC Address – hardware address/identifier of the connecting device’s network card
- Association Time – date and time the user connected to the wireless signal
- Vendor – vendor of the device’s network card (cannot always be identified)
- SSID – wireless signal to which the user connected
- Protocol – wireless protocol used by the connected user’s device
- Session Duration – how long the user was connected
How to use this report
Most simply, this report can be used as a count of total number of wireless sessions at your library.
Note: Each .csv file contains a maximum number of 15,000 sessions. If your library has more than 15,000 sessions, you will receive multiple .csv files contained in a .zip file. You will need to unzip the .zip file and follow these instructions for ALL of the .csv files.
To determine the total session count
- Remove any lines that are not dated from the previous month
- The report contains 31 days of data.
- Not all months have 31 days, so some entries may be for the month before the previous month.
- Scroll to the bottom of the spreadsheet
- Look at the number of lines with data
- Subtract 8 from that total (for the 8 header lines)
- The resulting number is the total wireless sessions for your library
Other ways of counting wireless use
Ben Miller (SKC) has written up a process for counting the number of unique devices have connected to Enterprise Wireless using pivot tables in Excel. (pdf)
For more information, contact: