Merge PowerShell Array in to PSCustomObject (JSON)
I am working to built a function to construct a json payload for an API call. The json payload will have a main "member", but I need to add a sub-member which is really a json array. I have this…
Azure – Function App PowerShell – Publish Function with Module
Got a weird issue publishing a PowerShell Function to a Function App. The Function App uses Windows consumption with a Y1 App Service Plan. The Function uses 5 different Az Modules that exist in the Modules Directory as part of…
Visual Studio Code – Why Does PowerShell Give a False Alarm About Approved Verbs?
I rebooted my machine, and tried running the debugger again. Still fails to launch. Here's what I got. WARNING: The names of some imported commands from the module 'TchPublisherArguments' include unapproved verbs that might make them less discoverable. To find…
Azure VM PowerShell RUN Command not passing parameters
I am making an Azure CLI Run command call to a Windows VM, AZ VM run-command but cannot get the parameters to pass properly? Command to call from Azure CLI: az vm run-command invoke --resource-group 'resgrpname' --name 'hostname' --command-id 'RunPowerShellScript'…
Load JSON file into SQL Server Table with Powershell
I am trying to load a JSON file (output from Mongo's Export-MdbcData) into a SQL Server table using Powershell. The example JSON file data is as follows: { "code" : "0088", "name" : "BUTTON", "detail" : { "quantity" : 1…
Azure Automation and Logic Apps for scheduled auto-scaling of Function App
I'm trying to create an Azure automation system to change the number of always ready instances of a Function App (the App Service Plan is Elastic Premium One EP1): The Automation System is created in order to set the number…
Which timeout needs to be increased so MySQL query via PowerShell can run longer than 30 seconds?
I have a MySQL SELECT query that takes a few minutes to run when I run it in SQLyog (the GUI I use). When I try to run the identical query via PowerShell (using SimplySQL), it fails, always at 30…
How can I save all script output to a file in Powershell on Azure?
I meant to run a long Powershell script on Azure CLI which will produce some outputs. My requirement is that I need those outputs on terminals as well as in a file, Is this achievable? In Azure Shell, the history…
Can PowerShell be used to get data from Microsoft Azure Active Directory?
I cannot retrieve all the data that I want even though I can see that the data exists while I'm viewing through the portal. $users = Get-AzureADUser -All $true | ` Where-Object {$_.CompanyName -like 'CompanyName*' | ` Get-Random -Count 1000…
Azure – How can I Remove/Add a specific object on PowerShell output
I have automated the process of creating custom rules on Azure Application Gateway WAF. However, whenever I update any existing custom rule, it automatically removes all other custom rules. I have been unable to find a specific command in the…