Overview Bulk Export Active Directory Users and Groups to CSV File using Powershell

Overview Windows Active Directory Powershell cmdlet for Bulk Export Users and Groups Active Directory

1. What is Active Directory Powershell Script?
   1. Why using Active Directory Powershell Script?
   2. How to using Active Directory Powershell Script?
   3. Recomendation

-----------------------------------------------------------------------------------------------------------------------------

1. What is Active Directory Powershell Script?

   Active Directory Module for Windows Powershell have a great ability for Manage, Configure and Develop your Domain Controller Server, you can do AD Bulk Export Group. Whatever you need, you still can use Powershell to do your desk.
   
   In this article i need to show you on How to Export Users Member from AD Security Group or Distribution Group in Csv File and Exporting Active Directory Groups to Csv File.

   1. Why using Active Directory Powershell Script?

      Using this method very helpful if you plan due a backup, update or migrate your users and groups of active directory. This method very simple and easy, interface very small and no need a high utilization run on it.

   2. How to using Active Directory Powershell Script?

      Below sample script using powershell for doing an export to .csv file :
      • Export AD Group From Spesific OU

        get-adgroup -Filter * -SearchBase "ou=01,ou=02,ou=03,dc=yourdomainname,dc=com" | Export-Csv c:\filename.csv

        
        
      • Export Group Membership of Entire Users in OU to CSV File
        

        Get-ADGroup -Filter * -SearchBase "ou=01,ou=02,ou=03,dc=yourdomainname,dc=com" | Select-Object @{Expression={$_.Name};Label='GroupName'},@{Expression={$_.SamAccountName};Label='SamAccountName'},@{Expression={$_.GroupCategory};Label='GroupCategory'},@{Expression={$_.GroupScope};Label='GroupScope'},@{Expression={@(Get-ADGroupMember -Identity $_|Select -Expand sAMAccountName) -join ';'};Label='MembersSamAccountName'} | Export-CSV C:\yourfile.csv -NoTypeInformation

      • Export Group Membership of Spesific Group to CSV File with Spesific Attribute
        

        Get-ADGroupMember -Identity "Group Name" -Recursive | Get-ADUser -Properties Title,Department,Enabled | Select Name,Title,Department,SamAccountName,DistinguishedName | Export-CSV -Path c:\filename.csv -NoTypeInformation

      • Export Group in Spesific OU to CSV File using CSVDE Command
        

        csvde -d "ou=01,ou=02,ou=03,dc=yourdomainname,dc=com" -f c:\filename.csv

      • Export Member Group but Filter Users who are Enabled using Get-AdGroupMember
        

        Get-ADGroupMember -identity "Group" | get-aduser | Where {$_.Enabled -eq $true} | format-table name, samaccountname -autosize -Path c:\filename.csv

      • Export Group Membership of Entire Users in OU to CSV File with Spesific Attribute

        Get-ADUser -Filter * -SearchBase "ou=ou1,ou=ou2,ou=ou3,dc=yourdoman,dc=com" -Properties * | Select-Object Enabled,Name,Title,Department,SamAccountName,employeeID | Export-CSV -Path c:\testgroup.csv -NoTypeInformation

      • Export Group Membership of Entire Users in OU to CSV File with Spesific Attribute Exclude Subtree

        Get-ADUser -Filter * -SearchScope Onelevel -SearchBase "ou=Disable Account Room,ou=User Accounts,ou=WMO,dc=PHEWMO,dc=com" -Properties * | Select-Object Enabled,Name,Title,Department,SamAccountName,employeeID | Export-CSV -Path c:\testdisableroom.csv -NoTypeInformation

   3. Recomendation

      Use this method very recommended if you plan to bulk backup, update and manage your users and groups active directory. You no need type one by one, just run one script for all your users and groups active directory

Very easy enough, if you liked this article please share and subscribe for get update a new article. If you have any questions please leave your message through the comments form below, I will respond as soon as possible

** Note : Pay attention to every detail steps that informed, failure or damage to your system or data is not my responsibility "Do With Your Own Risk" or you can do research through the Lab to minimize your system failure

Tama on Google+