Get-AzConsumptionUsageDetail - How to sum all PretaxCost rows returned and save to an excel or csv file?
Is there an example for how to sum the PretaxCost property for all objects returned by Get-AzConsumptionUsageDetail?
how to calculate historical usage of resources in azure
Hi guys, Hope you all are doing well. I need a help in calculating historical usage of azure resources like increase in data in adls with respect to time, processing time of databricks cluster, adf, syanapse resources for last 30 days in azure…
Azure Runbook - [AzureAD] Get-AzureADUser -All
We are implementing a Runbook which has to get all AzureAD Users - The code seems running successful and we are getting the right count of users (6453) - however, while getting the output in a JSON format, it throws the following error: the runbook job…
There has been inconsistency in Azure log analytics results
Hi team, This question has 2 problems. first problem: We are querying log analytics every minute, when we invoke the query from power shell, we are seeing the data. But one instance showed only one record, but when see it in the portal in…
Why i cant delete resource group and resources inside of the group -Terraform
I try do remove this in many ways : az group delete -n rg-terraexample Are you sure you want to perform this operation? (y/n): y Deployment failed. Correlation ID: 45329dc5-27e0-4c7e-86ed-4a05bbb27ba2. Operation failed with status: 'Conflict'.…
Unable to list subscription under a management group
I am trying to list all subscriptions under a specific Management group, and i need to exclude these subscriptions from my activity targeting all subscriptions under my Azure Tenant. I can't find any documentation about it but its really important to…
Azure Update Management fails for servers behind Log Analytics Gateway
Hello, Since a few days we can't use Update Management anymore on our on-premise servers that they are using a Log analytic Gateway to connect to Azure. The Update Agent readiness shows "Disconnected" for those servers and any update…
Create array or dictionary type variable in runbook of powershell automation
Hi All, I need to extract the list of disk type based the SKU in my runbook, Is there an option available to update the list of disk name to an variable like an List or Dictionary in Python? Set-AzAutomationVariable command updates the value, but it…
Consolidating and editing Azure Tags in bulk with no data loss or outage?
How can I rectify the below Azure Tags that is miss-spelled or has some blank space or typo error? Is there any script that can Edit and replace all the tag into the correct keyword…
Azure resource deletion error
Hi Getting below error. How to troubleshoot?
Why should we use Azure automation
Hi guys, I want to implement azure automation in my project so want to know what are the benefits I get with azure automation account. Can someone help in understand this why should I use azure automation in my project Regards,
Unable to uninstall an application with the help of Azure DSC configuration
Hi Team, We are unable to uninstall an older version of application with the help of Azure DSC. We are using the modules get-wmiobject for the same. $app = Get-WmiObject -Class Win32_Product | Where-Object { $_.Name -eq "Application…
How long does it take to shutdown and startup a vm
Dear Team, Do you have the estimate time takes to shutdown / startup a vm in correlation of its flavor size? (e.g Standard_DS1_v2, Standard_E64s_v3, Standard_M420) we are using automation to shutdown and startup vms, thus we need to know the…
AZ modules cmdlets is failing in automation runbooks using powershell scripts
Hi Team, Get-AzVM : The term 'Get-AzVM' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. I am getting the…
Auto Scale Maria database for Azure Programatically or with Runbook
Hello, Is there any way to scale up or down Azure database for Maria DB instance using Azure PowerShell or using Azure CLI? We are looking to build a webhook enabled automation runbook that can be invoked from upstream systems and get database…
Automate file transfer from REST API to Azure Blob Storage
I need to automate the download of several files (up to 100MB each) from a REST API endpoint, and then upload them to Azure Blob Storage. I need to do this using only Azure services (no local/on premises resources) on a scheduled basis. What Azure…
How to host chrome driver on azure runbook and which chrome driver version should I use?
Hi, I have python scripts that I want to scrape the website via Azure runbook. I want to know how I can host the chrome driver in the runbook, which version should I use so that I can run the python scripts from there. Could you please guide me? …
Conditional Access Link under Security section of Enterprise Application
Hi, This is regarding the Displaying of Conditional Access Link under Security section of Enterprise Application. When create the application manually we are able to see the conditional access link under Security section. But the same type of…
Namespace must be defined to use Custom Metrics
I am trying to deploy Memory metric which comes under guest metrics for a VM using Terraform, I have already defined namespace for the metric that I am using but its throwing below error. Error creating or updating metric alert "Memory Usage…
Azure Automation - InternalServerError when trying to read variable
Hello I have a runbook, part of which reads an encrypted automation variable which is created by another runbook. It has been working fine, but the variable value size has increased and now when I try and read the variable using…