Splunk Search

HELP with Search and Bar Chart...

leomedina
Explorer

Hello all,

I am trying to search on multiple values, which are not being populated in a field. And then renaming these values into "Success" or "Fail".

Thus far I have:

index=datapower sourcetype=syslog EventType=error
| stats count(eval(0x80e00110 NOT 0x01130009 NOT 0x01130024 NOT 0x00d30003 NOT 0x80c00009 NOT 0x80c00010 NOT 0x01d30001 NOT 0x84e00032 NOT 0x80e00791="Fail"))
| stats count(eval(0x00530002 AND 0x80c00008 AND 0x80e006c1 AND 0x01130006 AND 0x80e00126 AND 0x80e00627="Success"))

I keep getting an error and can't see anything 😞

Sincerely appreciate the help.

Also how do I display this in a side bar graph?

0 Karma
1 Solution

hhGA
Communicator

Hi leomedina,

Seeing as you have 0x80e00791="Fail", I'm assuming that 0x80e00110, 0x01130009 etc are field names.

Instead of eval(0x80e00110 NOT 0x01130009 NOT 0x01130024) try using eval(isNull(0x80e00110) AND isNull(0x01130009) AND isNull(0x01130024)) instead.

When you have the data correct, click on 'Vizualisation' to see the chart views.

Let me know if there are any issues.

View solution in original post

hhGA
Communicator

Hi leomedina,

Seeing as you have 0x80e00791="Fail", I'm assuming that 0x80e00110, 0x01130009 etc are field names.

Instead of eval(0x80e00110 NOT 0x01130009 NOT 0x01130024) try using eval(isNull(0x80e00110) AND isNull(0x01130009) AND isNull(0x01130024)) instead.

When you have the data correct, click on 'Vizualisation' to see the chart views.

Let me know if there are any issues.

leomedina
Explorer

hhGA... You, my friend, are a genius... I am getting the data I needed...

| eval (0x00530002) OR (0x80c00008) OR (0x80e006c1) OR (0x01130006) OR (0x80e00126) OR (0x80e00627)="Success"   
| eval isNull(0x80e00110) AND isNull(0x01130009) isNull(0x01130024) isNull(0x00d30003) isNull(0x80c00009) isNull(0x80c00010) isNull(0x01d30001)  isNull(0x84e00032) isNull(0x80e00791)="Errors" 

Thanks!

0 Karma

aaraneta_splunk
Splunk Employee
Splunk Employee

@leomedina - Glad to hear hhGA's answer helped answer your question. Please don't forget to resolve this post by clicking "Accept" so that other users can easily find it too. Thanks!

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...