有没有办法使用 kusto 语言以编程方式检查日志分析中是否存在表?
例如,假设我想检查工作区是否包含 VMConnection 表,如下所示:
IF OBJECT_ID('*objectName*', 'U') IS NOT NULL
OR
IF (EXISTS (SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'TheSchema'
AND TABLE_NAME = 'TheTable'))
BEGIN
--Do Stuff
END
也许,您可以使用下一种技术来检查是否存在非空表:
let hasNonEmptyTable = (T:string)
{
toscalar( union isfuzzy=true ( table(T) | count as Count ), (print Count=0) | summarize sum(Count) ) > 0
};
let TableName = 'StormEvents';
print Table=TableName, IsPresent=iif(hasNonEmptyTable(TableName), "Table present", "Table not preset")
你可以尝试运行它online https://dataexplorer.azure.com/clusters/help.kusto.windows.net/databases/Samples?query=H4sIAAAAAAAEAF2PsWoDMRBEe4H%2BYbjGErhwnaA0wYUbY%2FD9gGJkW3CSDu3K4LPz79Gd4IoUC7O7b4fZwTHulo4p7sPIz97%2BDA4Gqv8gzj7eNKR41QLAiS52sFmhRJ8iPF3LND0N5%2BKgwPOp6jXeuKQSGZbwvQi9hRqrGbfe7GaGSgg2%2B8nNSi0LDY0v7KT4%2FZRiqMGWNEcb5kSbM6cc9g8XmTZ13wwXwqzcFgc6ZUcVMt5f1f%2FP1ErWTF17dmx8tw5i4jbkTkshxR%2BuG8KcIwEAAA%3D%3D using https://dataexplorer.azure.com/clusters/help/ https://dataexplorer.azure.com/clusters/help/
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)