How to ingest data into Alert and AlertEvidence table in Azure Monitor Logs?
I am trying the get data in the Alert and AlertEvidence table by creating Alerts using the Alert Rule and then collecting the data by changing the Diagnostic Setting after creating the Log Analytics Workspace as suggested in the documentation. Even after multiple tries, we are getting the Alerts generated in the Alert dashboard but not getting any data in the Alert table when accessed using the KQL.
Also if we try the Logs Ingestion using the API, the Tables are not supported as per the documentation.
So I wanted to know if I'm missing any steps or if is there any alternate way to produce and get data for the Alert and AlertEvidence table as mentioned above.