There are many virtual vault solution to store the passwords like lastpass, key pass etc. Today we will go thru PowerShell Microsoft Secret Vault that you can utilize with PowerShell, you can store credentials securely and have a master password to access it. Install the below modules: Insatll-Module -Name Microsoft.PowerShell.SecretManagement Insatll-Module -Name Microsoft.PowerShell.SecretStore Let us…
We were recently developing a PowerAPP where we need to prefill the default Selected value. I was surprised to know even if you have default value selected in SharePoint list column, in PowerAPP it will come as blank. SharePoint List column: PowerAPP form Shows as below: We want when user fills the form default value…
Sharing PowerShell TIP on how to ADD an extra column to existing CSV file. I have got this requirement many a times from Tableau or PowerBI team to add an extra column Date in existing CSV file. Step 1 à $data = Import-CSV c:\csvfile.csv Import CSV file into a variable $data Step 2 à $getdate…
Microsoft has announced bringing the self-service purchase options for multiple products which many Office 365 organizations has shown concerns as they manage their subscriptions and do not want users to buy products on their own. Here is the announcement: To manage these capabilities, you need to use PowerShell MSCommerce module. Install the module from the…
Today, I am Sharing the version 2 of the PIM Admin Report Script. Reason for this another version is because existing scripts that I have previously shared are broken as Microsoft has made changes to the graph beta API. If any of my followers are using methods in the below blog posts, they need to…
Sharing a small TIP for admins searching a way to force password change without updating existing password. There are number of ways to apply force password change for office 365 users but all those ways update existing password. Number one way that comes to everyone mind is AzureAD PowerShell module but this way will force…
We were migrating one of our Client from one Tenant to Other. They want to move the transport rules on Exchange online in the first tenant to the second Tenant. Issue is that second tenant also has some transport rules, so transport rules need to be merged instead of move. Here are the Steps that…
Many of us who are working with large or small implementation of office 365 might be using Password HASH Sync as authentication method or moving towards it to simplify the architecture. I am sure many of us are already aware that PHS (Password HASH Sync) does not honor password expiry, account expiry or signin hours.…
My birthday month so sharing a script that can be used in many situations and will be very useful for System Admins. This can be used to patch the situations where one group has been used for some important work or policies but now due to new requirement there are members in some groups that…
I was working on Azure automation for one of our clients and on installing Az module from PowerShell gallery below error was received. Warning: Unable to resolve package source ‘https://www.powershellgallery.com/api/v2’. Server on which I was trying to install this module was Windows Server 2016. On researching on internet, I found this is because connection should…
