<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:"Segoe UI Light";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal" style="background:white">Hi Susan, <o:p></o:p></p>
<p class="MsoNormal" style="background:white"><o:p> </o:p></p>
<p class="MsoNormal" style="background:white">We simply send the syslog logs from our wireless controller to a logging solution. There are many free logging solutions available, but we use a paid for product called AlienVault. You can do the same for individual
Access Points, if you don’t have a centrally managed wireless solution. Once all the logs are centralized, you create a search for successful logins and then export the results into something like Excel. Some logging solutions are sophisticated enough to
produce nice looking reports, but most require some type of basic syntax language in order to effectively search the raw syslog’s for this level of detail.
<o:p></o:p></p>
<p class="MsoNormal" style="background:white"><o:p> </o:p></p>
<p class="MsoNormal" style="background:white">Since you’ll need a logging solution to accomplish this task, I suggest your research includes support for your specific wireless solution. For example, we have a Ruckus wireless solution, so when we researched
loggers one of our requirements was that the logger had the ability to identify and parse Ruckus Syslog events, and more importantly it could identify successful logons/access. This allows the logger to earmark these types of logon/access events specifically,
making your life easier to produce the desired reporting.<o:p></o:p></p>
<p class="MsoNormal" style="background:white"><o:p> </o:p></p>
<p class="MsoNormal" style="background:white">One solution you might want to look into is Splunk. They have a free version that is good for up to so much storage per day (storage in disk storage size, not number of events) and as long as you only point your
wireless to it, you should be well under the daily limit. As loggers go (and ya, loggers can get complicated) this is one of the ‘free’ loggers I found to be rather easy to use and produce the exact type of reports and dashboards you are looking for.<o:p></o:p></p>
<p class="MsoNormal" style="background:white"><o:p> </o:p></p>
<p class="MsoNormal" style="background:white">There are also third party cloud based solutions where you simply point your wireless users to an external proxy server and the cloud service will gather information and allow you to produce reports, but this will
result in an annual subscription cost. Depending on the cost, it may or may not be less expensive than supporting your own in house logging solution, even when considering labor alone as the upfront time to get a logger up and running, collecting logs and
producing results in a form that makes sense can be very time consuming. However, I have not personally researched cloud solutions…so I don’t have much insight to share.<o:p></o:p></p>
<p class="MsoNormal" style="background:white"><o:p> </o:p></p>
<p class="MsoNormal" style="background:white">Bottom line, I don’t see any reason why you would need additional hardware to accomplish this. Then again, I am not intimately acquainted with your network infrastructure.<o:p></o:p></p>
<p class="MsoNormal" style="background:white"><o:p> </o:p></p>
<p class="MsoNormal" style="background:white">I hope this information helps.<o:p></o:p></p>
<p class="MsoNormal" style="background:white"><o:p> </o:p></p>
<p class="MsoNormal" style="background:white">Pete Sneathen<o:p></o:p></p>
<p class="MsoNormal" style="background:white">I.T. Manager<o:p></o:p></p>
<p class="MsoNormal" style="background:white">Herrick District Library<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
<div>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">
<hr size="2" width="98%" align="center">
</span></div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black">
<a href="mailto:michlib-l-bounces@mcls.org">michlib-l-bounces@mcls.org</a> <<a href="mailto:michlib-l-bounces@mcls.org">michlib-l-bounces@mcls.org</a>> on behalf of aldenlib--- via Michlib-l <<a href="mailto:michlib-l@mcls.org">michlib-l@mcls.org</a>><br>
<b>Sent:</b> Tuesday, May 8, 2018 10:29 AM<br>
<b>To:</b> <a href="mailto:michlib-l@mcls.org">michlib-l@mcls.org</a><br>
<b>Subject:</b> Re: [Michlib-l] How do you gather Uses of Wireless Logins per Year for LOM Annual Report?</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">
<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
</div>
<div>
<p><em><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Here's my question and the replies I got:</span></em><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p></o:p></span></p>
<div>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Hi all,<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">I was told by my tech person that in order to track all wireless logins to our wifi, we'd have to get a separate router to do the job, as our current configuration won't pick that
data up; it just shows the hits to the website. Since the Library of Michigan Annual Report has recently been asking for that info (it was in Section H, line 13 this past year), I just estimated it from a clipboard at the front desk, where we note patrons
using their own laptops or tablets. But we're missing the users outside the building, phone use and whatnot that we don't notice. (We're a very small, Class I library.)<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Thanks for your help,<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">-- <o:p></o:p></span></p>
<p><em><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Susan Riegler</span></em><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Susan Riegler, Director<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Alden District Library<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Hi.<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">We used to use that same method. It was frustrating because we knew that we were missing a lot of people. <o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">I don't know the technical stuff, but we now have a "page" that when someone clicks on our wireless, pops up. There isn't a password, but they have to click on a box to agree to
our policy. The software counts that so we know how many sessions happen. A session can last up to 3 hours, then they will have to log back in again. We use "untangle" software.<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Ann<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Eau Claire District Library<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Your tech can't just pluck these out of the air (and be believed); we have an appliance that does this and we keep the reports for a couple years as proof.<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Attached is an example. Here is a good presentation given in SE Michigan a couple years ago; and not by me.<br>
<a href="http://tln.lib.mi.us/dept/technology-services/wifi/files/techcomm/Best_Practices_for_Wireless_Statistics.pdf" target="_blank">http://tln.lib.mi.us/dept/technology-services/wifi/files/techcomm/Best_Practices_for_Wireless_Statistics.pdf</a><o:p></o:p></span></p>
<div style="margin-bottom:15.0pt;overflow:auto" id="LPBorder_GT_15257902467250.007082685341794237">
<table class="MsoNormalTable" border="1" cellspacing="0" cellpadding="0" width="90%" style="width:90.0%;background:white;border-top:dotted #C8C8C8 1.0pt;border-left:none;border-bottom:dotted #C8C8C8 1.0pt;border-right:none">
<tbody>
<tr>
<td valign="top" style="border:none;padding:0in 0in 0in 0in">
<div id="LPTitle_15257902467210.2628936725225608">
<p class="MsoNormal" style="margin-top:15.0pt;mso-line-height-alt:15.75pt"><span style="font-size:16.0pt;font-family:"Segoe UI Light",sans-serif;color:#0096B7"><a href="http://tln.lib.mi.us/dept/technology-services/wifi/files/techcomm/Best_Practices_for_Wireless_Statistics.pdf" target="_blank"><span style="text-decoration:none">Best
Practices for Wireless Statistics - The Library Network</span></a><o:p></o:p></span></p>
</div>
<div style="margin-top:7.5pt;margin-bottom:12.0pt" id="LPMetadata_15257902467230.04658493916891593">
<p class="MsoNormal" style="margin-top:15.0pt;line-height:10.5pt"><span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;color:#666666">tln.lib.mi.us<o:p></o:p></span></p>
</div>
<div id="LPDescription_15257902467240.19814413632938455">
<p class="MsoNormal" style="margin-top:15.0pt;line-height:15.0pt"><span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;color:#666666">TLN Wireless Committee; 10/2013 Best Practices for Wireless Statistics The purpose of these guidelines is to suggest
a generalized standard for wireless usage statistics that are uniform<o:p></o:p></span></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">wishing you goodness,<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Mary Carleton; Farmington Community Library (<a href="mailto:Mary.Carleton@farmlib.org">Mary.Carleton@farmlib.org</a>) <o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">I read my lists from old school account.<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Hi Susan,<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">The Leelanau Township Library purchased a router and a contract with Sputnik (now part of a compnay called Lokket) to track wireless logins, connectivity. I didn't set up the contract
(the former director did) but it works just fine and I'm happy with the service. <br>
<a href="http://sputnik.com/" target="_blank">http://sputnik.com</a><br>
Nellie<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Hi Sue,<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">We use a company called Sputnik (sputnik.com) that supplies us with the routers (we use two so we can cover the library and meeting room). It counts Wi-Fi users and also provides
a "splash page" where users have to agree to our wireless use policy before they get onto the internet. Since we do not use internet filters and keep the Wi-Fi on 24/7 which can be accessed outside the building this splash page helps give us some legal protection
from improper use of the internet.<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Sputnik costs us about $200.00 per year and it hasn't given us any trouble.<o:p></o:p></span></p>
<p><em><b><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Mark Morton</span></b></em><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Director<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Leland Township Public Library<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">203 E Cedar St Leland, MI 49654<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">231-256-9152<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">We count the unique MAC addresses that our DHCP server hands out in a day. <o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">It sounds like your budget is limited.<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Do you have a firewall? So the low-tech/annoying solution is to have your firewall or (most) router make a splash page to use the wi-fi. Set a guest password, and change it once
a week or such. Then people will have to come get a slip to login, and you can physically count the users.<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Christian Dunham | Director<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Bullard Sanford Memorial Library<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">989-823-2171 | vassarlibrary.org | facebook.com/vassarlibrary<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Our Cisco Meraki wireless access point (MR 16?) has a dashboard of statistics that we can log into, info supplied includes number of unique users, devices accessing, operating systems,
applications accessed - loads if detail!<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">I used to have to leave that part of State Aid report blank. We're a class 4.<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">It does count sessions - not just number of unique users.<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"> --- jude halloran, Highland Library, 248-887-2218 ext. 110 <a href="http://www.highlandlibrary.info/" target="_blank">www.highlandlibrary.info</a><o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Hello Susan,<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Have you looked into any software solutions to help you count this? You might want to check out a service like Who's On My WiFi or reconfigure your router for the WiFi connection
counts and use something like Google Analytics to count your web traffic. I think you would probably be surprised how many external WiFi uses you get. <o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Thank you,<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Joseph Hamlin<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Library Data Coordinator<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Library of Michigan<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">702 West Kalamazoo St.<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">P.O. Box 30007<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Lansing, MI 48909-7507<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
</body>
</html>