read log file for greater than value


hi experts,

power shell read below log file ,  find out lock value greater 100, log file not having heading.

[sid,serial]=3791,60699  [, lock= 150 sec [prod1, prodsever, process.exe]  [event=sql*net message client, prev sql start=2016-09-05 06:45:29]

[sid,serial]=3791,60699  [, lock= 90 sec [prod1, prodsever, process.exe]  [event=sql*net message client, prev sql start=2016-09-05 06:20:29]

[sid,serial]=3791,60699  [, lock= 110 sec [prod1, prodsever, process.exe]  [event=sql*net message client, prev sql start=2016-09-05 06:10:29]

select-string -path c:\logs\test.log -pattern 'lock=\s+(\d+)' |where {[int]($_.matches.captures.groups[1].value) -gt 100}

\_(ツ)_/





Windows Server  >  Windows PowerShell



Comments

Popular posts from this blog

Group Policy Event ID 1058 Error Code 1326 (The user name or password is incorrect)

Suspicious event log Event ID: 4905

DCOM received error "2147746132" from...