locked
cmdlet: Reporting RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi  Exchange wizards,

     

    Kindly help me in developing a cmdlet to report the Exchange attributes (Mailbox size etc..) of the members of a security group as a csv file.

     

    Exchange Server: 2007

     

    Many Thanks in advance

    Regards from www.windowsadmin.info
    Monday, March 14, 2011 2:31 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Will this cmdlet be helpful?

    Get-DistributionGroupMember "SG" | foreach {Get-MailboxStatistics $_.Name} | select DisplayName,TotalItemSize | export-csv c:\test.csv

    Hi ManU,

    If possible, maybe you can temp mail enable the Security Group, after you get the report, disable it.

    Frank Wang

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com  

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by emma.yoyo Monday, March 21, 2011 1:24 AM
    Wednesday, March 16, 2011 7:12 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Frank,

    That's very good.  If we are going for this solution, we may include the cmdlets “Enable-DistributionGroup -Identity "LargeMailboxUsers”  and Diable-DistributionGroup -Identity "LargeMailboxUsers” also in the ps1.

    Many Thanks

    Regards from www.windowsadmin.info
    • Marked as answer by emma.yoyo Monday, March 21, 2011 1:24 AM
    Wednesday, March 16, 2011 9:11 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    I recommend that you post this in the Exchange Server Development forum.

    Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."
    Monday, March 14, 2011 5:56 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi ManU,

    Will this cmdlet be helpful?

    Get-DistributionGroupMember "SG" | foreach {Get-MailboxStatistics $_.Name} | select DisplayName,TotalItemSize | export-csv c:\test.csv

    Frank Wang

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com  

     

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Tuesday, March 15, 2011 8:11 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Frank,

    Thank you very much for your solution. Unfortunately, I need it for a Security group. That group has some users and I have to generate a report on the users presented in that group. Couild you please help on this?

    Cheers,

    Manu

    Regards from www.windowsadmin.info
    Tuesday, March 15, 2011 8:42 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    you can try something like this:

    get-adgroupmember groupName | foreach {Get-MailboxStatistics $_.Name} | select DisplayName,TotalItemSize | export-csv c:\test.csv

    -join("74686979616775313440686F746D61696C2E636F6D"-split"(?<=\G.{2})",21|%{[char][int]"0x$_"}) www.myExchangeWorld.com This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, March 15, 2011 12:53 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Oh, I thought he was asking to develop a cmdlet, not come up with a command!
    Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."
    Tuesday, March 15, 2011 3:25 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Thiyagu,

    Thank you for your contribution. But it gives me an error:

    The term 'get-adgroupmember' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and try again.

    I think, it is because the powershell is not supporting the cmdlet (may be because of the reason that I am using WIN2K3)

    Do you have a suggestion on this?

    Thanks,

    Manu

    Regards from www.windowsadmin.info
    Wednesday, March 16, 2011 3:36 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Will this cmdlet be helpful?

    Get-DistributionGroupMember "SG" | foreach {Get-MailboxStatistics $_.Name} | select DisplayName,TotalItemSize | export-csv c:\test.csv

    Hi ManU,

    If possible, maybe you can temp mail enable the Security Group, after you get the report, disable it.

    Frank Wang

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com  

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by emma.yoyo Monday, March 21, 2011 1:24 AM
    Wednesday, March 16, 2011 7:12 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Frank,

    That's very good.  If we are going for this solution, we may include the cmdlets “Enable-DistributionGroup -Identity "LargeMailboxUsers”  and Diable-DistributionGroup -Identity "LargeMailboxUsers” also in the ps1.

    Many Thanks

    Regards from www.windowsadmin.info
    • Marked as answer by emma.yoyo Monday, March 21, 2011 1:24 AM
    Wednesday, March 16, 2011 9:11 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    The cmdlet is Get-QADGroupMember, but it is part of the Quest ActiveRoles product.  I believe that there's a free download of it here:  http://www.quest.com/powershell/activeroles-server.aspx.

    There's also the standard Get-Group.

    Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."

    Wednesday, March 16, 2011 1:47 PM