Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Parsing Log Files and Summarizing Results with PowerShell Expand / Collapse
Author
Message
Posted Monday, May 23, 2011 10:48 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, December 1, 2014 8:56 AM
Points: 338, Visits: 451
Comments posted to this topic are about the item Parsing Log Files and Summarizing Results with PowerShell

Post #1113755
Posted Tuesday, May 24, 2011 2:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 1:31 AM
Points: 1, Visits: 39
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
Post #1113808
Posted Tuesday, May 24, 2011 2:31 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, December 1, 2014 8:56 AM
Points: 338, Visits: 451
Thanks for the suggestion, I will definitely have to take a look at "LogParser" from Microsoft.

Tim P.


Post #1114413
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse