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 .zip file (the .zip file unzips to a .csv file 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. 
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 2 from that total (for the 2 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: