Microsoft Secure Tech Accelerator
Apr 03 2024, 07:00 AM - 11:00 AM (PDT)
Microsoft Tech Community

Exporting non empty columns from Worskspace

Copper Contributor

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. 

2 Replies

@kmanish 

 

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