PowerShell for Exchange

Move Mailbox

guaro5555 — Wed, 19 Jun 2013 15:59:15 GMT

I very new to powershell, so go easy on me

I need to move mailbox from one exchange to another exchange and I would like to know if this can be done by PS script

I would like to have a txt file read by the script and go through all the alias on the txt file and perform the move as it read.

would you please point me to the right direction or let me know if you have used a script like this in the past.

Thanks

Message Age and Count Report Needed

cking@unitedregional.org — Wed, 19 Jun 2013 13:54:05 GMT

I just found this forum so bare with me please.

My manager has requested an archive count/size prediction report, due today of course, on message count and size where messages are over 365 days old. We plan to implement archiving and he wants to know how many messages will be archived and how much space will be required for these messages.

I am just starting to work with Powershell and believe the Get-MailboxStatistics commandlet may be the source but I'm not sure how to produce this. My thoughts are something like using today's date and subtracting a variable (365 days in this case) to produce a report of total count of messages and total size to be archived, by mailbox if possible

Does anyone have a script that produces a message count and size by age query (by mailbox) they can share with me?j

Thanks in advance,

Chuck

Chuck King I.S. Technical Analyst United Regional Health Care System

Export-Mailbox exchange 2007

Lior — Mon, 17 Jun 2013 11:06:26 GMT

Hi,

I wrote a script that get users from group in AD, and delete all mails in those users mailbox until specific date. the script is working fine.

In the end the command "Export-Mailbox" generate report via XML file, some of the lines are:

StatusMessage : Messages have been deleted from the source mailbox.

DisplayName : LiorTest1

PrimarySmtpAddress : LiorTest1@yes.co.il

StandardMessagesDeleted : 264

AssociatedMessagesDeleted : 0

DumpsterMessagesDeleted : 0

MoveType : DeleteOnly

MoveStage : Completed

I need two things:

1) to disable this report

2) generate anther report that will include: PrimarySmtpAddress, MoveStage

(exchange 2007)

thanks

Lior

Mailbox Search

Subash — Tue, 11 Jun 2013 14:43:33 GMT

Search-Mailbox -Identity "Joe Healy" -SearchQuery 'Subject:"Project Hamilton"' -TargetMailbox "DiscoveryMailbox" -TargetFolder "JoeHealy-ProjectHamilton" -LogLevel Full

Above command return all messages contains "Project Hamilton" (For example 'Project Hamilton Report' or 'Project Hamilton Status'), how can I filter to get only 'Project Hamilton' and exclude all other results?

Delegate Calinder

Snir — Mon, 10 Jun 2013 12:59:42 GMT

Hii, i want V on checkbox "delegate receives copies of meeting related messages sent to me"

I want to make it through powershell

Thank you so much for helping

Exchange CmdLet Error

ErrorAction — Tue, 04 Jun 2013 08:19:56 GMT

Hi!

Im wondering if anyone else had any problems catching specific errors from Exchange 2010 cmdlets? It seems like no matter what I do the only way to catch an error is by not specifying the error type.

Im guessing it has something to do with Exchange cmdlets using a remote session?

Example that works:

try
{Get-DistributionGroup -Identity 'DoNotExists' -ErrorAction Stop}
catch{ Do something }

But what I really want is to catch specifik errors for example:

Grop 'DoNotExists' returned 6F0E11E5,Microsoft.Exchange.Management.RecipientTasks.GetDistributionGroup

I guess I could always do something like this:
try {Get-DistributionGroup -Identity 'DoNotExists' -ErrorAction Stop}
catch
{
if ($_.Exception -Match "*Error message...*")
{
# Do something about it
}
}

But there must be a "correct" way to catch Exchange cmdlet error types?
I would really appreciate if someone could guide me in the right direction, thanks!

Exchanged 2007, find all emails older then ...

Lior — Tue, 28 May 2013 12:59:21 GMT

Hi,

I need two things (exchange 2007):

1) To fined all emails in specific mailbox in range of dates: all emails from "date" to "date", or older then "date". need to generate report.

2) need the option to delete those emails in section 1.

need to do it with PowerShell

thanks,

Lior

Setup an Out Of Office text reply on a deprovisioned user's mailbox

bareedaa — Wed, 15 May 2013 08:19:16 GMT

