Splunk Search

How to count min max time by user?

t874560
New Member

Hello,

I am trying to pull min and max time for each user:

index="iptv_rdkb" [|inputlookup usersfile.csv]
| fields _time Source device.make model userId
| stats count by Source make model userId _time
| eventstats max(_time) AS max min(_time) AS min
| eval max=strftime(max, "%Y/%m/%d %T.%3Q")
| eval min=strftime(min, "%Y/%m/%d %T.%3Q")
| stats earliest(min) as min earliest(max) as max first(make) as make first(model) as model first(userId) as user by userId

Results:

Source min max make model userid
b661834 2020-04-10 2020/04/10 TECHN xyz 1
b654623 2020-04-10 2020/04/10 TECHN xyz 2
b637895 2020-04-10 2020/04/10 TECHN xyz 3

This search gives me the same time for each record. For example, if minimum time is 2020-04-10 in any of the records, it will give this date/time in every record instead of giving min-max of that specific user.

I need min and max for each specific user.

Please help.

0 Karma

Vijeta
Influencer

@t874560 Use this search

 index="iptv_rdkb" [|inputlookup usersfile.csv]
 | fields _time Source device.make model userId
 | stats count by Source make model userId _time
 | eventstats max(_time) AS max min(_time) AS min by userId
 | eval max=strftime(max, "%Y/%m/%d %T.%3Q")
 | eval min=strftime(min, "%Y/%m/%d %T.%3Q")
 | stats earliest(min) as min earliest(max) as max first(make) as make first(model) as model first(userId) as user by userId
0 Karma

to4kawa
Ultra Champion

eventstats can use by clause.

0 Karma
Get Updates on the Splunk Community!

Introducing Ingest Actions: Filter, Mask, Route, Repeat

WATCH NOW Ingest Actions (IA) is the best new way to easily filter, mask and route your data in Splunk® ...

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...