SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Timothy Parker / Parsing Log Files and Summarizing Results with PowerShell / Latest Posts

RE: Parsing Log Files and Summarizing Results with PowerShell

Tim Parker — Tue, 24 May 2011 14:31:40 GMT

Thanks for the suggestion, I will definitely have to take a look at "LogParser" from Microsoft.Tim P.

RE: Parsing Log Files and Summarizing Results with PowerShell

ddelower — Tue, 24 May 2011 02:03:15 GMT

Hi Tim yes powershell is great for these type of tasks , I use it all the time on SCCM, Servers and workstations etc and I am learning to use it on SQL , but it can be a bit slow on network connections, get-childitem is good for local disk, but there is something much better "LogParser" from Microsoft, a nifty little tool for - as the name suggest parsing log files. I have made a link in my $profile so I can use it from the powershell console. check this out - getting the sccm-client logs across the network.logparser -o:datagrid -i:TEXTLINE "select * from \\xxx-xxx-xxx\c$\windows\system32\ccm\logs\*.log where text like '%oracle%'".there's a few references of it in the powershell blogs.cheers Dene

Parsing Log Files and Summarizing Results with PowerShell

Tim Parker — Mon, 23 May 2011 22:48:32 GMT

Comments posted to this topic are about the item [B]Parsing Log Files and Summarizing Results with PowerShell[/B]