Fetch Log Analytics workspace alerts types configured in a csv using powershell

[SarthakChatterjee]

Hello,

I want to create a Powershell script to find the current configured alerts in a Azure subscription and save the data in a csv file. I am interested to get the "Alert Types" in my results for all the VM's for which Alerts are configured using Log Analytics workspac

[#2]

@SarthakChatterjee 

https://azure.microsoft.com/en-gb/updates/now-available-powershell-cmdlets-for-azure-monitor-metric-...https://docs.microsoft.com/en-gb/powershell/module/az.monitor/get-azscheduledqueryrule?view=azps-2.5... 

Get-AzScheduledQueryRule -ResourceGroupName "fabrikamltdprod" | where {$_.Type}

https://docs.microsoft.com/en-us/azure/azure-monitor/platform/alerts-log

[#3]

Can you give me any alias for this command in AzureRm modules? i don't have permission to install Az.Monitor in our central instance where i need to test this. Have AzureRm modules installed there already. 

[#4]

Hi Clive, Would it be possible for you to tell me the alias command for this in AzureRm modules as i have that presently installed in my server where i need to configure this?

@CliveWatson 

[#5]

I can see OperationalInsights having some cmdlets to cater to Log Analytics workspace for AzureRm module but not exactly able to pinpoint the cmdlet to use to fetch the alert types configured for a subscription.@CliveWatson 

https://docs.microsoft.com/en-us/powershell/module/azurerm.operationalinsights/?view=azurermps-6.13....

[#6]

@SarthakChatterjee 

Sorry I'm not familiar with those, maybe someone lease can help?  This link might help?

https://docs.microsoft.com/en-us/powershell/module/azurerm.resources/get-azurermresource?view=azurer...

[#7]

Can anyone please help me with this?