import json payload from a rest api and save as json documents in adls gen2
Hi, I am trying to import json payload from a REST api GET method and save json documents into ADLS Gen2 using azure databricks. GET: https://myapi.com/api/v1/city GET method Output: [ {"id":2643743, …
Calling an API using powershell
Hi All. I have a curl script to call an api, but would like to use Ps to call it in the form of a loop 100 times and store he output response code i.e 200 etc. curl --location --request GET 'https://my-api-url/224/employee' \ …
Tool to create PS class from json schemas?
We have several tools to create POJO using json schema. Is there a way for powershell developers to create PS classes using json schemas defined?
![](https://techprofile.blob.core.windows.net/images/NzSFRY4LvUmCsZvxOuSTQA.png?8D80B7)
How to identify SNMP community string whether Read only or Read and Write for window
How can I identify whether SNMP community strings are 'read only' or 'Read and Write' for all versions (v1,v2c,& v3) to use PowerShell? I am only allowed to use PowerShell and SNMPWalk, for finding SNMP type on Windows servers (VM, Blade,…
Azure Automation: Cannot Authenticate from Powerapps module
Hello, I'm trying to use the powerapps administration module (https://www.powershellgallery.com/packages/Microsoft.PowerApps.Administration.PowerShell/2.0.72) inside an Azure Runbook. However when I try to authenticate using: > $pass =…
![](https://techprofile.blob.core.windows.net/images/3iv25ILLzkqjfhIGv9SWdg.png?8DA13F)
![](https://techprofile.blob.core.windows.net/images/3iv25ILLzkqjfhIGv9SWdg.png?8DA13F)
Exclude few sub folders while copying to remote server
Hi. I am trying to copy the folder and files from one server to another, based on a configuration xml. The source folder contains data as below: Backup Backup\folder1 Backup\folder2 Backup\folder3 .. like this I want to exclude folder2, folder4, folder5…
Command to get the users list for whom rsop is present.
As we know to get the RSOP from users, the users need to satisfy two criteria, 1) the user should have logged into the computer atleast for one time, 2) the user should have permission to read the group policy results. I am looking for a command/script,…
Powershell script call function based on value in excel cell
I am looking for a way to take appropriate action or call function based on value in cell of excel. e.g. if cell value has true then enable user for Skype Enterprise Voice and if value is false then first enable for Skype and then for EV as well.…
“az webapp create-remote-connection” pauses script
I'm attempting to script a backup process of a docker volume hosted in a azure linux app service, I need to create a ssh tunnel using powershell. Calling the script from task scheduler with the following : powershell -noninteractive -File…
Running a powershell script
I want t connect to powerbi service but im getting the below error: Connect-PowerBIServiceAccount : The term 'Connect-PowerBIServiceAccount' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of…
azure analysis service: how to start and pause service with on premise powershell
Hello All, I need your help. I have an azure analysis service that I want to start and pause at different times of the day. I want to use Powershell to execute a script to do this task. Do you know how I can do it? Thank you for your help
![](https://techprofile.blob.core.windows.net/images/VfQFAmOikEWfBHko2XlWTA.png?8D7F33)
Get the powershell output either propertly formatted out or directly in CSV
Below code prints output with empty lines in between. I have to manually copy output, remove empty lines and add comma in between and then copy to excel. How can we have have output like or directly save in CSV folder1, 12.34, 555,666 folder2,…
![](https://techprofile.blob.core.windows.net/images/83b87d0ad6664b86a2c2018eab8da26a.png)
![](https://techprofile.blob.core.windows.net/images/83b87d0ad6664b86a2c2018eab8da26a.png)
Powershell - Export-CliXml Structure without Nodes
Hello, iam working with PS and WSUS quite some time. I've made a script which automaticaly approves updates. Within this script i export the approved updates (Title, ID and arrivaltime) via "Export-CliXml" into a XML-File. …
![](https://techprofile.blob.core.windows.net/images/NzSFRY4LvUmCsZvxOuSTQA.png?8D80B7)
Help with Powershell New-Item Commandlet
I am trying to create new items in Powershell, however, I get caught at the Item Type. This error message pops up and I do not know how to fix it: A parameter cannot be found that matches parameter name 'FileType'. What do I need to do? This is the line…
![](https://techprofile.blob.core.windows.net/images/NzSFRY4LvUmCsZvxOuSTQA.png?8D80B7)
checking all on-premise DCs for last logon of csv list of users
Hi all, I hope all is well wherever you may be I have been asked to check the last logon of around a thousand accounts, now listed in a csv. I can run Import-csv "d:\temp\path_to.csv" |foreach-object {get-aduser $_.samaccountname…
![](https://techprofile.blob.core.windows.net/images/NzSFRY4LvUmCsZvxOuSTQA.png?8D80B7)
counting an array 10 at a time until complete
Hello, How do you loop through an array 10 at a time until complete? I would like to reboot quite a few servers in a cluster and have come up with the following but I am curious is there is a way get 10, then get the next 10 and the next 10, etc…
Robocopy not deleting source files
Hi Experts, Could you please advice on the following. Thank you. 1) Robocopy is having issues deleting the source files after the move. Below is the error. (from Robocopy.log) ERROR 32 (0x00000020) Deleting Source Directory \server01\Folder1\ The…
PowerShell DSC - Unable To Access a Share using Script Resource
Hi, I am looking to set up a DSC Script to download some files from a network share and unzip them to a location on the remote node. I cannot get the script to work, I have granted the correct permissions to the share, the receiving node has Full Control…
![](https://techprofile.blob.core.windows.net/images/NzSFRY4LvUmCsZvxOuSTQA.png?8D80B7)
Invoke-RestMethod issue with plus symbol in URL
I have an API that I access from a linux server now but it is being decommissioned so I am converting my API calls to windows. I use this call in linux and it works fine: curl…
How can I find all sub-domains using PowerShell?
I can use Resolve-Dns to retrieve an A record (if one exists) for a given domain name. Is there a way, using PowerShell, to find all sub-domains? Here's a specific use case: One of Microsoft's stated domains to allow through firewalls is:…
![](https://techprofile.blob.core.windows.net/images/278a328b7b344627b0082986fa585b70.png)