Retrieve sign-in logs using the Microsoft Graph in a diffrent timezone
Hi Community I am currently working on automation where I need to retrieve sign-in logs using the Microsoft Graph API, specifically with the Get-MgAuditLogSignIn cmdlet. The timestamps in the logs are returned in UTC (GMT), but I need to convert these…
Unable to access Azure SQL db ressource from automation account
I am Unable to access Azure SQL db ressource from automation account runbook. I've added user access to the automation account and to the SQL server. I couldn't find a way to add the identity to the SQL database too. After all that I still getting the…
Connect-ExchangeOnline in Azure Automation account gives Unable to find type (EXO 3.5.1 PS7.2)
I have setup an Azure Automation account and loaded the EXO 3.5.1 module along with PackageManagement V1.4.8.1 and PowerShellGet v2.2.5. I open a new PowerShell runbook and just posted a Connect-ExchangeOnline -ManagedIdentity - Organisation…
How to configure alerts for long running automation runbooks
Hello , How can I set up an alert to notify me if an Automation runbook takes more than 30 minutes to complete? I have set up an alert for statuses "Completed," "Failed," and "Suspended," and receiving notifications but I am…
Automating switch between Standard HDD and Premium Disk on VMs
How can we have an automation that changes our VM's disk type to Standard HDD when we turn them off and then changes them to Premium before turning the VM back on? Is there any ready-to-use method available?
Automation runbook for start/stop VM using Storage account blob
Hi, I am trying to deploy a powershell runbook in automation account which should read contents of CSV stored in storage account blob using system assigned managed identity of automation account. Looking for a piece of code as I don't want to use sas…
How to setup Azure Automation account to restore database on SQL MI ?
Hello, I have a PowerShell script (see below) that I currently run daily from a task scheduler on a VM to restore a production database (SQL Managed Instance) to a secondary instance (SQL Managed Instance). I am planning to move this process to an Azure…
Getting an error when trying to setup Exchange Online ForwardingAddress in Azure Runbook
Hello, I am trying to setup an Azure Automation Runbook in which I convert a User Mailbox to a Shared Mailbox and setup a ForwardingAddress. I setup all the permissions and converting the mailbox is working, setting a forwarding address throws the…
[Unauthorized] : Insufficient privileges to perform requested operation by the application '00000003-0000-0000-c000-000000000000'
Hi, I am using azure automation with identity system-assigned for authentication and MS Graph with the permissions in the Screenshot to invite external users. But I have this code error: [Unauthorized] : Insufficient privileges to perform requested…
How to set up a automate rule to delete SharePoint site contact when it is expired.
Hi all, May I ask if there a way to create a Automate Flow to delete a site contact depends on the expire date? For example, I have added a column called Expire: Is there any way to get this file deleted when it is expired and send a notification out?…
Getting warning: Can't find loc string for key: Info_GotAndMaskAuth
Getting warning "Can't find loc string for key: Info_GotAndMaskAuth" when running npm custom on pipeline agent
How to disable local authentication in Azure Automation account
Hi experts, Does anyone know how to disable the local authentication in Azure Automation Account? This documentation is related to the topic, but it doesn't provide actual steps to disable the local authentication in Azure Automation Accounts.…
How to run az.automation cmdlets from inside a runbook?
From within an Azure runbook I want to run get-azautomationjob to find out information about jobs. I ran a get-command from within the runbook, and it says I have that cmdlet available. But when I run it, there is no data returned(variable is null), but…
An optimized solution for installing Wiz Runtime Sensor in all Virtual machines across our organizations Subscriptions.
Hi Team, I am currently working on an objective to install the 'Wiz Runtime Sensor' across all Virtual Machines in our organization's Azure subscriptions. I have compiled a list of active VMs that are potential candidates for this installation. As I am…
IF statement not functioning in Azure runbook
I have a runbook with a PowerShell if statement to check if the input value of a received MAC address is in a valid format. If the format is not valid I am running a cmdlet which calls a function to update the MAC address and use the updated MAC. Else if…
Azue runbook - Exchange PowerShell
We are trying to automate mail flow reporting via Azure runbooks using an app registration (service principal) to authenticate. The runbook will query Exhchange Online powershell modules for mailflow data. The only Entra permissions that seem to allow…
New-AzureADApplicationKeyCredential - Thumbprint not available issue
Hi, We have noticed that when we try to upload azure self signed certificate to Azure AD App registration from powershell using the cmdlet New-AzureADApplicationKeyCredential, we are not able to see the certificate thumbprint in the portal, App…
Webhook payload runon Azure vs Hybrid worker
I am working with azure automation, triggered by webhooks. Typically this runs directly on Azure and works fine, the webhook data payload is received and handled as a PSCustomObject. I now need to run the same on a Hybrid Worker because of a OnPrem…
ExchangeOnlineManagement authentication broken in Azure Automation Runbook
Since the morning of Thursday 9 Feb 2023, I've not been able to successfully authenticate with ExchangeOnlineManagement via an Azure Automation runbook using either a credential flow or Managed Identity. I can replicate this issue across three different…