I am looking for a way to get all custom log tables from an Azure log analytics workspace through PowerShell code.

Below is an example of three custom log tables of which I would like to see the names in an object (array/list/...).

I am able to create a custom log table, insert and check data in it, but I am not able to upfront check if the table already exists, before I query on it.

I am using the Invoke-AzOperationalInsightsQuery PowerShell cmdlet to query on the custom log table, but this fails if the log does not exist yet. Hence the question.

Thanks for your input.

CodePudding user response：

• I have created sample custom log tables

and executed the below command

Get-AzOperationalInsightsDataSource -Kind CustomLog -ResourceGroupName RGName -WorkspaceName LogAnalyticsWorkSpaceName

Get-AzOperationalInsightsDataSource - Gets datasources under Azure Log Analytics workspace.