Forum Discussion
Exporting non empty columns from Worskspace
Hi Guys, I wanted to export only non empty columns via queries in work space. Could any one kindly provide the respective query for it. For eg Security Event | where AlertName contains...
You can use the function isnotempty() by adding
| where isnotempty("ColumnName")
to your query
Thanks a lot. This is helpful.
Is there a way i can get all the columns which contains some data, without specifying the name of the column .. for eg, i wanted all results in Common Security Log table.. filtering out all the columns which dont have any data
regards
manish
