I thought I’d share a useful little powershell trick I used today which allowed me to easily compare two very similar mailboxes in Office 365. I had a user who had a duplicate mailbox which had been inadvertently created through an issue with AAD Sync. I knew all the fields I would be comparing would…
First off lets get all the set up variables out of the way. A lot of these are the same variables I use in every script and I just copy them in each time so you may not want to use them all.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[cc lang="powershell"]$Transpath = $env:LOCALAPPDATA + "\Cloudwyse\Logs\scheduled_task_Report_" + $(get-date –Format ddMMyy_HHmmss) + ".log" Start-Transcript –Path $TransPath –NoClobber $DateTime = (Get-Date).ToString('ddMMyy_HHmmss') $ResultsPath = "C:\Cloudwyse\Scripts\Output\Scheduled_Task_Test_Output_" + $DateTime + ".csv" $Date = Get-Date –Format "dd-MM-yyyy" $Pass = cat C:\mysecurestring.txt | convertto-securestring $Cred = new-object –typename System.Management.Automation.PSCredential –argumentlist "CONTOSO\rick.sanchez",$Pass $DC = "DC01.contoso.com" $TaskReport = @() $TestedServers = 0 $OutputPath = "C:\Cloudwyse\Scripts\Output" $SplitSeparator = "" $SplitOption = [System.StringSplitOptions]::RemoveEmptyEntries[/cc] |
I like to use Write-Output to add the actions to the…
Here is a short powershell script to update job title and department in Active Directory, though this could be used to update any of the AD fields. Obviously you will need to create a CSV file beforehand which is populated with the required information. When the CSV is imported, no headers are specified in the…
This script enables you to generate a set of random complex passwords for a list of users which is imported as a CSV file. The password will contain upper and lowercase letters, symbols, numbers and will always be between 8-16 characters in length (meeting the O365 requirements). Obviously the functions can be tweaked to make…
This script gathers O365 license information for all active users. It will populate fields within a csv for import into Excel which includes UPN, Licenses, whether it is a shared mailbox or not and whether or not the user is blocked. A separate row will be created for each license, with the user’s UPN detailed…
It seems fairly obvious but a lot of people are unsure how to import a remote powershell session to O365. Simply do the following:
|
1 2 |
[cc lang="powershell"]$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection Import-PSSession $Session[/cc] |