Small W2K network--Looking for a way to generate reports showing who has used what amount of DSL bandwith, and what are the main sites that were hit were

Posted on 2005-03-14
Medium Priority
Last Modified: 2013-12-14
I have a small W2K Network (20-25 workstations). I need to understand where our internet (DSL) usage is going. I am a little concerened about a security issue, just because I can't account for all the usage.  AVG 18GB per month seems a little high for the type of work we do here.--Thanks.
Question by:mapalaska2003
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 13546551
Are you using a proxy?  If so, you might be able to get what you need from the logs.

Author Comment

ID: 13547514
No, we are not using a proxy.

Expert Comment

ID: 13577393
A proxy would be the best long term solution however some ISP's may be able to give you some information on data transfers. Also if you are using a good firewall it may yeald information on the most accessed sites and ip's.

if none of the above is possible you can always do the "good old snoop" though the temp internet files folders on the pc's in question.

Expert Comment

ID: 13592160
There are other tools like Solarwinds that can gather this information a network probe (a device watching every packet in and out of the network) if you want to do a bit more work.

How fast is your DSL connection?  Are you experiencing performance issues as well as being concerned about security?

I did a little math and I'm not convinced your 18 Gbytes/month is that much on average.  You may just be getting "sticker shock" from seeing the number as a monthly total.  Take a look at this and see if it makes sense:

Assume you are open 40 hour weeks so 160 hours/month.  Assuming longer hours will LOWER the average, so 160 should be conservative.

18 GBytes/month * 1000 = 18000 Megabytes/month / 160 hours/month = 112.5 MBytes/hour.

112.5 MBytes/hour / 3600 seconds/hour = 0.03125 MBytes/second * 8 bits/byte = 0.250 Mbps or 250 Kbps

Is the 18 Gbytes total transfer, upload, or download?  I usually assume a 2X factor on my average to allow for traffic variability.  Assuming it is download or upload, I would want a 500 Kbps in that direction to maintain little or not congestion on the network during business hours.

Remember, this is assuming that ZERO traffic is transferred outside the 40 hour business week.  If that's not the case, then the average will be lower.

If your goal is to identify non-business traffic and control it, the best thing to do is implement a proxy and restrict sites.  Make sure you and/or your management communicates the policy to everyone, then use the proxy to enforce it.  

Open communication about the policy is important for several reasons:

 - Some people just don't understand that their browsing may be impacting others.
 - The statement of policy can often be enough of a deterrent that the actual enforcement isn't needed.
 - In the event you do need to take action against an individual, the written policy covers you legally.  

Accepted Solution

dddigger earned 1000 total points
ID: 13646312
not enough information

how are users validated against the internet connection?

what equipment is involved, many of the dsl modem/routers have logging built in and can send the logs were ever u want them...

assuming thats true is it using dhcp?
can u configure it to perform host lookups with the logging?
would knowing which pc is generating the traffic suffice?

the tricky part seems to be how to know for certain who? u may have to settle for which computer and compare it to logons?

if u dont mind spending money ISA dos a pretty good job of keeping track of this stuff...

i would also imagine there are some freebees out there somewere
might try www.sourceforge.net for some ideals

anyhow once you figure out how to get the data into a file u might consider something like acid to generate reports for managment


Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

    Over the past few years, small business and home owners have become so dependent on internet that a need for redundancy has arisen.    What happens when your small business or home / home office loses its internet connection?  The results c…
Why do some people recommend buying business VoIP from an ISP? What are the benefits to my company? What are the costs?
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question