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

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


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Cable Modem Provisioning from DPoE compliant server  This Article is to support CMTS administrators to provide an overview of DOCSIS compliance configuration file, and to provision a cable modem located at customer place from a Back office serve…
Sometimes you have to pull out old tricks to get a new firewall to work… While we were installing a new Sonicwall at a customers site we found that sites they were able to visit before were not working.  It seemed random and we could not understa…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month12 days, 19 hours left to enroll

578 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