Solved

Exchange Management Shell Help

Posted on 2009-04-08
5
389 Views
Last Modified: 2013-11-29
Hello all,
I need a way to extract users whose RTCSIPPrimaryUserAddress does not match thier PrimarySMTPAddress. I've tried C:\>get-mailbox -resultsize unlimited | Where-Object {$_.PrimarySMTPAddress -ne $_.RTCSIPPrimaryUserAddress} but it returns all 15,000 mailboxes.  Is there a way to filter out the SIP: from RTCSIPPrimaryUserAddress.  After I've extracted the list I will need to have these two attributes match.  i.e., user1@domain.com and sip:user1@domain.com
C:\>get-mailbox -resultsize unlimited | Where-Object {$_.PrimarySMTPAddress -ne $_.RTCSIPPrimaryUserAddress}

Open in new window

0
Comment
Question by:albertbr
  • 4
5 Comments
 
LVL 10

Expert Comment

by:jayca
ID: 24103778
Wish I could help, normally I would just say disable the users, then enable with the wizard and select the "Use email address" as the SIP URI...

Whatever you do, run DBIMPEXP before you modify anything, that way if something goes wrong, your user contacts are preserved.

Might test it out on 1 user, if you see no result, try restarting the services after the change is made...
0
 

Author Comment

by:albertbr
ID: 24116452
Using [PS] C:\>get-qaduser  -SizeLimit 100 -includedproperties Email,msRTCSIP-PrimaryUserAddress | where {$_.Email -notlike "$_.msRTCSIP-PrimaryUserAddress"} | Select Displayname, Email, msRTCSIP-PrimaryUserAddress
is still not returning mismatches.  I've tried match, notmatch, like,  notlike, etc.
Is there a way to get it to ignore "sip:"?
0
 

Author Comment

by:albertbr
ID: 24116531
Forgot to mention that the second one is done in the Quest shell.  I discovered that the exchange shell would not return the SIP property.
0
 

Accepted Solution

by:
albertbr earned 0 total points
ID: 24157142
Resolved it with:
get-qaduser -SizeLimit 0 -IncludedProperties "msRTCSIP-PrimaryUserAddress" | select name,email,"msRTCSIP-PrimaryUserAddress" | export-csv C:\report.csv
0
 

Author Comment

by:albertbr
ID: 24157163
The SIP attributes are AD and not mailbox attributes.
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
This article explains how to install and use the NTBackup utility that comes with Windows Server.
In this video we show how to create a Shared Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Recipients >> Sha…
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question