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.

Comments