Office365 | M365 – Page 2

Find out ‘in cloud’ Distribution Groups

November 3, 2016November 3, 2016

Microsoft Teams was announced yesterday and many want to jump right in. I noticed when users wanted to create teams, new distribution groups started getting added. I wanted to find out my ‘In cloud’ distribution groups and was surprised there was no property for the item. I was able to find out the groups…

Migrate Office365 Photos to AD

November 2, 2016

Many of my customers have Office365 and have been using Skype for Business for sometime now. It is likely that your organization users have uploaded their profile picture. Now only if there was a way to sync those pictures back to your AD – so it looks neat & nice. There is a way!

#MigrateOffice365PhotosToAD.ps1

function Get-Office365Photo($EmailAddress,$Credential) {
    $wc = New-Object System.Net.WebClient
    $wc.credentials = $Credential
    # Build the URL that'll return the jpeg of the user's photo
    $url = "https://outlook.office365.com/ews/exchange.asmx/s/GetUserPhoto?email=$EmailAddress&size=HR96x96"
    # Build a path to export it to (.\kim.akers@contoso.com.jpg)
    $outPath = "$pwd\$EmailAddress.jpg"
    try { 
        # Download the image and save it to the current directory
        $wc.DownloadFile($url,$outPath)
        return $outPath
    } catch { throw $_ }
}

function Upload-ADPhoto($Username,$FilePath) {
    # Import the photo into a variable as a byte array
    $photo = [byte[]](Get-Content $FilePath -Encoding byte)
    # Replace the current value of thumbnailPhoto with the byte array from above
    Set-ADUser $Username -Replace @{ThumbnailPhoto=$photo}
}

# Get the credential to allow us to download the images
$Cred = Get-Credential -Message "Please enter your Office 365 Credentials"

# Get every mail-enabled AD user
$users = Get-ADUser -ldapfilter '(mail=*)' -properties mail

# For each of the mail-enabled users...
foreach ($user in $users) {
    try {
        # Download the photo
        $photoPath = Get-Office365Photo -EmailAddress $user.mail -Credential $Cred
        # Upload the photo
        Upload-ADPhoto -Username $user -FilePath $photoPath
    } catch {
        Write-Warning "Unable to update image for $($user.mail)"
    }
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

#MigrateOffice365PhotosToAD.ps1

function Get-Office365Photo($EmailAddress,$Credential) {

$wc = New-Object System.Net.WebClient

$wc.credentials = $Credential

# Build the URL that'll return the jpeg of the user's photo

$url = "https://outlook.office365.com/ews/exchange.asmx/s/GetUserPhoto?email=$EmailAddress&size=HR96x96"

# Build a path to export it to (.\[email protected])

$outPath = "$pwd\$EmailAddress.jpg"

try {

# Download the image and save it to the current directory

$wc.DownloadFile($url,$outPath)

return $outPath

} catch { throw $_ }

}

function Upload-ADPhoto($Username,$FilePath) {

# Import the photo into a variable as a byte array

$photo = [byte[]](Get-Content $FilePath -Encoding byte)

# Replace the current value of thumbnailPhoto with the byte array from above

Set-ADUser $Username -Replace @{ThumbnailPhoto=$photo}

}

# Get the credential to allow us to download the images

$Cred = Get-Credential -Message "Please enter your Office 365 Credentials"

# Get every mail-enabled AD user

$users = Get-ADUser -ldapfilter '(mail=*)' -properties mail

# For each of the mail-enabled users...

foreach ($user in $users) {

try {

# Download the photo

$photoPath = Get-Office365Photo -EmailAddress $user.mail -Credential $Cred

# Upload the photo

Upload-ADPhoto -Username $user -FilePath $photoPath

} catch {

Write-Warning "Unable to update image for $($user.mail)"

}

…

Active Directory: Changing passwords for users in bulk using a .csv file

October 13, 2016

Many accounts in your AD might need a password change. What if you want to do this in bulk ? First, we need to the userlist. Depending on your requirements we need to get a list of users (specifically samaccountname). For random password generation I recommend using http://manytools.org/network/password-generator/ as it can generate up 1000 for…

Extending the Booking days for Conference Room Calendar (Resource)

October 13, 2016

By default Office365 limits Resource booking days to just 180 days. The maximum days it can be booked for 1080 days. I like to make resource booking days 1 year from the day of making the reservation/ appointment. Now instead of visiting each calendar and making the change, powershell can help us out.

#Connect to Office365 
$cred = Get-Credential
Import-Module MSOnline
Connect-MsolService -Credential $cred
$s = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell -Credential $cred -Authentication Basic -AllowRedirection
$importresults = Import-PSSession $s

#Get all the Rooms and make the booking days to 365
Get-MailBox | Where {$_.ResourceType -eq "Room"} | Set-CalendarProcessing -BookingWindowInDays 365

1

2

3

4

5

6

7

8

9

#Connect to Office365

$cred = Get-Credential

Import-Module MSOnline

Connect-MsolService -Credential $cred

$s = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell -Credential $cred -Authentication Basic -AllowRedirection

$importresults = Import-PSSession $s

#Get all the Rooms and make the booking days to 365

Get-MailBox | Where {$_.ResourceType -eq "Room"} | Set-CalendarProcessing -BookingWindowInDays 365

Happy…

Disable Office group creation

July 17, 2016November 3, 2016

Every Exchange user has an OWA mailbox policy that governs what they can and can’t do with their mailbox. Updating this mailbox policy removes the ability for users to create Groups. Because OWA policies are per user, you can limit the ability to create Groups for some users and not others. At this time, the…

Saving emails in the ‘Sent Folder’ of shared mailboxes

June 16, 2016August 22, 2016

When composing a message from a shared mailbox, by default when the message is ‘sent’, it is copied to the Sent Items for the user composing the message and not the Sent Items folder onÂ the shared mailbox. Well, conveniently there is a way to enable this option in Exchange 2016 and Office365. I don’t understand…

Remove group membership of disabled accounts

April 25, 2016August 22, 2016

Majority of the system administrators I’ve met forget this very important rule. When an account is not needed remove its membership from the security/ distribution groups, otherwise you get disabled account showing up in groups, and that looks ugly. You will need Quest ActiveRoles for Powershell installed to get this working. Depending on the size…

Get a list of shared mailboxes that are accidentally licensed

March 16, 2016August 22, 2016

We know that in a hybrid scenario or during migration all shared mailboxes are migrated as a user account and then converted in a shared mailbox. Sometimes admin forget to remove the license for the shared box after conversion and there is no GUI alternative to see if the shared mailbox is licensed. Shared mailbox…

Deleting contents of a mailbox

January 21, 2016August 22, 2016

So came across an account that had 450000 items that were log files that were being captured in a mailbox. I wanted to delete all the enteries with powershell instead of going through the GUI. Here the command I used to get it done:

Search-mailbox -Identity user@domain.com -DeleteContent -Force

1	Search-mailbox -Identity user@domain.com -DeleteContent -Force

Creating a Picture Policy to use with Office365

January 18, 2016August 22, 2016

With Office365 you can have profile pictures, and this setting is enabled by default. In larger organizations you may not want this policy enabled or have a customized policy for different departments. Here’s what I had to do to disable the picture upload capability by default and use powershell to update it for individuals by…