Parsing Log Files and Summarizing Results with PowerShell

  • Tim Parker

    SSCommitted

    Points: 1644

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

    😀

  • ddelower

    SSC Rookie

    Points: 25

    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

  • Tim Parker

    SSCommitted

    Points: 1644

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

    Tim P.

    😀

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply