Extract information from azure monitor log data

1. Can use Transact SQL to extract information from Azure Monitor log data?
2. How do I query Azure Monitor logs?
3. How do I collect Azure logs?

Can use Transact SQL to extract information from Azure Monitor log data?

Unfortunately, you cannot run T-SQL queries in Azure Log Analytics Workspaces.

How do I query Azure Monitor logs?

Open the Log Analytics demo environment, or select Logs from the Azure Monitor menu in your subscription. This step sets the initial scope to a Log Analytics workspace so that your query selects from all data in that workspace.

How do I collect Azure logs?

Open the Custom Log wizard

The Custom Log wizard runs in the Azure portal and allows you to define a new custom log to collect. In the Azure portal, select Log Analytics workspaces > your workspace > Settings. Select Custom logs. By default, all configuration changes are automatically pushed to all agents.