Remove rows who don't value value in it.

[rahul2gupta]

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.

Regards,

Rahul

[kamlesh_vaghela · Accepted solution]

@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.

[rahul2gupta]

Thank you @kamlesh_vaghela . It worked.