You are here

Enterprise Wireless Reports

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: