Sun, 19 May 2013 22:24:34 +0000 http://forums.opendns.com/ Lussumo Vanilla 1.1.4 http://forums.opendns.com/comments.php?DiscussionID=13749&Focus=78431#Comment_78431 http://forums.opendns.com/comments.php?DiscussionID=13749&Focus=78431#Comment_78431 Sat, 24 Mar 2012 04:26:54 +0000 callmebruce I downloaded fetchstats bash shell script and ran it. Interesting data. How do I go about adding it to cron (or something like that?) to run either daily or weekly. Since I need to feed the script the date range, anyone have a way to pull the current date in a script?

Second question - I went through the data and tried to graph blocked sites. Just tryoing to wrap my self around what the data presents, and how to make it easier to understand. Anyone messing with LibreOffice Calc? Any hints on basic reports using Calc?]]> http://forums.opendns.com/comments.php?DiscussionID=13749&Focus=78441#Comment_78441 http://forums.opendns.com/comments.php?DiscussionID=13749&Focus=78441#Comment_78441 Sat, 24 Mar 2012 12:07:29 +0000 rosch Use this command in a terminal: crontab -e
Then add a line like so:
50 23 * * 1-7 /path/to/file/mystats.sh > /path/to/csv/$(date).csv

This would run 10min to midnight every day. Your machine has to run at this time for this to happen. Don't forget to change the paths to your existing ones. Also, since you want to automize this, you have to comment out lines 39-43 and set the password on line 44 like so:
PASSWORD=opendns_password

Instead of using "crontab -e" you can also use anacron. More info on the net :)

This is what mystats.sh can look like (pulls today's opendns stats):
fetchstats username network_name $(date +%Y-%m-%d)

For LibreOffice Calc you should be able to find documentation online.]]> http://forums.opendns.com/comments.php?DiscussionID=13749&Focus=78457#Comment_78457 http://forums.opendns.com/comments.php?DiscussionID=13749&Focus=78457#Comment_78457 Sat, 24 Mar 2012 18:01:23 +0000 callmebruce