Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 406
  • Last Modified:

Exchange Management Shell Help

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
albertbr
Asked:
albertbr
  • 4
1 Solution
 
jaycaCommented:
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
 
albertbrAuthor Commented:
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
 
albertbrAuthor Commented:
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
 
albertbrAuthor Commented:
Resolved it with:
get-qaduser -SizeLimit 0 -IncludedProperties "msRTCSIP-PrimaryUserAddress" | select name,email,"msRTCSIP-PrimaryUserAddress" | export-csv C:\report.csv
0
 
albertbrAuthor Commented:
The SIP attributes are AD and not mailbox attributes.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now