Skip to main content

Handy Office 365 commands O365





## allow remote signed
set-executionpolicy remotesigned



## to import MSONline modules into a standard powershell 

import-module MSONline

## To connection to the MSONLine service


Connect-MsolService



## Get the Credential 

$o365cred=get-credential

## Create a session 

$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell/ -Credential $o365cred -Authentication Basic -AllowRedirection
Import-PSSession $session


## Add Permission for Alan to see bob's email 

Add-MailboxPermission -identity Bob@domain.com -user Alan@domain.com -AccessRights FullAccess


## If you wanted to give Alan full access to all mailboxes in your environment you would run:

Get-Mailbox | Add-mailboxpermission -user Alan@domain.com -AccessRights FullAccess


## Create New Shared Mailbox 

$smbName = "Give it a name"
$smbAlias = "Giveitanalias"

New-Mailbox -Name $smbName -Alias $smbAlias -Shared

## Create Access permission to teh shared mailbox 

Add-MailboxPermission -identity Bob@domain.com -user Alan@domain.com -AccessRights FullAccess

## Allow SendAS rights


Add-RecipientPermission hr -Trustee khume -AccessRights SendAs


## FIND recipients based on their email address 

get-recipient -results unlimited | where {$_.emailaddresses -match "SEARCH_PHRASE_HERE"} | select name,emailaddresses,recipienttype

Get-MSOLUser -MaxResults 1 | get-member


## By default, give everyone access to a resource 

add-MailboxPermission stafffolders@xxxx.org.au -user default -accessrights FullAccess



Set-MailboxFolderPermission nsboardrm@xxxx.org.au:\Calendar -user default -accessrights owner
Set-MailboxFolderPermission nbboardrm@xxxx.org.au:\Calendar -user default -accessrights owner


## To remove an address from the GAL 


set-mailbox -identity [email address] -HiddenFromAddressListsEnabled $true

## List people in a group 


> Get-DistributionGroupMember -identity nbstaff | select DisplayName, PrimarySmtpAddress | Sort-Object PrimarySmtpAddress



#######################

Set an Auto Reply

$MyMessage = "I am currently out of the office. If the matter is urgent, please phone me xxxxx"

set-mailboxautoreplyconfiguration -identity XXXXX -AutoReplyState Scheduled -ExternalAudience All -ExternalMessage $MyMessage -InternalMessage $MyMessage  -EndTime "mm/dd/yyyy hh:mm:ss"



## Nice article on groups

http://gallery.technet.microsoft.com/office/List-all-Users-Distribution-7f2013b2

### 



## List all users where the password will expire 

Get-MsolUser | select UserPrincipalName , PasswordNeverExpires | Where-Object {$_.PasswordNeverExpires -eq $False }


## Change Password expiry for ALL users to Off 

Get-MSOLUser | Set-MsolUser -PasswordNeverExpires $true



##  Article on password expiry 
http://support.microsoft.com/kb/2666768
http://technet.microsoft.com/en-us/library/dn194133.aspx
http://community.office365.com/en-us/forums/613/t/53862.aspx




## Get Distribution Group Members and create a csv file from it 

Get-DistributionGroupMember -identity nsstaff | select name, DisplayName, PrimarySmtpAddress | Sort-Object PrimarySmtpAddress | export-csv "output.csv"


## Remove a Member from a Distribution Group


Remove-DistributionGroupMember -Identity nbstaff@xxx.org.au -Member "Anna Sloss" -BypassSecurityGroupManagerCheck


## Get last login time 

Get-mailbox -resultsize unlimited| Get-MailboxStatistics | select displayname, lastlogontime

Comments

Popular posts from this blog

Fixing a https Cert in Windows

 I renewed a https cert today in Windows and had problems with the new Cert sticking in Windows It would add fine, without error, but would disappear when the IIS Server Certificates screen would refresh.  Open the Certificates in MMC (Local Machine) and inspecting the Web Hosting gave a clue, the new certificate was there, but with a key - the private key was missing.  Could be because the original certificate was created on a completely different machine and imported to this new server.  At any rate, a simple certutil command fixed it .  A tip I received from  SSL disappears from the certificate list on Windows server - SSL Certificates - Namecheap.com Key steps are:  Double-click the certificate and go to  Details  tab. In certificate details locate the  Serial Number  field, click on it and copy its value. Open Command Prompt, pressing  Win+R  and typing  cmd , then click  OK In the command prompt type: ...

Ever need to reset a password in Bonobo Git Server ?

So, you've forgotten your password to bonobo git. Step 1: Get access to the sqlite file, probably called something like  Bonobo.Git.Server.db, sitting in the "wwwroot\Bonobo.Git.Server\App_Data" directory. Step 2: Using another tool, generate an md5 hash of your new desired password (as far as I know, sqlite does not have md5 capability) Step 3: Back in sqlite, using SQL, update the relevant user record, something like update User set Password = UPPER( 'thenewMD5hash') where Username = 'admin' ; Step 4: That's it, you are done, log in with your newly found password.

Save Attachments in Outlook automatically

For years I have wanted something to do this, and finally found it. Worked perfectly for me in Outlook 2013  In the end it is so simple. Guide from http://www.pixelchef.net/content/rule-autosave-attachment-outlook and https://msdn.microsoft.com/en-us/library/ee814736.aspx Open the VBA IDE in Outlook. Alt-F11 will do this. Insert the following code to the Modules section. On the left side there is a tree, expand until you find Modules. Then, if there is not a Module item under Modules, create one by right clicking on Modules. Or right click and choose Insert -> Module. Now, paste the text below in the main VBA window. Close the VBA IDE. Create a Rule that calls the script. Tools -> Rules and Alerts -> New Rule... In the first screen of the new rule wizard, choose "Check messages when they arrive". In the second, you could specify certain criteria that the message must match. Tip: Try "with specific words in the message header" and ...