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!

Modern way of developing distributed application using OTel

Recently, I had the opportunity to work on a complex microservice using Spring boot and Quarkus to develop a ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had 3 releases of new security content via the Enterprise Security ...

Archived Metrics Now Available for APAC and EMEA realms

We’re excited to announce the launch of Archived Metrics in Splunk Infrastructure Monitoring for our customers ...