I would like to Setup an Out Of Office text reply on a deprovisioned user's mailbox using powershell. I need to have auto reply whenever the user account in active directory is disabled. would you provide me the scripts?

We would like to set up auto out of office reply for disabled/deprovisioned Active Directory users. Is there a power shell script that I can use?

Help with adding a string to an existing script

Shlomo — Tue, 14 May 2013 14:56:04 GMT

Guys, I would like to know what should i use to add a manager to a user in AD i have the below script that working just fine, i just want to add the manger filed as well. #Import ActiveDirectory module Import-Module ActiveDirectory #Input New User Parameters Here $Password = ConvertTo-SecureString -string 'password go here' -asPlainText -Force $OU = 'domain.com/domain/Users' $first = 'test' $last = 'test1' $al = 'test1' $title = 'Corporate Systems Engineer' $dep = 'Sales - Engineering' #Do Not Change $displayname = $first + ' ' + $last $UPN = $al+'@domain.com' $SAM = $al #Create New Exchange User New-Mailbox -Name $displayname -Alias $al -OrganizationalUnit $OU -UserPrincipalName $UPN -SamAccountName $SAM -FirstName $first -Initials '' -LastName $last -Password $Password -ResetPasswordOnNextLogon $false Set-ADUser $al -Title $title -Department $dep Add-ADGroupMember -Identity group name -Members $al Set-ADUser $al -Replace @{showInOrgChart=$true} Set-ADUser $al -Office 'France Office' -Company domain.com.' -Title $title -Department $dep -Country FR -Description Employee #Enable User for Lync Enable-CsUser -Identity $displayname -RegistrarPool 'server address.com' -SipAddressType EmailAddress

Can I save body emails from specific sender to text file.

Yarpen — Thu, 09 May 2013 11:46:00 GMT

I want to save all emails (only body of that emails) from sender test@test.com to text files named as part of title this emails (titles are: <text> day_month_year number) in path \\server_name\test_emails\day_month_year_number.txt or c:\test_emails\day_month_year_number.txt

How can I do that using powershell ?

Exchange Scripting Question

sahinboluk — Tue, 07 May 2013 17:32:01 GMT

Hi,

I'm trying to create a script that will check to see if a user in a list (text document) is on litigation hold, and if so print it out on the screen. Below is what I have :

foreach ($alias in get-content C:\Windows\system32\scripts\testusers.txt)
    {
        Get-Mailbox -Identity $alias | fl LitigationHoldEnabled, Alias
        {
            if (LitigationHoldEnabled -eq $True)
            {
                Write-Host "$alias is on LitHold" -fore green
            }
        }

    }

The output is not what I expected :-). I think I am missing something easy here. Any help would be appreciated!

Output:

[PS] C:\Windows\system32\scripts>.\CheckLitHold.ps1

LitigationHoldEnabled : False
Alias                 : aadetola

            if (LitigationHoldEnabled -eq $True)
            {
                Write-Host "$alias is on LitHold" -fore green
            }

LitigationHoldEnabled : False
Alias                 : ABBOTTLV

            if (LitigationHoldEnabled -eq $True)
            {
                Write-Host "$alias is on LitHold" -fore green
            }

List all Shared Mailboxes and the Users / Groups who have access

Trey — Mon, 11 Mar 2013 16:50:29 GMT

Well, looks like I've stepped in it again.

I am trying to run a command that will list all of the shared mailboxes in the Exchange Org, as well as, list anyone who has full mailbox rights access. The problem I've run into is that some Shared Mailboxes also contain nested groups (universal or security) that have full mailbox access. Since I'm in an Exchange 2003 environment, I can only use powershell or vbscript.

So far, the script below has left me cross-eyed. Can anyone help me find syntax that will enumerate nested group that happens to also have full mailbox rights to a Shared Mailbox?

Get-QADUser -searchroot ‘dc=company,dc=com’ -sizelimit 0 | Get-QADPermission -ErrorAction SilentlyContinue | where { ($_.AccessRights -like “*FullAccess*”) -and ($_.IsInherited -eq $false) -and -not ($_.User -like “NT AUTHORITY\SELF”) -and -not ($_.AccountName -like “SELF”) } | foreach-object {$_.get-qadgroupmember -sizelimit 0 -indirect | select-object firstname,lastname,logonname,@{n="GroupName"}} >C:\EnumerateSharedMailbox.csv

