LogParser and SharePoint (kinda like chocolate and peanut butter)


Thinks

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

http://gluegood.blogspot.com/2008/11/freeware-logparserwss30-sharepoint.html

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

 

http://gluegood.blogspot.com/2008/11/freeware-wss30listupload-sharepoint.html

 

“You got your SharePoint in my LogParser, Hey you got your LogParser in my SharePoint!”

Links

Clinks

  • 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.
Skip to main content