Splunk Search

Is it possible ot get a unique user listing with sourcetype="who"?

splunk4steve
New Member

I am trying to get a list of people who have logged in to our system in the last 24 hours. The unix app runs a script that generates this every 10 minutes or so. This is fine however I only need to see the information once...not the same list of users over and over again.

Is it possible to do a unique search with that sourcetype?

Tags (1)
0 Karma

martin_mueller
SplunkTrust
SplunkTrust

There are several ways of making results unique. You could do a stats/chart/timechart by user, or run them over values(user), or use dedup, maybe more.

0 Karma

splunk4steve
New Member

Close! I think this might work:

index="os" sourcetype="who" host="*.domain.com" | dedup host

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

So... this?

some search over 24 hours | table user | dedup
0 Karma

splunk4steve
New Member

I am basically trying to get a listing of all users who have logged in to a particular server over a period of 24 hours. I don't need to see that 'martin' logged in at 8:00am over and over again...I only need to see it once.

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

What result are you trying to achieve from what data?

0 Karma

splunk4steve
New Member

I've tried using dedup. The problem is that the initial time/date stamp that Splunk adds makes it unique. Is there some way to filter that out?

0 Karma
Get Updates on the Splunk Community!

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...

Splunk APM: New Product Features + Community Office Hours Recap!

Howdy Splunk Community! Over the past few months, we’ve had a lot going on in the world of Splunk Application ...

Index This | Forward, I’m heavy; backward, I’m not. What am I?

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