Azure Automation account admin consent for API issue
We have multiple Azure subscriptions. An admin of one of these has subscriptions created an automation account, with run as privileges. That run as account in Azure AD has API permissions to Azure Active Directory Graph (as picture) - this…
Trying to add a start/stop solution on Azure VM using a second Automation account
I'm trying to add a VM start/stop solution on a second Automation second because i was not able to edit the solution on the first automation account to change the timings. Anyways, i've deleted all resources pertaining to the first Start/stop VM solution…
Runbook implement in different environments
we have one Automation account , in that we have created run book , which monitors blob container every half an hour , but , we have to create 3 scripts for 3 environments and pass the variables . is there a way we can we can pass scopes like…
Can someone help me see the differences between Azure Automation and Azure Blueprints and when to use each? (Azure lighthouse in future plan)
I was hoping to ask someone what the difference between using Azure Blueprints and Azure Automation is, it looks like I want blueprints (multiple enviroments and clients deploying parameterised ARM templates), but what am I missing about the…
import module failing in azure automation
Import module failed "Modulename" Error importing the module "name of the module". Import failed with the following error: Orchestrator.Shared.AsyncModuleImport.ModuleImportException: An error occurred during module validation. When…
execute mysql script from azure automation powershell runbook
I have a mysql dump file (essentially a mysql sql script file) which i need to run against an azure mysql database How do I do this within a powershell script in an azure automation runbook? I've used azure cloud shell to do it before and the…
How is a Digital Twin better than syncing Simulation Program on VM to Data on Azure Data Lake
I build simulations for mines in SIMIO. How are Azure Digital Twins better than simply doing the following: Step 1: Upload inputs in the form of CSV or SQL files onto an Azure Storage server. These inputs can be updated automatically every hour/day/month…
Azure Automation - updates classifeid as other is not being applyed
Hello, On my environment I detected that some updates in Azure Automation is not being applyed in VMs, this updates is classified as Others. in the image below we can see that exists 4 updates, but this updates is not is not being applyed for one…
Does enabling "Start/Stop VMs during off-hours" cause "watchers" (from process automation) to be used ?
According to the Process Automation section of the pricing page: https://azure.microsoft.com/en-us/pricing/details/automation/ Cost consists of "Job run time" and "Watchers" Does the "Start/Stop VMs during off-hours"…
How can we add the powershell scripts that are used in main powershell script in run books
I am trying to automate the kusto scripts by triggering from azure runbook instead from VM. I have a masterscript.ps1 which calls other powershell scripts. Could you please help me where should be we add the code of other powershell scripts in runbook…
Hello All, how we can use python in azure to build or automate things ? Replies appreciated.
Hello All, Started learning Python and I want to know how can I use Python to build automate Azure infra, basically IAAS services.
automate key rotation for azure resources
i want to create a funcntion that can automate the rotation of keys when they are about to expire in keyvault. basically i want that when a key is about to expire in keyvault it generates an event which in turn regenerate the key for the specific…
Azure Automate: Powershell for skype for business does not give any output back to the runbook
Hi Guys, I created a script to configure Teams Voice for a user. The scripts does configure the user ok. But it is not getting the normal output back Setup Added the skype online connector to runbook modules by uploading the zip file created a…
Automate Azure SQL edition (from Standard to Basic)
Hello, I'm trying to figure it out how to change Azure SQL tier using automation. During the day I will use Standard S0 and during the night I want to reduce to Basic. My question is about parameter perflevel. Edition -> "Basic" PerfLevel…
Automation account parallel run invoke-sqlcmd
I have a child runbook like in the following Param ( [String] $dblist ) invoke-sqlcmd -ServerInstance "xxxxxxxxx.database.windows.net" -Database $dblist -Credential $SQLServerCred -Query "$getstatsQuery"…
Error during while running Azure Runbook
Hi, this is part of bigger Runbook but I somehow keep getting errors in this part if ($vm.StorageProfile.OsDisk.OsType -eq 'Windows' -and $vmStatus -match 'VM running') { $extensions =…
Connect-AzureAD using PSCredential
I am trying to Add user into AAD group using Automation Service -Runbook Powershell. I have created a Credentials Username : XYZ pwd:ABC and then trying below Powershell script, but getting below error. Powershell script: $aadAdminCred =…
Azure automation account and SQL Server VM
Suppose I have a SQL Server VM and Azure which is domain join and I have an Azure automation account. How can I connect to this SQL Server VM from Azure automation account using Windows AD authen ? I know there is a concept of creating a…
Azure automation account sqlcmd
I would like to use invoke-sqlcmd in azure automation account . using option -query I declare a query (multi line query) $query = @' declare @var1 varchar(10) declare @var2 varchar(10)...... and some other TSQL '@ then invoke-sqlcmd…
Assigned Service Principal (Enterprise application) Sharepoint Admin role and it still can't perform sharepoint tasks with runbook. Status 'Unauthorized'
I am creating a process for with Azure Automation. I would like the process to be fully void of user credential (as expected). When I log into PnPonline with the Service Principal I try and run an operation that a Sharepoint Admin can do. My account is…