Solved

Recommend a Windows server log analyser

Posted on 2016-08-08
10
48 Views
Last Modified: 2016-08-09
Hi Experts

Can you recommend a good (free) basic Windows Event log analyser
I am looking for something simple, to perform on demand analysis
I have a server which generated 25K event in 4 days and I would like to analyse the logs (possibly offline as the server itself is getting old and slow)

Any suggestion ?

Alexandre
0
Comment
Question by:Alexandre Michel
10 Comments
 
LVL 12

Expert Comment

by:Benjamin Voglar
ID: 41746757
Is it always the same Event ID?
0
 
LVL 37

Expert Comment

by:bbao
ID: 41746786
always first try something official from MS: Log Parser 2.2, a SQL-like query engine for collecting logs from varied sources.

https://technet.microsoft.com/en-au/scriptcenter/dd919274.aspx
0
 
LVL 4

Author Comment

by:Alexandre Michel
ID: 41746804
Benjamin

No, it is not always the same event, there are lots of different event IDs

Bing,

Thanks for that. It looks promising. I will look into it.
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
LVL 4

Author Comment

by:Alexandre Michel
ID: 41747073
Bing,

Log Parser 2.2 seems to be a Command Line based tool. Is that correct? Any GUI that you know of?
0
 
LVL 37

Accepted Solution

by:
bbao earned 500 total points
ID: 41747116
you are correct.

yeah, its GUI version is also available now: Log Parser Studio

https://gallery.technet.microsoft.com/Log-Parser-Studio-cd458765
0
 
LVL 10

Expert Comment

by:Damjan
ID: 41747172
Hi,

you may also try  Event Log Consolidator tool from SolarWinds - http://www.solarwinds.com/free-tools/event-log-consolidator

It is an efficient tool (GUI) to help you organize event logs in SMBs.
0
 
LVL 4

Author Comment

by:Alexandre Michel
ID: 41747224
Damjan, thanks for the suggestion. I tried it ... but cannot get it to look at Windows "Application Event" logs. It seems to only look at the "File Replication Service" log for some reason...

Bing, the Log Parser studio looks great ... but ... I need to know SQL query to use it! Which I don't ... Luckily there are a number of samples I can use. This allowed me to create a first meaningful analysis
0
 
LVL 4

Author Comment

by:Alexandre Michel
ID: 41747318
Bing

Are you familiar with SQL & Log Parser or should I ask a new question?

I would like to modify this query to only use the last nn entries or the entries since xx (date & time)

SELECT SourceName, 
    BIT_AND(EventID, 0x3fffffff) as EventID, 
    EventTypeName, 
    COUNT(*) As Entries
    FROM APPLICATION
    GROUP BY SourceName, EventID, EventTypeName
ORDER BY Entries DESC

Open in new window

TimeGenerated is a date & time field from the Event Log (in my case in the form of "d/mm/yyyy hh:mm:ss PM"). Not sure how to restrict the count to TimeGeneated > now()-24 hours or something like that

Also is there a way to restrict the report to only items whose Count is > 100 ?
0
 
LVL 37

Assisted Solution

by:bbao
bbao earned 500 total points
ID: 41747439
> restrict the count to TimeGeneated > now()-24 hours or something like that

just use WHERE clause. e.g. use WHERE TimeGenerated > '2016-08-08 00:00:00' to restrict events for today only.

> Also is there a way to restrict the report to only items whose Count is > 100 ?

use "SELECT TOP n" plus additional clauses as required to restrict the result to specific number or less. be aware that if used with GROUP BY on more than one field, it may cause additional fields not fully counted.

BTW, to get the benefits of Log Parser engine, you have to be familiar with SQL SELECT queries.
0
 
LVL 4

Author Closing Comment

by:Alexandre Michel
ID: 41749623
Thanks for that Bing
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to install and use the NTBackup utility that comes with Windows Server.
IT certifications are a concrete representation of continual learning on the part of the candidate.  Continual learning is necessary for the long term success of an IT professional, but are IT certifications the right path for you?
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question