List all Azure Functions with older runtime with Powershell
When you create an Azure Function app, the runtime is responsible for executing function code on the underlying WebJobs SDK host. Azure Functions currently supports two versions of the runtime host: 4.x: Recommended runtime version for functions in all languages. 1.x: Supported only for C# apps that must use .NET Framework. This version is in maintenance mode, with enhancements… Continue Reading demiliani’s Article on...
Cancel multiple running instances of a Cloud Flow using PowerShell
/*! elementor – v3.16.0 – 09-10-2023 */ .elementor-widget-divider{–divider-border-style:none;–divider-border-width:1px;–divider-color:#0c0d0e;–divider-icon-size:20px;–divider-element-spacing:10px;–divider-pattern-height:24px;–divider-pattern-size:20px;–divider-pattern-url:none;–divider-pattern-repeat:repeat-x}.elementor-widget-divider… Continue Reading...
How to Download and Install PowerShell 7.3 on Windows 10/11 | PowerShell Installation | MindMajix – YouTube
Learn how to easily download and install PowerShell on your Windows computer in this step-by-step video tutorial. Whether you’re a beginner or an experienced user, this guide will walk you through the process with clear instructions and helpful visuals. Don’t miss out on the power of PowerShell – watch the video now and start maximizing your productivity today! 🔥 To learn PowerShell course Enroll here:...
Dataverse environment creation: use Powershell!
When you need to create a new Dataverse environment for a project, the classical way I see quite everyone doing is by going to the Power Platform Admin Center (https://admin.powerplatform.microsoft.com) and create a new environment from here: This is usually fine, but sometimes this method has a limitation that can have an impact on your project. When you create a new Dataverse… Continue Reading demiliani’s Article on...
Tip: Out-ExcelClipboard in PowerShell
From time to time I want to get some result from a PowerShell command into Excel. Unless I’m missing something, there isn’t a great option to do this in standard PowerShell. I know that you can use Export-Csv or Export-Clixml and then open the file in Excel. I know you can use Out-GridView and then copy and paste from there into Excel (albeit without the column headings). You can also use… Continue Reading...
Change flow owner without CLI or PowerShell
Let’s say you had a co-worker who left the company but they owned a few flows. How do you switch them over to a working account? If you are a maker who is not comfortable with PowerShell or Power Platform CLI and wants a way to change the owner of the Flow then follow the below steps. First, go to the solution that has cloud flow and locate the flow in question. As shown in the above… Continue Reading Danish’s...
PowerShell : List of Available Colors
Colors are great and powerful way to get your attention. Good color helps us better understand at a glance the information being displayed so we can act on that information more quickly and effectively. When using powershell, we can make use of the color when we display the information. To list up all possible colors available, we can make use of… Continue Reading thatnavguy’s Article on their blog PowerShell : List of...
How to – Connect to Exchange Online to get mailbox details (PowerShell)
Recently we were trying to figure out a few details about the user’s mailbox. To get the details – Open Windows PowerShell with the “Run as Administrator” option. Install the Exchange Online Module – Install-Module -Name ExchangeOnlineManagement Import the Exchange Online Module cmdlets – Import-Module ExchangeOnlineManagement Connect to Exchange Online using the administrator account –...
PowerShell Snippets: Prompt for Multiple Inputs
This post is part of the series on PowerShell Snippets. Over the last two posts of this series, I’ve shown PowerShell cmdlets which prompt for user input and prompt for secure entry of passwords. A PowerShell script can prompt for multiple inputs as well as output text to screen. When I originally posted about the Write-Output cmdlet, I only showed how it could be used to output text; you can… Continue Reading...
PowerShell Snippets: Prompt User for Password
This post is part of the series on PowerShell Snippets. In this last post, in this series, I showed a PowerShell snippet which would prompt a user for input. This is fine if you are prompting for a username, filename, version tag or similar, but if you are prompting for a password, you would not want to expose to people watching over the users shoulder. The Read-Host cmdlet has a parameter… Continue Reading azurecurve’s...
PowerShell Script to Change Language of SSRS Reports
Microsoft Dynamics GP ships with a set of standard SSRS reports which includes many useful reports which clients want to use. However, these reports ship with the language set to en-US which means all the numbers could out as US dollars. For a UK based client this isn’t very useful. There are also lots of reports which would need to be updated. I looked into this years ago with a colleague and… Continue Reading...
PowerShell Snippets: Prompt for User Input
This post is part of the series on PowerShell Snippets. The following PowerShell command will prompt the user to input some text which is then stored in the $ghTag parameter for later use: $ghTag = Read-Host “Please enter the tag” Click to show/hide the PowerShell Snippets Series IndexPowerShell SnippetsWrite-OutputStart-SleepPowerShell to run script bypassing execution policyUnlock BitLocker… Continue Reading...
PowerShell Snippets: Get Numeric Value from String
This post is part of the series on PowerShell Snippets. In the previous post, I showed how a single element could be retrieved from a GitHub release by executing curl and selecting the required element. I quickly discovered that the element retrieved in this was contained some additional characters and I needed only the numeric ones. The PowerShell below will extract the numeric elements of… Continue Reading azurecurve’s...
PowerShell Snippets: Get One Value from GitHub Json
This post is part of the series on PowerShell Snippets. While looking into uploading a release asset to a GitHub release, I discovered that to do this I needed the internal numeric id for a release and not just the id I’d given it. The element I needed from the GitHub json was id which can be retrieved using the below PowerShell which executes curl and then selects a single element:
PowerShell Snippets: Use Curl
This post is part of the series on PowerShell Snippets. The following PowerShell command will execute curl passing in the authorization token and json parameters defined above the curl statement. The main difference between this and curl on a normal command line is that you need to do curl.exe which is a built in alias for the Invoke-WebRequest cmdlet: $ghAuthorizationToken =… Continue Reading azurecurve’s Article on their...
PowerShell Snippets: Format Json for Curl
This post is part of the series on PowerShell Snippets. The following PowerShell shows the format required for use in Curl (which I will cover in the next post of this series). It took me a number of attempts to get the format correct; the backticks (`) are needed to escape the double quotes (“) for PowerShell and the backslashes (\) to escape them for the curl command: $json = ” {… Continue Reading...
Upload Files to SFTP via Powershell
Hello everyone. I was asked how to upload files to SFTP from Business Central, there are several ways to do it and several posts published about it for Business Central. In this case, without going through other Azure services, PowerApps etc., it is possible to do it directly and simply via Powershell and, given that the previous post on Powershell was quite successful, I also report this… Continue Reading rs’s Article on...
PowerShell Snippets: Run Application (Such as 7-zip)
This post is part of the series on PowerShell Snippets. The following PowerShell command will execute a Windows application supplying a number of parameters; in this case I am using 7-zip to compress a single one of my ClassicPress plugins to a releases folder (part of this command came from a post I did on compressing all sub folders individually: $releaseFileName = “.\Releases\$ghRepo.zip” &… Continue Reading...
PowerShell Snippets: Delete File
This post is part of the series on PowerShell Snippets. The following PowerShell command will check if the named file exists in the current directory and, if so, delete it (replace the highlighted section with the name of the file to be deleted): $FileName = “azrcrv-smtp.zip” if (Test-Path $FileName) { Remove-Item $FileName } Click to show/hide the PowerShell Snippets Series IndexPowerShell… Continue Reading...
Business Central Online, quick comparison and detection of differences between table data structures using Powershell
Business Central Online, quick comparison and detection of differences between table data structures using Powershell Previously it was possible to export data structures to files (available in runtime1), the functionality was blocked from runtime 2 onwards. Interesting function that in my opinion should be reinserted and made usable at least for On-premise. <img loading=”lazy” width=”473″...
Scottish Summit 2022 – Kenny Lowe – Automating Azure Stack HCI with MSLab and PowerShell – YouTube
In this session you will learn about how to run labs with Azure Stack HCI on almost any hardware – from laptop to multiple racks filled with servers. You will learn how to automate deployment with PowerShell and MSLab GitHub project. source
Search for a string (or a TAG) in .al files with Powershell
Search for a string (or a TAG) in .al files with Powershell Migrating, upgrading, recoding & refactoring the older versions of Dynamics NAV to Business Central you will (or can find) find a lot of documentation tracked both in the Documentation and development notes \ TAG sections within the code. By loading these sources into Azure DevOps you can use the Microsoft built-in search function to… Continue Reading rs’s...
Export SQL data to CSV or XML File via Powershell
Export SQL data to CSV or XML File via Powershell Sometimes it may be useful or necessary to use powershell to read data from SQL Server to export it to other formats This can also be used with older versions of Dynamics NAV which do not have access to the integrated powershell. Using standard powershell commands it is possible for example to read an SQL view and export it to CSV or XML file…. Continue Reading rs’s Article...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Install GP PowerShell
This post is part of the series where I am going to go hands on with installing the Microsoft Dynamics GP Fall 2021 Release and associated products. Another additional product which isn’t widely used, to the best of my knowledge, is GP PowerShell. This alows the use of PowerShell to perform actions, such as creating a new company. To install, launch the setup utility and under Additional… Continue Reading...
Download Plugin Registration Tool for Dynamics 365 CRM using PowerShell
Here’s how you can Download Plugin Registration Tool using PowerShell! Continue Reading priyeshwagh777’s Article on their blog Download Plugin Registration Tool for Dynamics 365 CRM using PowerShell If you are new to plugin development, you must’ve learnt by now that you’ll need to download and install a Plugin Registration Tool in order to register your plugin with the Dynamics 365 environment you are working...
![PowerShell Training | PowerShell Online Certification Course [PowerShell Introduction] – MindMajix – YouTube](https://i0.wp.com/365community.online/wp-content/uploads/2021/10/1634593529_maxresdefault.jpg?resize=240%2C240&ssl=1)
PowerShell Training | PowerShell Online Certification Course [PowerShell Introduction] – MindMajix – YouTube
This MindMajix video on PowerShell Training for both experienced and freshers will help to automate various maintenance and administration tasks. This PowerShell Online Training enables you to learn various concepts like fundamentals of PowerShell, building blocks of PowerShell, shell script, etc. ? To learn course Enroll here **PowerShell Training: **https://mindmajix.com/powershell-training ** ? Some Of The Topics Discussed In This...
Service to service authentication in Business Central 18.3 – How to test (REST Client & PowerShell)
In the previous blog posts I’ve described the usage scenarios around OAuth client credentials flow for Business Central and how to set it up. The next step is to test the APIs and with OAuth authentication to see if it works properly. In this post, I want to focus on the REST Client extension for VS Code and PowerShell. In the next posts, I will also cover Postman, Insomnia and C#. Version… Continue Reading ajk’s...
Calling Dataverse Web API in PowerShell using Client Credentials
Connecting to Dataverse using PowerShell can be very helpful for data migrations and use within Azure DevOps. Connecting to an instance in a non-interactive way can be tricky though. This article will provide you the links you need for creation and App registration and adding the app user to your environment. You can then utilize the script provided to call Web API requests including ones you… Continue Reading Rick A. Wilson...
Update apps installed from Appsource in Business Central Online with Powershell
Update apps installed from Appsource in Business Central Online with Powershell This post will show you how you can update apps installed from the Marketplace in Business Central Cloud with Powershell. In the example below, powershell will be used which will invoke the APIs needed to update the APPs installed from the marketplace. For convenience I added a couple of functions to the… Continue Reading rstefanetti’s Article...
Cloud Drop Beginners guide to PowerShell in Azure Functions – YouTube
Like this episode? Please like the video and subscribe to the channel. Listen in on YouTube – https://www.youtube.com/c/CloudWithChris CloudWithChris.com – https://www.cloudwithchris.com Google Podcasts – https://podcasts.google.com/feed/aHR0cHM6Ly93d3cuY2xvdWR3aXRoY2hyaXMuY29tL2VwaXNvZGUvaW5kZXgueG1s?sa=X&ved=0CAMQ4aUDahcKEwiwsr2N1ePtAhUAAAAAHQAAAAAQBA Apple Podcasts –...
Publishing apps to a Business Central Online by Powershell
Publishing apps to a Business Central Online by Powershell #1 Kinds of Apps There are 2 kinds of apps: AppSource Apps and Per Tenant Extensions (PTEs). These apps can be installed in two kinds of environments: Sandbox and Production. In Production, AppSource Apps are installed in the global scope (Global) and Per Tenant Extensions are installed in the Tenant Scope (PTE). In Sandbox… Continue Reading rstefanetti’s Article...
Deleting Application Insights telemetry data on-demand with Powershell
I think that everyone of you knows that telemetry is an important aspect to take into consideration when working with a Dynamics 365 Business Central SaaS tenant and I continuously encourage you to activate the integration with Application Insights for your production environments. In a post about this topic that I’ve written months ago, I’ve provided you a way to analyze telemetry data of… Continue Reading...
‘Exception calling “AcquireToken with “4” argument(s)” Error with Add-PowerAppsAccount PowerShell Cmdlet
To help administrators or those of the DevOps persuasion better manage and automate core tasks involving the Power Platform, Microsoft has released two PowerShell modules that you can leverage – Microsoft.PowerApps.Administration.PowerShell and Microsoft.PowerApps.PowerShell. Using these, you can accomplish tasks such as: Getting details about each environment within your tenant or even… Continue Reading The CRM...
Veronique Lengelle – Gérer SharePoint Online avec PowerShell PnP – YouTube
Dans cette session, nous verrons comment Administrateurs peuvent gérer SharePoint Online de manière effective et rapide, en utilisant the module PowerShell PnP qui a été créé par la Communauté! source
Heiko Brenn – Make PowerShell A Real Solution in 5 Steps – YouTube
“PowerShell is an awesome framework for automating and standardizing recurring tasks like user on-/off-boardings, provisioning VMs or creating new Microsoft Teams according to your governance rules. But it requires three things: 1. PowerShell know-how 2. Time to write scripts 3. Backend permissions to run scripts in your on-premises, hybrid or cloud environment. These three requirements typically limit the use of PowerShell to...
Karel Pelckmans – Kickstarting your app deployment in Microsoft Intune with PowerShell & Chocolatey – YouTube
You have many options to deploy applications through the cloud with Endpoint Manager. But lets dig in on how to hit the ground kicking on a budget and short on time. PowerShell and Chocolatey can do the heavy lifting and get you up and running in no time. source
Annette Allen – Repeatable Database Deployment to Azure using Powershell – YouTube
“In this session we will look at how to build new environments in Azure from Powershell with the minimum of effort. By storing some basic information in a database table I will show how you can deploy repeatable database builds to an Azure environment. Whether this is having the same database in multiple regions or the same database that you can use as a Dev, Test or even Live site. I will be using some Redgate tools including...
Christian Lehrer – Use PowerShell and Intune to close the gaps – YouTube
Did you ever have to create a new registry key or modify that one configuration file with Intune? PowerShell is here to help! But how to make use of PowerShell with Intune and what are the pitfalls? How to return that error or success code? How can you run a script every day? We will take a look on the mechanisms used to deploy a PowerShell script with Intune and how you can monitor it´s state. source
Luke Evans – Transitioning to PowerShell Core for Microsoft Teams Azure AD and S.P Online management – YouTube
“PowerShell has proven to be an absolutely essential tool for management, reporting and automation within Microsoft 365 for administrators, developers and architects alike. Unfortunately for some, the majority of the Microsoft 365 functionality has normally been limited to Windows based systems. Thankfully this is all about to change for the better with advent of the multi-platform PowerShell Core, which is close to reaching...
Paul Bullock – Azure Automation to the rescue! PnP PowerShell your way to the fun stuff – YouTube
Learn about setting up Azure Automation with Azure AD and automating tasks using PnP PowerShell to offload repetitive, background tasks. source
Jess Pomfret – Get your Sql Server Estate back in shape with PowerShell – YouTube
It’s not always easy to keep your SQL Servers in shape. Over time bad habits can form which can lead to poor performance, less than ideal configurations or even security concerns. In this session we’ll look at how we can use PowerShell to check on our estate (dbachecks) and then resolve those issues (dbatools) to get our SQL Servers back into the best shape of their lives. source
PowerShell: Get created date for Microsoft 365/Azure AD users
Recently I had a need in a project to get the dates that users were created/added to Microsoft 365, so it would be possible to get some statistics on how many users were added per period. As the number of users was not that big, the quicker solution was to figure out a way using Azure AD PowerShell. Prerequisite Azure AD Powershell module installed. The simpler… Continue Reading Michel Mendes’s Article on their blog How to...
PowerShell script: Get created date for Microsoft 365/Azure AD users
Recently I had a need in a project to get the dates that users were created/added to Microsoft 365, so it would be possible to get some statistics on how many users were added per period. The problem One limitation was that it should be achieved without Microsoft Graph or Microsoft Graph PowerShell. So, the choice was to figure out a way using Azure AD PowerShell. Prerequisite
Using Powershell to retrieve your Dynamics 365 Business Central telemetry
Telemetry, telemetry, telemetry… this is an hot topic in your developer’s and admin’s life in the cloud. We have talked a lot about using Application Insights for handling the telemetry data of your Dynamics 365 Business Central tenant running in the cloud and in the last events Microsoft, me and others (like my friend Duilio) explained how to use two important tools for querying your… Continue Reading...
Download all Microsoft Dynamics 365 Business Central Source Code with PowerShell
You might wonder: why would I need this? Why would I need to download source code of Business Central, while I can simply access it through the symbols when I’m working in VSCode – or even better, while I can simply click the symbol, and look at the code from there? Well … Searchability Didn’t you ever wonder: “hey, previous version, this codeunit was still in this app – where is it… Continue...
PowerShell Snippets: Output list of folders and sub-folders
This post is part of the series on PowerShell Snippets. The following PowerShell command will export a list of folders and sub-folders from the specified location (the first highlighted section is the starting folder and the second the output path for the CS file): Get-ChildItem -Path \nas3publicmovies -Recurse -Directory -ErrorAction SilentlyContinue | Select-Object FullName | Export-CSV
Download Plugin Registration Tool using PowerShell – Dynamics 365 CE
Hi Everyone, Here are the steps to download Dynamics 365 CE Plugin Registration Tool via PowerShell. 1) Type Windows Powershell in windows start menu and open it.2) Navigate to the folder where you would like download the tool. 3) Copy and paste the following PowerShell script into the PowerShell window and press Enter. [Net.ServicePointManager]::SecurityProtocol =… Continue Reading Gopinath’s Article on their blog...
Download Plugin Registration Tool using PowerShell
Hi Everyone, Here are the steps to download Dynamics 365 CE Plugin Registration Tool via PowerShell. 1) Type Windows Powershell in windows start menu and open it.2) Navigate to the folder where you would like download the tool. 3) Copy and paste the following PowerShell script into the PowerShell window and press Enter. [Net.ServicePointManager]::SecurityProtocol =… Continue Reading Gopinath’s Article on their blog...
Dynamics CRM Connect to CDS using XrmTooling from PowerShell
To connect to Common Data Service from PowerShell we can use XrmTooling cmdlet provided by Microsoft. Get List of CRM Organizations using XrmTooling cmdlet Install Microsoft.Xrm.Tooling.CrmConnector.PowerShell moduleInstall-Module -Name Microsoft.Xrm.Tooling.CrmConnector.PowerShell -scope CurrentUser Store credential in variable. Provide Username and Password for your CRM Instance$Cred =… Continue Reading BIPIN KUMAR’s...
What is PowerShell Direct?
PowerShell Direct is a feature that was rolled out with Windows 2016 and Windows 10 that enables you to interact with a virtual machine (VM) that you have running inside Hyper-V even if that VM isn’t connected to the network. It’s a great time saver as you can issue commands and carry out tasks without having to log into the VM. As I mentioned you don’t have to have the virtual machine… Continue Reading...