Jan 07 2020 11:01 AM
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 "DCSync Attack" -- > I do not want columns with empty data.
Jan 07 2020 12:30 PM
You can use the function isnotempty() by adding
Jan 08 2020 03:02 AM
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