Reporting

How to correlate log collection with specific Windows eventcode?

nicolsa
Observer

Hello,

I'm trying to find a search to correlate (graph overlay) log collect with specific windows eventcode (4608 for windows is starting up ; 6005 :The event log service was started 6006 The Event log service was stopped)

like this 

 host=machine | timechart count by host

and the other part would be 

host=machine EventCode=4608 OR EventCode=6005 OR EventCode=6006  | timechart count by EventCode

I'm a little bit lost with appendcols /append/ join ...

How can I do this? Thank you for your help

Labels (1)
Tags (1)
0 Karma

thambisetty
SplunkTrust
SplunkTrust

I believe the below search you shared should give you what you are expecting.

<p>host=machine EventCode=4608 OR EventCode=6005 OR EventCode=6006  | timechart count by EventCode</p>

————————————
If this helps, give a like below.
0 Karma

nicolsa
Observer

I'm searching to have a chart overlay. A curve representing the log collection (log event count) of the universal forwarder machine, and a column chart for windows eventcode for the same universal forwarder. the x-axis would be _time

0 Karma

thambisetty
SplunkTrust
SplunkTrust

host=machine EventCode=4608 OR EventCode=6005 OR EventCode=6006  | chart count over _time by EventCode

click on visualization format option go to y-axis choose count as chart overlay.

————————————
If this helps, give a like below.
0 Karma

richgalloway
SplunkTrust
SplunkTrust
What is the desired output?
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...

IM Landing Page Filter - Now Available

We’ve added the capability for you to filter across the summary details on the main Infrastructure Monitoring ...

Dynamic Links from Alerts to IM Navigators - New in Observability Cloud

Splunk continues to improve the troubleshooting experience in Observability Cloud with this latest enhancement ...