Splunk Search

How to Modify Field to exclude field not needed?

jakeoftrades
Explorer

Hi,

Can anyone help me how can I change the field of my query to exclude those with 
PRODUCED labels

query:

index="hcg_ph_t2_bigdataservices_prod" sourcetype="be:streaming-services" earliest=-3h@h latest=@h
| search stream_type IN (Datascore_Compress, Datascore_Decompress, Eservices_Eload, Eservices_Ebills)
| eval service_details=stream_type." - ".kafka_datatype
| bucket span=90m _time
| stats sum(kafka_count) as count by _time service_details
| stats latest(count) as current_count earliest(count) as past_count by service_details

jakeoftrades_0-1652697442744.png

PRODUCED items which is under kafka_datatype:

jakeoftrades_1-1652697717311.png

 

I have tried to add this to my query but still does not exclude those with PRODUCED:

| sort .kafka_datatype asc
| fields - "PRODUCED"

Please help. 

Thank you,
Jake

Labels (3)
Tags (2)
0 Karma

gcusello
Legend

Hi @jakeoftrades,

let me understand: you want to exclude results where kafka_datatype="PRODUCED", is this correct?

if this is your need, you could filter results in the main search of after the stats command, something like this:

index="hcg_ph_t2_bigdataservices_prod" sourcetype="be:streaming-services" earliest=-3h@h latest=@h stream_type IN (Datascore_Compress, Datascore_Decompress, Eservices_Eload, Eservices_Ebills) kafka_datatype!="PRODUCED"
| eval service_details=stream_type." - ".kafka_datatype
| bucket span=90m _time
| stats sum(kafka_count) as count by _time service_details
| stats latest(count) as current_count earliest(count) as past_count by service_details

in addition, you don't need to use the search command after the main search, in this way you have a slower search.

Ciao.

Giuseppe

 

0 Karma
Get Updates on the Splunk Community!

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...