Reporting

Dashboard panel

rahul2gupta
Path Finder

Hi @isoutamo ,

When I am running the following query in verbose mode it giving me results but not in fast mode.

index=symantec sourcetype=sep12:scan status=completed | stats count

As Dashboard panel uses fast mode.What necessary modification do I need to do to get the results in fast mode.

Regards,

Rahul

Labels (1)
0 Karma
1 Solution

renjith_nair
Legend

@rahul2gupta,

So you might have multiple field extraction and hence it needs explicit mention about fields

So you may use

index=symantec sourcetype="sep12:scan" |fields * 
|where status="completed"
---
What goes around comes around. If it helps, hit it with Karma 🙂

View solution in original post

renjith_nair
Legend

@rahul2gupta 

It's normally because of the extracted fields. Use "|fields " to explicitly specify the field

Try

index=symantec sourcetype=sep12:scan |fields status|where status=completed |stats count

 

---
What goes around comes around. If it helps, hit it with Karma 🙂
0 Karma

rahul2gupta
Path Finder

Hi @renjith_nair ,

I tried but it did not worked.Please find the screen shot below.

rahul2gupta_0-1594618015069.png

rahul2gupta_1-1594618092608.png

 

rahul2gupta_2-1594618130946.png

Regards,

Rahul

0 Karma

renjith_nair
Legend

Can you try this in fast mode and see if you are getting events with status?

 

index=symantec sourcetype="sep12:scan" status=*

 

OR

index=symantec sourcetype="sep12:scan" |fields *
---
What goes around comes around. If it helps, hit it with Karma 🙂
0 Karma

rahul2gupta
Path Finder

Hi @renjith_nair .

I ran the following query index=symantec sourcetype="sep12:scan" |fields * and I could able to get events in fast mode.

Please find the screen shot below.

dash.PNG

But it did not worked for index=symantec sourcetype="sep12:scan" status=* 

dash1.PNG

Regards,

Rahul

0 Karma

renjith_nair
Legend

@rahul2gupta,

So you might have multiple field extraction and hence it needs explicit mention about fields

So you may use

index=symantec sourcetype="sep12:scan" |fields * 
|where status="completed"
---
What goes around comes around. If it helps, hit it with Karma 🙂

rahul2gupta
Path Finder

Hi @renjith_nair ,

I used the following query index=symantec sourcetype=sep12:scan status=completed |fields * |stats count

and it worked.

Regards,

Rahul

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Persistent Queue at TcpOut — One of Splunk's Most Practical Features

Splunk introduced persistent queueing at the tcpout layer as one of the most practical resilience features in ...

Skip the Awkward Silence: Have a .conf-ersation at .conf26

Picture this. You arrive at .conf26 already having your socializing and networking plans mapped out. No ...

Rethinking Zero Trust: From Product Purchases to Logical Control Evidence

Implementing Zero Trust (ZT) across complex environments often falters at the very beginning due to a ...