As mentioned in this official Azure document, we can't configure collection of security events from the workspace using Log Analytics agent. We must use Microsoft Defender for Cloud or Microsoft Sentinel to collect security events. Azure Monitor agent can also be used to collect security events.
Few other related resources:
https://learn.microsoft.com/en-us/azure/architecture/framework/security/monitor-logs-alerts
https://learn.microsoft.com/en-us/azure/azure-monitor/reference/tables/securityevent
https://learn.microsoft.com/en-us/answers/questions/235333/index.html
https://learn.microsoft.com/en-us/answers/questions/787544/index.html