Splunk Search

How to get the missing devices in a index comparing with yesterday

surekhasplunk
Communicator

Hi,

index=myindex |search name=*| bin span=1d _time | stats dc(name) as name by _time

here i am getting the number of names in last 7 days with count for each day. Like the image shown.

Now when the count dropped from 140 to 132 i want a query which can show the missing 8 names. 

 image.png

Labels (1)
Tags (1)
0 Karma

to4kawa
Ultra Champion

your search is latest=now()
maybe, a few name isn't appeared yet.

0 Karma
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...