topic Remove rows who don't value value in it. in Getting Data In

Remove rows who don't value value in it.

rahul2gupta — Wed, 30 Jun 2021 03:43:01 GMT

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

Re: Remove rows who don't value value in it.

kamlesh_vaghela — Wed, 30 Jun 2021 05:49:15 GMT

@rahul2gupta

Try

YOUR_SEARCH | search location=* and lastlogon=*

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.

Re: Remove rows who don't value value in it.

rahul2gupta — Wed, 30 Jun 2021 06:13:25 GMT

Thank you @kamlesh_vaghela . It worked.