« Previous Next »

Answered Thread: Querying and uploading to Sharepoint using Logparser

Last post 11-15-2008 4:41 AM by gluegood. 0 replies.

 

RSS

Page 1 of 1 (1 items)

Sort Posts:

  • 11-15-2008, 4:41 AM

    Querying and uploading to Sharepoint using Logparser

    Thought I'd share these two utilities I've written in relation to SharePoint and LogParser. 

    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

    Website with notes and download

    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"

    Website with notes and download

    Both tools are Freeware with VB.NET 2005 source included

    Enjoy!

Page 1 of 1 (1 items)