As many of you have seen the message Skype For Business PowerShell Module will stop working after June 30, 2021. Commands have been merged with latest Teams Module but the command New-CsOnlineSession does not exists so breaking of script is evident. For all my past Scripts where the Skype module is used, I have prefixed…
Our Voice team needs a report of available numbers in Microsoft teams, they can see that in the portal as shown below but cannot see the users to whom the numbers are assigned. So I have created a simple PowerShell spell for them that can achieve this à save the report in report folder as…
I was contacted by one of our teams that is making a PowerBI dashboard for some of their licenses, they want to know the dates on which the license was assigned to the user. In this blog post I will share a Powershell Spell that can be utilized to export the report of license assignment…
I woke up one morning and seen majority of my scripts started failing with error: Exception calling “ExecuteQuery” with “0” argument(s): The underlying connection was closed On troubleshooting, it was found these were all scripts where I have utilized SharePoint Client Object Model (CSOM). After a thought I immediately pin pointed it to TLS 1.2…
This is one of my work that is being used by thousands of customers, it was downloaded more than 30000 times before Microsoft TechNet gallery was retired. (AD Health Check V1) I can still see a lot of interest in this script so parameterizing/small updates and placing it in Powershell Gallery for ease of download.…
I am releasing version 2 of the AD group members recursive function after requests from some of my followers and colleagues. This version has added functionality to show groups if you use parameter -ShowGroups $true (its optional parameter). If you are using this in your existing scripts those will continue to work as functionality has…
Today I want to share the issue that I have faced while configuring the AZURE Cost Management PowerBI App. There are couple of prerequisites to configure it, first is you should be or use Enterprise Administrator account and second PowerBI Pro license is required. Login to PowerBI https://powerbi.microsoft.com/ à go to Apps search for Cost…
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…
