Sqmgrlog users implementations

Jeremy Lahners

"I think that employers would like to see access organized into a weekly summary. I've accomplished this with a cron job as follows:"

#!/bin/bash

#Get current date
TODAY=$(date +%d/%m/%Y)

#Get one week ago today
LASTWEEK=$(date --date "7 days ago" +%d/%m/%Y)

/usr/local/bin/sqmgrlog -d $LASTWEEK-$TODAY

exit 0

I think that this code could prove very helpful for others in my field.