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!

What’s New & Next in Splunk SOAR

Security teams today are dealing with more alerts, more tools, and more pressure than ever.  Join us on ...

Your Voice Matters! Help Us Shape the New Splunk Lantern Experience

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

September Community Champions: A Shoutout to Our Contributors!

As we close the books on another fantastic month, we want to take a moment to celebrate the people who are the ...