arjancornelissen

# Connect via deviceauthentication and get the TenantID and User ObjectID
Connect-MgGraph -UseDeviceAuthentication
$context = Get-MgContext
$currentUser = (Get-MgUser -UserId $context.Account).Id

# Get all available roles
$myRoles = Get-MgRoleManagementDirectoryRoleEligibilitySchedule -ExpandProperty RoleDefinition -All -Filter "principalId eq '$currentuser'"

# Get SharePoint admin role info
$myRole = $myroles | Where-Object {$_.RoleDefinition.DisplayName -eq "SharePoint Service Administrator"}

arjancornelissen

$msolusers = Get-MsolUser -All | Select-object ObjectId, WhenCreated, LastPasswordChangeTimestamp, @{n="mfaenabled";e={$_.StrongAuthenticationMethods.Count -gt 0}}
$users = Get-AzureADUser -All $true | Select-Object ObjectId, UserPrincipalName, DisplayName, @{n="onpremDN";e={$_.ExtensionProperty.onPremisesDistinguishedName}}, CompanyName, AccountEnabled, UserType

# Create empty array and do a foreach on every item, this takes a few seconds on 30.000 items
$msoluserArray = @{}
$i=0
$msolusers.foreach({
    $msoluserArray["$($psitem.ObjectId)"] = $i
    $i++
})

arjancornelissen

$msolusers = Get-MsolUser -All | Select-object ObjectId, WhenCreated, LastPasswordChangeTimestamp, @{n="mfaenabled";e={$_.StrongAuthenticationMethods.Count -gt 0}}
$users = Get-AzureADUser -All $true | Select-Object ObjectId, UserPrincipalName, DisplayName, @{n="onpremDN";e={$_.ExtensionProperty.onPremisesDistinguishedName}}, CompanyName, AccountEnabled, UserType
foreach($user in $users)
{
  $msoluser = $msolusers | where-object {$_.ObjectID -eq $user.ObjectID}
  # do something with this data
}

arjancornelissen

$mailboxes = Get-Mailbox -ResultSize Unlimited
$total = $mailboxes.Count
$count = 0
foreach($mailbox in $mailboxes){
	Write-Progress -Activity "Updating auditing: $($mailbox.UserPrincipalName) ($count or $total)" -PercentComplete ($count/$total*100)
	$count++
	Set-Mailbox -Identity $mailbox.ExternalDirectoryObjectId -DefaultAuditSet Owner, Admin, Delegate
}

arjancornelissen

# For a single Policy
Set-CsTeamsMessagingPolicy -Identity Tag:Default -AllowUserTranslation $true

# For all Policies
Get-CsTeamsMessagingPolicy | Set-CsTeamsMessagingPolicy -AllowUserTranslation $true

arjancornelissen

Import-Module SkypeOnlineConnector
$sfbSession = New-CsOnlineSession -UserName <username>
Import-PSSession $sfbSession

arjancornelissen

$roleid = Get-PrivilegedRoleAssignment | Where-Object {$_.RoleName -eq "SharePoint Service Administrator"}
Enable-PrivilegedRoleAssignment -TicketNumber "I376524" -Reason "Handling SharePoint issue" -Duration 2 -RoleId $roleid

arjancornelissen

$aaduser = Get-AzureADUser -SearchString <Cloud username>
Set-AzureADUser -ObjectId $aaduser.ObjectId -ImmutableId $ImmutableId

arjancornelissen

$user = Get-ADUser -Identity <username>
$ImmutableId = [System.convert]::ToBase64String($user.ObjectGUID.ToByteArray())

arjancornelissen

$mailboxes = Get-Mailbox -ResultSize unlimited -Filter {RecipientTypeDetails -eq "SharedMailbox" -or RecipientTypeDetails -eq "RoomMailbox" -or RecipientTypeDetails -eq "EquipmentMailbox"}

foreach($mailbox in $mailboxes)
{
  $mailboxstats = Get-MailboxStatistics -Identity $mailbox.UserPrincipalName | Select-Object DisplayName, Identity, TotalItemSize
  $mailboxsizeLine = [PSCustomObject][Ordered]@{
    Identity        = $mailbox.Identity
    UPN             = $mailbox.UserPrincipalName
    DisplayName     = $mailboxstats.DisplayName
    TotalItemSize   = $mailboxstats.TotalItemSize