I came across a post on the IIS.net forums (http://forums.iis.net/p/1153101/1884922.aspx#1884922) that led to what looks to be a promising tool to add to your SharePoint toolbox.
From Gluegood Software
LogParser.WSS30 – I recently published a Logparser COM input plug-in for Sharepoint Lists. This allows for Logparser queries against Sharepoint lists, document libraries and wikis. e.g.
LogParser.exe -i:COM "select * From ‘http://sharepoint.net/topsite/mysite/Lists/Change Control/AllItems.aspx’" -iProgId:Gluegood.LogParser.WSS30 -o:DataGrid
WSS30ListUpload – In addition I have written a tool to output Logparser results to Sharepoint using the output ‘Template’ (-o:TPL) features in Logparser. This allows for Logparser queries to be executed and their results published to an existing Sharepoint list (task, calendar etc), document library, or wiki. e.g.
LogParser.exe -i:EVT "Select Top 10 RecordNumber,’New’ as [ID],EventLog,RecordNumber,TimeGenerated,TimeWritten,EventID,EventType into STDOUT from System" -tpl:c:\SharePointTemplate.tpl -stats:off | WSS30ListUpload.exe http://mysite/site/Lists/Test/AllItems.aspx
“You got your SharePoint in my LogParser, Hey you got your LogParser in my SharePoint!”
- Great idea, bummed I didn’t get to it earlier or write it myself!
- As with all software, better to review source code if you can first before running on your machines. If you can’t make sure you follow Safe Software Practices on your machines.