Automation
Azure Automation allows you to automate the creation, monitoring, deployment, and maintenance of resources in your Azure environment using a highly-available workflow execution engine. Orchestrate time-consuming, error-prone, and frequently repeated tasks against Azure and third party systems to decrease time to value for your cloud operations.
Visit the Automation page to learn more about Automation and how to get started.
-
PowerShell cmdlet to get Runbook context.
It would be great if you could use in runbook code something like Get-RunbookContext to retrieve the current ResourceGroup and/or Automation Account the runbook is executing in. Then it would be much easier to locate Automation Account Assets like connections and variables without the need to hard-code them into your Runbook. The PowerShell commands available to retrieve and use assets require you to specify the ResourceGroup and Automation Account the asset is stored under.
56 votes -
Add support for ADAL SQL library
Currently it is not possible to connect to Azure SQL databases by using the ADAL option, like AD Username and Password.
Please make ADAL SQL available in powershell when running in the cloud.
http://stackoverflow.com/questions/39909272/azure-automation-runbook-adal-sql-support
55 votesThank you for the feedback. The product team has noted this suggestion and will consider it if resourcing allows.
-
View or export Modules
The use of modules is very important in PowerShell authoring. Currently in Azure Automation, once you import a module, there is no way to view the current code that is implemented. This is challenging when you want to update a module or are troubleshooting an existing one. You can refer to source control but there is no guarantee that is what's implemented in Prod. Being able to see what is contained in a module or at least export out the zip would be helpful.
Thanks!
Christopher
14 votesThanks for the feedback Christopher! Are you interesting in the global modules or modules that you have imported yourself to Automation?
-
Use new Azure API version2017-03-03-Preview in Set-AzOperationalInsightsSavedSearch to support new Kusto query
Please use new Azure API version2017-03-03-Preview in Set-AzOperationalInsightsSavedSearch to support new Kusto query instead API version-2015-03-xx. The old API doesn't support new Kusto queries and I receive errors like:
PS C:\Windows\system32> set-AzOperationalInsightsSavedSearch -ResourceGroupName rgvmosupdates -WorkspaceName VM-OS-Updates -DisplayName "TestQuery" -SavedSearchId testquery -Category "Updates" -Query 'Update | where UpdateState in~ ("needed", "not needed")' -Version 1
set-AzOperationalInsightsSavedSearch : This oms query language is not supported on current workspace anymore. The query cannot be converted to new language. Check query syntax.
At line:1 char:1
+ set-AzOperationalInsightsSavedSearch -ResourceGroupName rgvmosupdates ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Set-AzOperationalInsightsSavedSearch], CloudException
+ FullyQualifiedErrorId : Microsoft.Rest.Azure.CloudException,Microsoft.Azure.Commands.OperationalInsights.SetAzureOperationalInsightsSavedSearchCommand
Portal is…
14 votes -
PowerShell Cmdlets for Watcher Tasks
No cmdlets are available to interact with watcher tasks (creating, starting, stopping, getting job status, job details, etc.).
There is no way to monitor watcher tasks to check status to ensure the watcher sandbox is running.
14 votes -
Update Azure PowerShell Modules In New Azure Automation Accounts
When provisioning a new Azure Automation I would like to see an option where you can tell the service that you want all the Azure modules updated to their latest version. I believe this would save new users to the service pain when attempting to author Runbooks for the first time. This personally caused me 3 hours of pain. https://jacobbenson.io/index.php/2018/05/16/set-azurermvmcustomscriptextension-object-reference-not-set-to-an-instance-of-an-object/
13 votes -
Status on Module Import
I would really like to be able to get a status for when a module has been fully uploaded and all cmdlets have been extracted.
Currently I have to make my script sleep for a random time and not be able to extract information whether it has been fully uploaded or not.Either build a -wait property on the new-azurermautomationModule or some other thing.
10 votesWhy can’t you use the ProvisioningState property from the Get-AzureRmAutomationModule cmdlet? ProvisioningState should show as “Creating” until all the cmdlets are extracted.
As a side note since it is somewhat related. We are currently working on providing more detailed feedback in the UX on module import status so it is more apparent that the module is still extracting activities. We are also working on bubbling up underlying errors that caused activities to fail to extract.
-
Enable Publish-AzureWebsiteProject command in Runbooks
Please add this feature "Publish-AzureWebsiteProject" in future so that we can publish content to website from Runbooks using the package which is in azure storage container or by downloading package from storage container to Worker process locally temporary folder and then execute the command .Currently getting error while performing the option
9 votesThanks for posting this. We have a bug to track this issue.
-
Powershell Cmdlets to manage Automation Patch Management
Create Powershell Cmdlets to manage Azure Automation Patch Management
9 votes -
Make it easier to update tag values
Please provide an easier way to update the value of a single tag, on a single resource. ie. a VM
Current Method:
The current method requires you to obtain the entire hash table of tags on a resource (in my case a VM), update the value in the hash table, and then write the entire table back to the resource.Proposed:
New TAG cmdlets allowing simple adding, removing and updating of tags.Benefit:
Simplified dynamic manipulation of tags, allowing for simplified automation scripts. The challenge was that all suggestions online pointed to the tags being in an array, which we…7 votes -
Onboard machines for Update Management from Powershell
All the ways of onboarding VMs to Update Mangement and Inventory rely on runbooks and the portal. This isn't very helpful when your environment build is completely automated.
So whilst I can create a SoftwreUpdateConfiguration in Powershell, I can't get the servers in there to be able to run it against.
6 votes -
Increase 5MB limit for CheckPoint
Many cmdlets need to be run as InlineScript. And as Checkpoint are not available in InlineScript trying to assign the returned values from an InlineScript to a variable is a solution.... sometimes.
When dealing with larger data sets, e.g. Get-MsolUser with +1000 users this no longer works because of a 5 MB limit for a Checkpoint.4 votesThanks for posting this! How large does the data set get with you are working with a function like Get-MsolUser with 1000 users? Also, how frequently do you rely one PowerShell Workflow functionality in your scripts vs. using PowerShell and making the script idempotent?
-
Start/Stop Cloud Services Web/Worker Role using Azure Automation and RunBook
We have many Cloud Service Worker roles running on Dev environment. Dev team does not need them at night and on weekends. It will be awesome to have a RunBook which i could schedule to run at day end to to Stop these Worker Roles. can have another RunBook scheduled early morning to spin them back up.
4 votesRight now, you can stop an entire service using Stop-AzureService and start it using Start-AzureService. If you are looking for a more granular solution, you can delete a role instance (see msdn.microsoft.com/library/azure/dn469418.a..) and wrap this call in PS.
Can you let me know if you are looking for one of these solutions? If you are looking for a specific cmdlet that does not exist either as an Azure cmdlet or in the REST API, then I’ll move this request over to cloud services since they own adding this functionality.
-
set-AzureRmAutomationSchedule set start time
I would like to have the option to set the start time of a schedule in Azure Automation with the CMDlet set-AzureRmAutomationSchedule.
If you create a schedule in OMS Update Management this sets a schedule in Azure Automation, I like to have control over the start time so I can set the date based on input of my script.
This gives me more control when I want to update my environments.3 votes -
Get-AzureAutomationJob output has JobParameters as empty. Output doesnt contain the JobContextID , and the HybridWorker property is empty.
Get-AzureAutomationJob output has JobParameters as empty. Output doesnt contain the JobContextID , and the HybridWorker property is empty.
3 votesThanks for reporting this! Our team will investigate adding a fix for these issues.
-
Support the Get-AzureRmVmss Cmdlet
It seems the *-AzureRmVmss cmdlets are not supported in Automation. Specifically Get-AzureRmVmss, Update-AzureRmVmss and other cmdlets in the family. This is especially annoying since they are actually used in the "Scale Down Virtual Machine Scale Set Instances", "Scale Up Virtual Machine Scale Set Instances" Gallery runbooks.
3 votes -
Show PowerShell command line for creating any Resource when you select the resource
Showing PowerShell command line for creating a Resource when you select a similar resource from Azure Portal will help those who are working on automating the Azure tasks.
This is similar to how you show the downloadable template for any resource. You can show the PowerShell command line for achieving similar results.
3 votes -
Support PowerShell functions in Graphical Runbooks
Please add support for adding function-calls in Graphical Runbooks. Some modules (like vsTeam) do not provide cmdlets but only export PowerShell functions. This functions do not appear in the left pane and therefore cannot be used in Graphical Runbooks.
3 votes -
Provide a way to "close" TCP sockets opened by accessing Azure PaaS services
Iterating over resources (such as all storage accounts across all subscriptions) can result in thousands of open TCP sockets. This is particularly problematic for Azure runbooks which suspend runbooks execution when 1,000 sockets are reached.
Either provide a way to close such sockets (e.g. "close-AzureStorage -Context $sa.context) OR at least close sockets automatically in Azure runbooks on a least-recently-used basis. The work-around is to use hybrid runbooks but that defeats the purpose of using the built-in Azure automation.
2 votes -
User Context
Can you please help me extract the Login ID that is currently running the Run Book .As we do not have a Runbook level restriction within a Azure Automation account ,idea is to check if the current user would login to Azure Portal to execute the Runbook .Before user can execute a the script we need to check if the user is part of a AD Group .
2 votes
- Don't see your idea?