Event Viewer TOP 10 dashboard

Dashboard Server
1

Goal: To see a servers top 10 Critical events from a certain eventlog (eq. HelpDeskEventlog)
If using SQL Grid (connectionstring?).

Keyvalue: Server: SrvFalcon01 Eventlog: HelpDeskEventlog User: Falken Pass: Joshua

Thx for helping

2

could powershell be the answer to this?

3

The PowerShell or SQL/ODBC tiles could be the answer. When you say EventLog, is it a Windows Event log? Or is it a text file, or is it something else?

4

Good point I was refering to the eventlog on the windows machine.

5

Ah, yes. Then PowerShell would be the tool of choice.

Something like this:

$start = Get-Date 
$end = $start.AddHours(-12)

$result = Get-EventLog -LogName Application -Before $start -After $end
$result
1 Like
6

If you want to see it per server then you should use an agent task to execute a script. Much like shawn suggestions.

$start = Get-Date
$end = $start.AddHours(-12)

$result = Get-EventLog -LogName Application -Before $start -After $end
$result

If you have Kevin Holmans MP (link below) you can execute the task “Execute any Powershell” to run the script. Otherwise you could author your own PS-task if you have the knowledge.