Getting Data In

Remove rows who don't value value in it.

rahul2gupta
Path Finder

Hi,

We have been asked to design a query which consists of Username, location and last logon time of that user. However, I want to remove those rows who don't have values in it. Can someone please assist me on this.

rahul2gupta_0-1625024524972.png

 

Regards,

Rahul

Labels (2)
0 Karma
1 Solution

kamlesh_vaghela
SplunkTrust
SplunkTrust

@rahul2gupta 

Try

YOUR_SEARCH | search location=* and lastlogon=*

 

OR
 

YOUR_SEARCH | where isnotnull(location)  AND  isnotnull(lastlogon)

 

Thanks
KV
▄︻̷̿┻̿═━一

If any of my reply helps you to solve the problem Or gain knowledge, an upvote would be appreciated.

View solution in original post

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@rahul2gupta 

Try

YOUR_SEARCH | search location=* and lastlogon=*

 

OR
 

YOUR_SEARCH | where isnotnull(location)  AND  isnotnull(lastlogon)

 

Thanks
KV
▄︻̷̿┻̿═━一

If any of my reply helps you to solve the problem Or gain knowledge, an upvote would be appreciated.

0 Karma

rahul2gupta
Path Finder

Thank you @kamlesh_vaghela . It worked.

0 Karma
Get Updates on the Splunk Community!

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...