none
Active Directory Reporting Tools Windows 2003 R2

    Question

  • Can someone recommend a good free/share ware Active Directory reporting tool for AD/exchange reporting?  I need to generate AD reports on demand showing which users belong to all distribution groups in Exchange. Any recommendations would be very much appreciated.


    Dave Santel
    Tuesday, August 16, 2011 2:33 AM

Answers

  • Powershell is a scripting language (and more) that allows you to build your own reports for Active Directory.  One of the benefits is how easy it is to learn.  It is not installed on Server 2003 by default, but can be installed on your workstation to run the scripts from.  You can also download the Quest Active Directory tools to make things even easier.  A sample script would look something like this:

    Add-PSSnapin Quest.ActiveRoles.Management
    $Groups = Get-QADGroups *
    $Groups | Format-Table Name,Members -Auto | Out-File GroupsReport.txt
    

    If you would like to see more examples, visit: http://gallery.technet.microsoft.com/ScriptCenter/en-us/
    If you need some more help, we encourage questions to be posted at: http://social.technet.microsoft.com/Forums/en/ITCG/threads


    If you found this post helpful, please give it a "Helpful" vote. If it answered your question, remember to mark it as an "Answer".

    Rich Prescott | MCITP, MCTS, MCP

    Blog | Twitter: @Arposh | Powershell Client System Administration tool
    Tuesday, August 16, 2011 2:49 AM
  • Hi,

    Try Dsget and dsquery utility. run the below command.

     

    dsget group "<DN of the group>" -members

     

     You can use PowerShell (easier with 2008 R2 cmdlets): 

     

    Get-ADGroupMember "Group Name" | Get-ADUser | Select-Object Name, mail | Export-Csv -Path "C:\Temp\Output.csv" -NoTypeInformation

     

    http://social.technet.microsoft.com/wiki/contents/articles/quest-powershell-for-active-directory.aspx


    Disclaimer: This posting is provided AS-IS with no warranties or guarantees and confers no rights. 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, August 16, 2011 2:51 AM

All replies

  • Powershell is a scripting language (and more) that allows you to build your own reports for Active Directory.  One of the benefits is how easy it is to learn.  It is not installed on Server 2003 by default, but can be installed on your workstation to run the scripts from.  You can also download the Quest Active Directory tools to make things even easier.  A sample script would look something like this:

    Add-PSSnapin Quest.ActiveRoles.Management
    $Groups = Get-QADGroups *
    $Groups | Format-Table Name,Members -Auto | Out-File GroupsReport.txt
    

    If you would like to see more examples, visit: http://gallery.technet.microsoft.com/ScriptCenter/en-us/
    If you need some more help, we encourage questions to be posted at: http://social.technet.microsoft.com/Forums/en/ITCG/threads


    If you found this post helpful, please give it a "Helpful" vote. If it answered your question, remember to mark it as an "Answer".

    Rich Prescott | MCITP, MCTS, MCP

    Blog | Twitter: @Arposh | Powershell Client System Administration tool
    Tuesday, August 16, 2011 2:49 AM
  • Hi,

    Try Dsget and dsquery utility. run the below command.

     

    dsget group "<DN of the group>" -members

     

     You can use PowerShell (easier with 2008 R2 cmdlets): 

     

    Get-ADGroupMember "Group Name" | Get-ADUser | Select-Object Name, mail | Export-Csv -Path "C:\Temp\Output.csv" -NoTypeInformation

     

    http://social.technet.microsoft.com/wiki/contents/articles/quest-powershell-for-active-directory.aspx


    Disclaimer: This posting is provided AS-IS with no warranties or guarantees and confers no rights. 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, August 16, 2011 2:51 AM
  • By Using JiJi Active Directory Reports Tool you can generate upto 500 Reports in a Single Click......

    http://www.jijitechnologies.com/

    http://www.jijitechnologies.com/jiji-active-directory-reports.aspx

    Saturday, March 17, 2012 10:23 AM