ActiveSync Exchnage 2007

steve.timmins — Tue, 09 Apr 2013 08:44:49 GMT

Hi,

Exchange 2007

Please can someone help with a PowerShell command?

I need help with a script that I will schedule to run on a daily basis to disable ActiveSync on all mailboxes except for users which are members of a security group "Exchange ActiveSync Users".

I have disabled active sync for all users and by running the following command as a scheduled task on a daily basis any new created user’s ActiveSync gets disabled.

Get-User -ResultSize Unlimited | Where {($_.WhenCreated -gt (get-date).adddays(-1))} | Set-CASMailbox –ActiveSyncEnabled $false

Just would like to run something similar but exclude users in security group "Exchange ActiveSync Users".

Thanks

Delete All E-Mail older than XX days

Scubadave112 — Fri, 29 Mar 2013 17:57:07 GMT

I am an absolute noob when it come to powershell but I am trying to improve on that

I manage many office 365 accounts and am looking to perform certain tasks much faster.

this week I was asked to log into each user's account and delete all e-mail from the portal and this process took so long it was insane. I did some google work and saw that there are ways to do this using powershell but everything I tried did not work.

Does anyone here know of a way to accomplish this task. if you provide an example please use Dschatz as the user and Dschatz@sample.com as the email.

I tried this code:

