Azure Automation Log Analytics Query

runbook.ps1

workflow la-test
{
    
    #The name of the Automation Credential Asset this runbook will use to authenticate to Azure.
    $connectionName = "AzureRunAsConnection";
	
    #Get the credential with the above name from the Automation Asset store
    $servicePrincipalConnection = Get-AutomationConnection -Name $connectionName;
    Write-Output $servicePrincipalConnection;
    if(!$servicePrincipalConnection) {
        Throw "Could not find an Automation Credentials. Make sure you have created an Automation Account."
    }


    #Connect to your Azure Account
    Clear-AzureProfile -force
    Connect-AzureRmAccount `
        -ServicePrincipal `
        -TenantId $servicePrincipalConnection.TenantId `
        -CertificateThumbprint $servicePrincipalConnection.CertificateThumbprint `
        -ApplicationId $servicePrincipalConnection.ApplicationId `

    Write-Output "Querying..."
    $dynamicQuery = 'union * | take 10'
    $Result = Invoke-AzureRmOperationalInsightsQuery -Debug`
    -WorkspaceId "<GUID>" `
    -Query $dynamicQuery
    Write-Output $Result
}