LogParser and SharePoint (kinda like chocolate and peanut butter)

  • Article

Thinks

I came across a post on the IIS.net forums (https://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 'https://sharepoint.net/topsite/mysite/Lists/Change Control/AllItems.aspx'" -iProgId:Gluegood.LogParser.WSS30 -o:DataGrid

https://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 https://mysite/site/Lists/Test/AllItems.aspx

 

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

“

 

“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.