For When You Can't Have The Real Thing
[ start | index | login ]
start > dave > experiments > Net Flows > 2007-12-18 > 1

2007-12-18 #1

Created by dave. Last edited by dave, 16 years and 159 days ago. Viewed 2,584 times. #2
[diff] [history] [edit] [rdf]

Sorting IPs by usage in arbitrary timeslots

select ip,sum(bytesIn)+sum(bytesOut) as total from localip where ( timeslot >= 1194642000 and timeslot <= 1194648000 ) group by ip order by total desc;

Also changed the graphing script to put the reverse-name in the name of the graph, so we can find things by both pointers.

no comments | post comment
This is a collection of techical information, much of it learned the hard way. Consider it a lab book or a /info directory. I doubt much of it will be of use to anyone else.

Useful: | Copyright 2000-2002 Matthias L. Jugel and Stephan J. Schmidt