kql - Find all table with multiple columns name criteria - Stack Overflow

admin管理员组

文章数量:1316663

Through query page, I can search all tables where column == "something". Seems we're not able to make AND/OR from UI. So, I would like to know if there is a KQL query that can let search accross tables about column names with multiple criteria. Example : Finding all table where it contains one column named "Customer_ID" and one column named "mail" Thanks :)

Through query page, I can search all tables where column == "something". Seems we're not able to make AND/OR from UI. So, I would like to know if there is a KQL query that can let search accross tables about column names with multiple criteria. Example : Finding all table where it contains one column named "Customer_ID" and one column named "mail" Thanks :)

• kql
• azure-data-explorer

Share Improve this question Follow asked Jan 29 at 9:23 PierrotPierrot 1911 silver badge44 bronze badges 1

• Could you share what you have tried? – Balaji Commented Jan 29 at 12:24

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

I found the solution:

show database *db_name* schema 
| where ColumnName contains "xxx" or ColumnName contains "yyy" 
| summarize make_list(ColumnName) by TableName 
| where list_ColumnName contains "xxx" and list_ColumnName contains "yyy" 

本文标签： kqlFind all table with multiple columns name criteriaStack Overflow