powershell Questions

Ubuntu – How to convert a specific CSV column to TitleCase with PowerShell from the REPL console?

Revised efforts based on supplied answers: PS /home/nicholas/powershell> PS /home/nicholas/powershell> Get-Content ./case.csv | ForEach-Object ToUpper FJKDLA,W FKDSLAJF,FDJK;A NLK;NBF;SDJF,DGDF VNL;KKDF,BGNGFN NVCL;V,RGS NVKL;,THRN VLKDF,TMMJYMF FJDK,FDJK;A PS /home/nicholas/powershell> PS /home/nicholas/powershell> Get-Content ./case.csv | ForEach-Object ToLower fjkdla,w fkdslajf,fdjk;a nlk;nbf;sdjf,dgdf vnl;kkdf,bgngfn nvcl;v,rgs nvkl;,thrn vlkdf,tmmjymf fjdk,fdjk;a…

VIEW QUESTION

Json – Microsoft Graph PowerShell Invoke-RestMethod to POST to the Calendar with multiple events

June 14, 2023
bickyz
3 Answers

I have following PowerShell script which add event on the Office 365 group calendar. When I run the following script, it will only add the first event but not the second one. And there is no error. Have I missed…

VIEW QUESTION

Azure Automation Runbook fails to complete with no error

June 13, 2023
Damo
2 Answers

I'm attempting to run a backup of an API Management service. I can do this in PS from my local machine without issue using the code below under my sub owner login context. When I attempt to run it as…

VIEW QUESTION

Merge PowerShell Array in to PSCustomObject (JSON)

June 13, 2023
James
2 Answers

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…

VIEW QUESTION

Azure – Function App PowerShell – Publish Function with Module

June 13, 2023
mrptsai
2 Answers

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…

VIEW QUESTION

Visual Studio Code – Why Does PowerShell Give a False Alarm About Approved Verbs?

June 13, 2023
aksarben
3 Answers

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…

VIEW QUESTION

Azure VM PowerShell RUN Command not passing parameters

June 13, 2023
Troy Shane
2 Answers

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'…

VIEW QUESTION

Load JSON file into SQL Server Table with Powershell

June 13, 2023
Cenko
2 Answers

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…

VIEW QUESTION

Azure Automation and Logic Apps for scheduled auto-scaling of Function App

June 13, 2023
gregory
2 Answers

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…

VIEW QUESTION

Which timeout needs to be increased so MySQL query via PowerShell can run longer than 30 seconds?

June 2, 2023
Kevin Weinrich
2 Answers

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…

VIEW QUESTION