I’ve just committed a function to easily purge old data from LogMiner’s database, useful to prevent it from growing too much. It’ll appear in the next version, but since its release might still be far from now, here’s the code for those who need it: 123456789101112131415161718192021222324252627282930313233343536373839CREATE OR REPLACE FUNCTION cleanup( _site int8, _upToDate DATE ) …
Category: SysAdmin
Mac OS X version statistics through CFNetwork analysis
Recently I needed to gather some statistics about the distribution of the different Mac OS X versions installed by users of a certain application. Since the application has an update-check feature, I thought I’d use the web server logs to infer the data I was interested in. The only thing I could use was the …