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!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...