Christian Frohn ChrFrohn
ChrFrohn
/ Get-PrimarySMTPandRemoteRoutingAddress.ps1
Created
June 14, 2024 08:47
Get Primary SMTP address & Remote routing address
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $UserName = "" # Sample: cfp@christianfrohn.dk | |
| Get-RemoteMailbox $UserName | Select-Object RemoteRoutingAddress, PrimarySmtpAddress |
ChrFrohn
/ LifeCycleWorkflow-UserNameInput.ps1
Created
June 5, 2024 12:27
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # $ObjectId can be the users AAD object ID or email adress (UPN). | |
| param ( | |
| [Parameter (Mandatory = $true)] | |
| [object]$ObjectIdOrUPN | |
| ) |
ChrFrohn
/ AddServicePrincipalToSQL.ps1
Created
May 17, 2024 11:35
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE USER [NameOfServicerincipal] FROM EXTERNAL PROVIDER; | |
| EXEC sp_addrolemember 'db_owner', 'NameOfServicePrincipal' |
ChrFrohn
/ ConnectToTeams-ServicePrincipalWithCert.ps1
Created
November 13, 2022 18:00
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $TenantId = "" | |
| $ApplicationID = "" | |
| $CertificateThumbprint = "" | |
| Connect-MicrosoftTeams -CertificateThumbprint $CertificateThumbprint -ApplicationId $ApplicationID -TenantId $TenantId |
ChrFrohn
/ ConnectToTeams-ServicePrincipal.ps1
Last active
March 15, 2023 19:43
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ClientSecret = "" | |
| $ApplicationID = "" | |
| $TenantID = "" | |
| $graphtokenBody = @{ | |
| Grant_Type = "client_credentials" | |
| Scope = "https://graph.microsoft.com/.default" | |
| Client_Id = $ApplicationID | |
| Client_Secret = $ClientSecret | |
| } |
ChrFrohn
/ SetHolidayDate.ps1
Created
May 1, 2022 10:30
Blog - Add new dates to Teams holidays using PowerShell
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $HolidayID = Get-CsOnlineSchedule -Id "e48d56a7-461a-46b5-962c-196f6e85145d" | |
| $HolidayID.FixedSchedule.DateTimeRanges += New-CsOnlineDateTimeRange -Start "05/06/2022" -End "06/06/2022" | |
| Set-CsOnlineSchedule -Instance $HolidayID -Verbose |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $CN = "MyAppReg" #Name of your cert. | |
| $cert=New-SelfSignedCertificate -Subject "CN=$CN" -CertStoreLocation "Cert:\CurrentUser\My" -KeyExportPolicy Exportable -KeySpec Signature -NotAfter (Get-Date).AddYears(5) | |
| #Thumbprint - Make note of this | |
| $Thumbprint = $Cert.Thumbprint | |
| #Export cert. to download folder - FilePath can be changed to your linking | |
| Get-ChildItem Cert:\CurrentUser\my\$Thumbprint | Export-Certificate -FilePath $env:USERPROFILE\Downloads\AppRegCert.cer | |
| Write-Output "$Thumbprint <- Copy/paste this (save it)" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #Installs the Microsoft Graph PowerShell module - Remeber to start PowerShell as admin to be able to install. | |
| Install-Module -Name Microsoft.Graph -verbose |
ChrFrohn
/ ConnectToMSGrahphWithCert.ps1
Last active
April 23, 2022 12:02
ConnectToMSGrahphWithCert.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $AppID = "" | |
| $TenantID = "" | |
| $Thumbprint = "" | |
| Connect-MgGraph -ClientId $AppID -TenantId $TenantID -CertificateThumbprint $Thumbprint |
ChrFrohn
/ GetTeamsMeetingIDUsingJoinURL.ps1
Last active
April 3, 2022 09:36
Get Microsoft Teams meeting ID from JoinURL to be used in PowerShell with MSGraph
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #This code below will provide with you with the ID of a Teams meeting using the Join URL - The Join URL can be found in a Teams Meeting invitation | |
| #This can be used in Connection to Get-MgUserOnlineMeeting & Get-MgUserOnlineMeetingAttendanceReport | |
| Connect-MgGraph #Choose a method (Dealers choice) | |
| $UserId = "" #Can be found on the user object page in AzureAD (one of many ways) | |
| JoinURL = "" #Right click "Join Teams Meeting" in the meeting invite and paste in here | |
| $decodedUrl = [System.Web.HttpUtility]::UrlDecode($JoinUrl) #This to get rid of "%20" etc in the url |