I want to rollup statistics on site usage, but all I have is WSS 3.0. This will be a one-time task, so I don't want over-think it too much. I am currently collecting usage data. Is that information available to powershell or is there a published schema where I can retrieve it? If I can get it out, I can use any reporting tool.
I was able to get usage data from the WSS 3.0 Usage Event Logs aggregated from thousands of site collections using Microsoft’s Log Parser 2.2 tool. Because the WSS 3.0 Usage Event Log file format is not an out of the box supported input format for Log Parser 2.2, I had to code a custom input format plug-in.
Below are some useful resources I used in my journey to analyzing usage data.
Log Parser 2.2
Custom Input Format Plugin
Finally, I was able to run LogParser 2.2 using the custom input format plug-in and output the results to a SQL Server database table.