Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,162 questions
1 answer
Use Hybrid Runbook Worker or make shorter queries to Log Analytics?
I am running a functional powershell script that queries Log Analytics for a specified time range (usually within 2 monhts), retrieves the data from Log Analytics and send it to Event Hub. Problem: Query results are very large. The following are the…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 94%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
1 answer
Upate Management Question in Azure
Hi, I have two Questions related to Azure Update Management which is enabled in Azure Automation Account for my Azure VMs When i enable Azure update management will it install the missing updates and reboot the server even if i have not enabled and…
asked 2021-05-28T00:13:22.283+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 20%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Salahuddin Khatri
1
Reputation point
commented 2021-06-03T09:58:39.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 39%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SwathiDhanwada-MSFT
18,211
Reputation points
1 answer
automation accounts: Invalid interpreter executable path
HI, I am using Hybrid worker in Automation Accounts python 3 runbook. Although the powershell command works, but the python3 runbook doesn't. It's a known issue, which is also mentioned in the documentation:…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 86%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
PowerShell Workflow Runbook about foreach -parallel
I find when I use foreach -parallel , all of them can stop ,Not all of them are running successfully,I tried to start it many times, but it still doesn't work; it said :Start-AzApplicationGateway : Long running operation failed with status 'Failed'.…
asked 2021-05-27T08:34:38.977+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 49%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWJ%3C/text%3E%3C/svg%3E)
wang jialu
51
Reputation points
accepted 2021-05-28T01:33:12.42+00:00
wang jialu
51
Reputation points
2 answers
Please help me，Workflow Runbook run error..
could you please tell me where I went wrong,my lead is anxious ? workflow MyFirstRunbook-Workflow { Disable-AzContextAutosave -Scope Process $Conn = Get-AutomationConnection -Name AzureRunAsConnection Connect-AzAccount -ServicePrincipal -Tenant…
asked 2021-05-26T03:05:51.95+00:00
Dio Wang
21
Reputation points
commented 2021-05-27T10:43:49.79+00:00
tbgangav-MSFT
10,411
Reputation points
1 answer
One of the answers was accepted by the question author.
Workflow Runbook abount AKS
I find stop use command : az aks stop --name aks-name --resource-group resource-group-name, but the command isn't use in PowerShell Workflow Runbook,I can't find the command in moduel, So we can't use PowerShell Workflow Runbook do a StopStartAKS…
asked 2021-05-27T05:41:38.067+00:00
wang jialu
51
Reputation points
commented 2021-05-27T10:18:42.397+00:00
wang jialu
51
Reputation points
1 answer
How to connect to an on-premise SQL Server from Azure Powershell runbook?
I want to export SQL Server 2016 query output into Azure blob storage account. Part of this I need to establish connection between our company SQL Server 2016 in an Azure Powershell runbook. Could anyone suggest on how can I achieve this? Thanks, …
asked 2021-05-23T07:42:40.217+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 72%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAU%3C/text%3E%3C/svg%3E)
Avireni, Upendar (Cognizant)
1
Reputation point
commented 2021-05-26T12:57:57.797+00:00
tbgangav-MSFT
10,411
Reputation points
1 answer
Facing error while running azure automation powershell runbook
Above are the screenshots attached of script run in powershell runbook and error I am facing.Can anyone help with it I have entered the correct credentials still facing this error
asked 2021-05-22T07:36:58.843+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 26%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Rashmi Goyal
1
Reputation point
commented 2021-05-23T08:52:27.563+00:00
Rashmi Goyal
1
Reputation point
3 answers
Powershell script running in Runbook
Hello Team, I am running the PowerShell script in runbook to extract the data from DB and copy in csv format in local system. Whether I am doing the right thing not sure. While running the script in run book i got an error .Please refer the screenshot :…
asked 2021-03-09T05:39:34.707+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 13%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rohit Kulkarni
686
Reputation points
commented 2021-05-23T08:25:11.217+00:00
Avireni, Upendar (Cognizant)
1
Reputation point
1 answer
What is the Run As account?
Just inherited the azure, still learning Came across the run as account needing a certificate renewal. It's a self signed certificate, but what is it used for, and what kind of havoc am I going to get if I renew it or don't renew it.
asked 2021-05-17T16:10:49.03+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 77%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Ann Naccarato
1
Reputation point
commented 2021-05-21T06:19:07.1+00:00
SwathiDhanwada-MSFT
18,211
Reputation points
1 answer
One of the answers was accepted by the question author.
How to automate triggering of copy pipeline (On-Prem to ADLS in cloud ) once file is available on-prem
Hi, We have use case where we would like to start copy activity (from on-prem to cloud) when file is available on-prem. As we don't know when the file will be available on-prem we don't want to trigger pipeline on certain time window. We want to keep…
asked 2021-05-10T19:01:37.553+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 94%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Joshi, Prasad-ZA-XT
21
Reputation points
commented 2021-05-11T12:54:37.267+00:00
Joshi, Prasad-ZA-XT
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Terraform Azure Tags for user who executed the code.
Hi, I have to add a tag in Azure Resource while deploying it through Terraform, this tag should automatically fetch username/email who executing the code. Is there anyway we can refer this in Terraform code like some function? I want to add CreatedBy…
asked 2021-05-08T10:41:10.57+00:00
Amjad Nagori
286
Reputation points
commented 2021-05-10T17:52:03.927+00:00
Amjad Nagori
286
Reputation points
1 answer
Powershell in Automation account
I want to automate self signed certificate creation and convert to pfx file. Also read pfx file to check certificate expiry date and generate new certificate accordingly. Can i do this using powershell in automation account by using azure storage account…
asked 2021-05-05T13:24:39.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 8%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Sakthi Jeganathan
21
Reputation points
commented 2021-05-10T16:58:50.69+00:00
Sakthi Jeganathan
21
Reputation points
1 answer
can a azure automation account be kept/bound in a virtual network? like a vm?
can a azure automation account be kept/bound in a virtual network? like a vm?
asked 2021-05-10T06:21:57.317+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 94%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
hitender singh
126
Reputation points
answered 2021-05-10T07:12:36.063+00:00
tbgangav-MSFT
10,411
Reputation points
2 answers
I am getting error while creating VM in Azure CLI using Katacoda
I am getting the below error while creating VM in AzureCLI using Katacoda admin user name cannot contain upper case character A-Z, special characters /"[]:|<>+=;,?*@#()!or start with $ or - Kindly help me to resolve this
asked 2020-07-10T11:00:01.197+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 13%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2021-05-09T20:45:13.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 61%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Miguel Diaz Hernandez
1
Reputation point
0 answers
Can I move Work items from one project to another with out the state defaulting back to the initial value
Comments are automatically added to the Discussion control and an entry is made to the History control. Also, the system automatically resets the State and Reason fields to the default initial values for the work item type that you move. per the…
asked 2021-04-22T19:19:31.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 6%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Stacy Monnahan
1
Reputation point
commented 2021-05-06T01:09:49.173+00:00
olufemia-MSFT
2,861
Reputation points
1 answer
Unable to find an entry point named 'GetPerAdapterInfo' in DLL 'iphlpapi.dll'
I am in Azure Automate and trying to connect to SharePoint oniline. I am running the code Connect-SPOService -url "my admin url" and getting the error message "Unable to find an entry point named 'GetPerAdapterInfo' in DLL 'iphlpapi.dll'…
asked 2021-04-28T18:46:03.47+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 89%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKJ%3C/text%3E%3C/svg%3E)
Kenyatta Jefferson
1
Reputation point
answered 2021-05-05T01:08:48.317+00:00
bharathn-msft
5,086
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure automation - dashboards
Hello, Is there any possibility to create an automation in dashboards with metrics (not metric logs, but metrics)? I need to create a metrics dashboard where all my new VMs are added in an automated way in the main dashboard so that it will…
asked 2021-04-30T07:33:35.097+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 67%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Carolina Zamisnicu
316
Reputation points
accepted 2021-05-04T14:54:04.373+00:00
Carolina Zamisnicu
316
Reputation points
1 answer
Windows Update prevent automatic reboot
Hi, looking for some solution on preventing a server from rebooting after windows updates are installed... ever. I know there is a policy "No auto-restart with logged on users for scheduled automatic updates installations" but if I am reading…
asked 2021-04-27T14:45:06.14+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 91%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CS10NET
86
Reputation points
answered 2021-05-01T23:00:42.73+00:00
olufemia-MSFT
2,861
Reputation points
1 answer
One of the answers was accepted by the question author.
Is there a way pull users with their name, email I’d but also with their group menebership using power shell
Hi All, I am trying to extract the list of users along with their group, mail etc using powershell. Is there way to get this information from cmdlet?
asked 2021-04-30T16:51:47.663+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 69%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Perumal, Janakiraman
241
Reputation points
commented 2021-05-01T03:48:08.283+00:00
Perumal, Janakiraman
241
Reputation points