locked
active directory users and computers RRS feed

  • Question

  • I have got ADUC and exchange installed on my machine. I also have exchange read only admin rights.

    I want to run some sort of report that for each domain account it lists their corresponding mailbox and email address, i.e.

    jsmith2 - john.smith@thiscompany.com

    Not all our AD entries have mailboxes, I think we have about 5000 though with an exchange mailbox out of 8000 domain accounts. A report to list each domin accounts corresponding email account would help me no end.

    Any idea how it could be done? Ideally with ADUC query or similar. I couldnt see a field choser to add in exchange mailbox.

     

     

    Monday, May 23, 2011 9:48 AM

Answers

  • you can use exchange powershell with a command like

    get-mailbox | Select-Object DisplayName, PrimarySmtpAddress

     

    or go to EMC, Recipient configuration, mailbox on the left hand side there is an option to export list

     

    Hope this helps

     

    Rich



    get-mailbox | Select-Object DisplayName, PrimarySmtpAddress | Export-CSV path:\output.csv

    Jonas Andersson | Microsoft Community Contributor Award 2011 | MCITP: EMA 2007/2010 | Blog: http://www.testlabs.se/blog | Follow me on twitter: jonand82
    • Proposed as answer by Sophia Xu Tuesday, May 24, 2011 9:38 AM
    • Marked as answer by Sophia Xu Sunday, May 29, 2011 12:46 PM
    Tuesday, May 24, 2011 7:50 AM
  • Hi,

    The get-mailbox command won't work in this scenario because it will only list the mailbox enabled users - not the users without a mailbox

    Leif

    • Marked as answer by Sophia Xu Sunday, May 29, 2011 12:47 PM
    Tuesday, May 24, 2011 7:58 AM

All replies

  • Hi,

    In ADUC you can add the SMTP address to the view - this means that you can see the primary SMTP address for each user in each ou. Youy should also be able to create a custom search for all users and use the same view.

    Leif

    Monday, May 23, 2011 1:18 PM
  • you can use exchange powershell with a command like

    get-mailbox | Select-Object DisplayName, PrimarySmtpAddress

     

    or go to EMC, Recipient configuration, mailbox on the left hand side there is an option to export list

     

    Hope this helps

     

    Rich


    Monday, May 23, 2011 1:25 PM
  • you can use exchange powershell with a command like

    get-mailbox | Select-Object DisplayName, PrimarySmtpAddress

     

    or go to EMC, Recipient configuration, mailbox on the left hand side there is an option to export list

     

    Hope this helps

     

    Rich



    get-mailbox | Select-Object DisplayName, PrimarySmtpAddress | Export-CSV path:\output.csv

    Jonas Andersson | Microsoft Community Contributor Award 2011 | MCITP: EMA 2007/2010 | Blog: http://www.testlabs.se/blog | Follow me on twitter: jonand82
    • Proposed as answer by Sophia Xu Tuesday, May 24, 2011 9:38 AM
    • Marked as answer by Sophia Xu Sunday, May 29, 2011 12:46 PM
    Tuesday, May 24, 2011 7:50 AM
  • Hi,

    The get-mailbox command won't work in this scenario because it will only list the mailbox enabled users - not the users without a mailbox

    Leif

    • Marked as answer by Sophia Xu Sunday, May 29, 2011 12:47 PM
    Tuesday, May 24, 2011 7:58 AM