Get-Mailbox -Identity “USERHERE” | Search-Mailbox -ContentFilter {((Received -lt ’12/06/1990) -and (Received -ge ’01/01/2013')) -DeleteContent -force

when i run this all i get are two carrots like it is waiting for my input something else looks like:

I am even willing to pay for people to help me out with this as well so if anyone has any advise or can offer assistance I would greatly appreciate it.

Thank in advance

Get PrimarySmtpAddress from a list of DisplayName

robrgr — Thu, 28 Mar 2013 18:27:07 GMT

Hello,

I can import-csv file of users full name to gather their corresponding PrimarySmtpAddress. However, I am unable to export the information to a .csv file using Export-csv. The Export-csv should list each users DisplayName, PrimarySmtpAddress, and EmailAddresses in each row and separate column. The before mentioned DisplayName, PrimarySmtpAddress, and EmailAddresses is the header for the .csv file. Any help will be much appreciated. Prior to the Export-csv I reciev the following output, which looks great, but I need the output to look great in a .csv file.

DisplayName PrimarySmtpAddress EmailAddresses

----------- ------------------ --------------

Foreach ($Mailbox in Import-Csv c:\x\x\xTest3.csv)

{

$Property = @{

Property = 'DisplayName','PrimarySmtpAddress',

@{Name="EmailAddresses";Expression={$_.EmailAddresses | `

Where-Object -FilterScript {$_.PrefixString -ceq "smtp"} | `

ForEach-Object -Process {$_.SmtpAddress}}}

}

Get-Mailbox -Identity $Mailbox.Last_Name | Select-Object @Property

}

$Mailbox |Export-Csv -Path C:\x\x\x\.csv

Extra Linebreaks in Outlook Mail Message

rkruse — Thu, 14 Mar 2013 22:35:51 GMT

I am using a function to send emails via Outlook in an automated workflow process. The following script has been stripped down to troubleshoot a problem where, once the Outlook 2007 message is brought up, there is an extra line break in the enumerated list. There are four items listed inside the here-string for $emailBody after the text 'To correct the bad invoice transmission:', but after the first one there is an extra line break. The line break does not occur elsewhere and seems to have something to do with the length of the string on that particular line, but I've tried changing buffers/etc. and cannot get rid of it. Any help or insight would be greatly appreciated!

#==== Functions ===============================================================
function Send-Email
(
[string]$toList = $(Throw "At least one email address is required!"),
[string]$ccList = $(Throw "At least one email address is required!"),
[string]$subject = $(Throw "An email subject header is required!"),
[string]$body = $(Throw "An email body is required!")#,
)
{
$vendorName = 'JUST TESTING'
write-host "Creating email message for: $vendorName"
$outlookMailItem = 0 #secret code for a mail item...
$outlookObject = New-Object -comObject Outlook.Application
$mailItem = $outlookObject.CreateItem($outlookMailItem)
$mailItem.To = "$toList"
$mailItem.cc = "$ccList"
$mailItem.Subject = $vendorName + ': ' + $subject
$mailItem.Body = $body
$inspector = $mailItem.GetInspector
$inspector.Activate()
}
#==== End Functions ===========================================================

#==== Variables ===============================================================
$emailSubject = 'Bad Invoice Data Transmission Report'
$emailBody = @"
The attached files were received by company X's EDI invoicing system after processing by some third party or whatnot. The data was incomplete or incorrect and could not be processed. Please resubmit the data including all pertinent information.`t`r`n
The problem with each is a missing or invalid Job Number and/or a missing or invalid PO Number (Sales Order Number).`t`r`n
To correct the bad invoice transmission:`t
1.Contact the party at company X who placed the order (not Jennie or anyone in the accounting department) and determine the correct PO # and Job # for each order
2.Enter the PO # correctly as denoted below.
3.Resend the Invoice through ABC to company X's EDI system`t
4.Resend the corrected Invoice Image through ABC to company X's EDI system`t`n
You can find each Invoice/Sales Order Number by one of two ways:`t
1.`tThe Invoice Number as sent to us from you is the first set of characters in the file name.`t
2.`tYou can open the attached file in notepad or any text file editor. The Invoice # is denoted as SUPPLIER_INVOICE_NUMBER=`t`n
The company X Order Number should be written as PPPPPP-JJJJJJJ where PPPPPP is the PO Number and JJJJJJ is the Job Number. company X's employees should be calling it in that way as well. IMPORTANT SEE THE '-' IN BETWEEN THE PO AND THE JOB NUMBER: THAT IS NOT A .(period) OR A SPACE BUT A -(hyphen). Again, that is the way company X should be calling it in to you as well.`n
These invoices cannot be processed into our system if we do not have correct PO Numbers and Job Numbers.
"@
$recipListSupplier = "someone@supplier.com"
$ccList = "aPerson@companyX.test"
#==== End of Variables ========================================================

write-host 'Creating email message...'
Send-Email -toList $recipListSupplier -ccList $ccList -subject $emailSubject -body $emailBody
write-host 'Finished with processing!'
start-sleep 5

How to change give "Author" permissions to a mailbox in Exchange 2010

rexican — Tue, 12 Mar 2013 15:59:49 GMT

Here is my issue:

We have a shared mailbox that two departments use. let's call it "Inventory Request Mailbox". I've created a outlook form that the users can fill out and then send. This form is coded to send to the "Inventory Request Mailbox" where the 2 departments can see.

Now here's where it gets tricky.

Originally in exchange 2003, i was able to give group A access to the mailbox and group A would be able to only modify their own email/form within that mailbox.

And group B would have full access to the forms in that mailbox

With Exchange 2010, I can't seem to duplicate that. It seems that its Full access or just read. Even if i modify the permissions in the mailbox level, it doesn't work.

I'm thinking that this can only be done via powershell. If so, can someone please explain how.

Thanks

email users with fullaccess

totalnet32 — Thu, 07 Mar 2013 13:30:39 GMT

I was hoping to email all users that have full access to shared mailboxes on one particular storage group. I need to see if I can delete shared mailboxes that are not needed. they are just regular mailboxes used for mass mailing.

I was thinking of using powershell to export all mailbox names with full access Permission and then have send-message email users with a "canned email"
With having a txt file i can test/control when and what user receive the email.

[PS] Get-Mailbox -ResultSize unlimited -database 'server\storage\db01'| Sort-Object -Property Identity | Get-MailboxPermission | where { ($_.AccessRights -eq "FullAccess") -and ($_.IsInherited -eq $false) -and -not ($_.User -like "N
T AUTHORITY\SELF") } | ft identity, user > c:\temp\text.txt

I would need the identity field to be in the subject and the user property in the TO field.
The foreach-object is giving me an issue.
please help

Powershell to list all Mailboxes who can receive mails from everyone else

gab0rlz — Thu, 28 Feb 2013 19:57:44 GMT

Hello, how are u, I'm just needing a powershell cmdlet to list all mailboxes who can receive emails from all senders

Like this pic:

Im Trying this: Get-MailBox -filter {AcceptMessagesOnlyFrom -ne $null}

But didn't works.

User statistics on Room Mailboxes

Trond Jenssen — Mon, 04 Mar 2013 14:45:15 GMT

Hi!

My boss wants me to get user statistics on our Room Mailboxes. I Guess number of Meetings pr user/owner would be sufficient.

Does anybody have a Nice PowerShell-script to accomplish this?

Thanks in advance!

Trond A Jenssen

Multiple Mailbox inbox count

Raj — Thu, 28 Feb 2013 19:10:49 GMT

Hi,

I have around 100 journaling mailboxes I check everyday twice make sure my archive software pickup and delete emails after archive. I am looking powershell script to get inbox and sent item counts of all mailboxes..

Thanks in adavance

Raj

Prepare-MoveRequest error

wspencer76 — Tue, 05 Feb 2013 23:07:52 GMT

I am running the command below from the management shell “as administrator”:

Import-Csv “c:\test\users.txt” | “.\Prepare-MoveRequest.ps1″ -RemoteForestDomainController “OldForest.local” -RemoteForestCredential $RemoteCredentials -LocalDomainController “NewForest.local” -LocalForestCredential $LocalCredentials -TargrtMailUserOU “OU=User Accounts,DC=NewForest,DC=Local -UseLocalObject -OverWriteLocalObject -Verbose

I am then receiving the following error:

You must provide a value expression on the right-hand side of the ‘-’ operator.
At line:1 char:63
+ Import-Csv “c:\test\users.txt” | “.\Prepare-MoveRequest.ps1″ – <<<<RemoteForestDomainController "OldForest.local" -RemoteForestCredential $RemoteCredentials -LocalDomainController "NewForest.local" -LocalForestCredential $LocalCredentials -TargrtMailUserOU "OU=User Accounts,DC=NewForest,DC=Local -UseLocalObject -OverWriteLocalObject -Verbose
+ CategoryInfo : ParserError: (:) [], ParentContainsErrorRecordException
+ FullyQualifiedErrorId : ExpectedValueExpression

Not sure what I'm doing wrong.

Extracting number fields read from a CSV file

ITGroup-FMI — Wed, 16 Jan 2013 15:27:14 GMT

We have created a script that gets each users mailbox size than send an email to user over a certain size. I am trying to pull just the number out but with no luck so far.

Examples: 878 MB (920,701,150 bytes), 808.3 MB (847,514,236 bytes), 722.5 MB (757,637,021 bytes)

I have tried using the .split to start at the beginning and end at the space because the size is variable in size.

Here is the sample code

$I = Get-MailboxStatistics -Identity <mailbox>
$U = Get-Mailbox -Identity <Mailbox>
$Size = $I.TotalItemSize

$SizeWK = $Size -split ' '
$SizeMB = $SizeWK -like 'MB'
If ($SizeMB -eq 'MB') {
$SizeNum = $Size.split(" ")[1]
}

Monthly Update to Public Folder Contact List

Joe — Tue, 15 Jan 2013 16:54:46 GMT

I have a task that I have to start doing once a month to update a list of contacts to a public folder. A former co-worker has done this for our company in the past and I have inherited this duty and I'm very new to powershell scripting.

So the information comes to me in a .csv that has the full list of current contacts that need to be in this list. What I am needing to know how to do is take the data from this .csv and import only the changes or new entries from this .csv into the public folder that we have on the exchange server.

I know that my predecessor used Powershell to get the information in there, so I'm sure that there is a way to do this for a monthly reoccurring process to ensure that this list is modified without having to remove the public folder and republishing the public folder and syncing it on the devices that have this list again.

We are dealing with Exchange 2010.

Thanks,

Joe

PowerShell accessing a Exchange 2003 Mailbox

lmark33322 — Thu, 03 Jan 2013 19:41:03 GMT

I'm still pretty new to PowerShell and was wondering if there is a way to control Exchange 2003 Mailboxes with PowerShell.

Specially what I am looking to do is set Out Of Office messages for different users when the request comes up.

I have been using Get-WmiObject to get information about Exchange servers, but really don't know where to go from here or if it's possible.

I've seen in Exchange 2007 and later this becomes possible and looks easier with the additional modules available, but for now I'm stuck on 2003.

Thanks all!