Looking to review 3 months of heavy edits and new content from 40 different editors.
Want to estimate workloads of users during that period, and also develop some stats on the frequency of update of pages.
I have tried analysing the system log files. Can look at them OK, but not load them into Excel or MS Access to run stats on them.
Web server log file software isn't very useful as they are not in that format.
Squiz have advised not to query the database directly as that could adversely affect system performance.
Looking for suggested next steps.
[quote]
Looking to review 3 months of heavy edits and new content from 40 different editors.
Want to estimate workloads of users during that period, and also develop some stats on the frequency of update of pages.
I have tried analysing the system log files. Can look at them OK, but not load them into Excel or MS Access to run stats on them.
Web server log file software isn't very useful as they are not in that format.
Squiz have advised not to query the database directly as that could adversely affect system performance.
Looking for suggested next steps.
[/quote]
Hi,
I use simple awk script for logins statistic:
/Arkadiusz/ { num_arek++ }
/Beata/ { num_beti++ }
END {
print "Logins numbers\n";
printf ("Arkadiusz \t\t\t %2d\n", num_arek);
printf ("Beata \t\t\t %2d\n", num_beti);
}It is only for login statistic but I think it's easy to modify for yours needs.
I put this script in file l_stat.awk and run:
awk -f 011 system.log
Regards
Arek