Splunk Search

How to search for the users logging into a server that have never logged in before.

ntalwar
New Member

Working on real time data.I want to search for users logging into the server that have never logged before.

Tags (1)
0 Karma
1 Solution

harsmarvania57
Ultra Champion

Hi @ntalwar,

I'll prefer below steps to achieve this.

1.) Create CSV file which contains list of users who already logged into the server previously ( If you have this data in splunk you can fetch those data and generate lookup).
2.) Upload that csv in Splunk.
3.) Run you search to find users who logging into server and compare that against csv file which you have uploaded in splunk (Using lookup command)
4.) Filter users who are not in lookup file (Something like | where isnull(lookup_user) )
5.) Once you have result you can run this as scheduled search to send result over email and in same query I'll use outputlookup in last to update existing lookup file which contains logged in user details so in future when query will run it will not generate result against those newly logged in user.

I hope this helps.

Thanks,
Harshil

View solution in original post

0 Karma

harsmarvania57
Ultra Champion

Hi @ntalwar,

I'll prefer below steps to achieve this.

1.) Create CSV file which contains list of users who already logged into the server previously ( If you have this data in splunk you can fetch those data and generate lookup).
2.) Upload that csv in Splunk.
3.) Run you search to find users who logging into server and compare that against csv file which you have uploaded in splunk (Using lookup command)
4.) Filter users who are not in lookup file (Something like | where isnull(lookup_user) )
5.) Once you have result you can run this as scheduled search to send result over email and in same query I'll use outputlookup in last to update existing lookup file which contains logged in user details so in future when query will run it will not generate result against those newly logged in user.

I hope this helps.

Thanks,
Harshil

0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...