How to Export-CSV of Active Directory Objects

Question

I m trying to get a dump of all user records and their associated groups for a user ID revalidation effort  My security officer wants it in CSV format   This works great   Get-ADUser -Filter   -Properties     Select-Object -Property Name SamAccountName Description EmailAddress LastLogonDate Manager Title Department whenCreated Enabled Organization   Sort-Object -Property Name   ConvertTo-CSV   However  that does not include the groups the user is a member of   Attempts at something like this have failed   Get-ADUser -Filter   -Properties     Select-Object -Property Name SamAccountName Description EmailAddress LastLogonDate Manager Title Department whenCreated Enabled Organization       MemberOf  Get-Group ForEach-Object     Name     Sort-Object -Property Name   ConvertTo-CSV   This also failed   Get-ADUser -Filter   -Properties     Sort-Object -Property Name   ForEach-Object            Format-List -Property Name SamAccountName Description EmailAddress LastLogonDate Manager Title Department whenCreated Enabled        MemberOf   Get-ADGroup   ForEach-Object     Name    Sort-Object      ConvertTo-CSV   I m probably missing something simple  Any help would be greatly appreciated  Thanks

User · Answer

the first command is correct but change from convert to export to csv  as below   Get-ADUser -Filter   -Properties           Select-Object -Property Name SamAccountName Description EmailAddress LastLogonDate Manager Title Department whenCreated Enabled Organization         Sort-Object -Property Name         Export-Csv -path  C  Users   Desktop file1 csv

User · Answer

For posterity    I figured out how to get what I needed  Here it is in case it might be useful to somebody else    alist    Name tAccountName tDescription tEmailAddress tLastLogonDate tManager tTitle tDepartment tCompany twhenCreated tAcctEnabled tGroups n   userlist   Get-ADUser -Filter   -Properties     Select-Object -Property Name SamAccountName Description EmailAddress LastLogonDate Manager Title Department Company whenCreated Enabled MemberOf   Sort-Object -Property Name  userlist   ForEach-Object        grps      MemberOf   Get-ADGroup   ForEach-Object     Name    Sort-Object      arec      Name    SamAccountName    Description    EmailAddress   LastLogonDate    Manager    Title    Department    Company    whenCreated    Enabled      aline     arec -join   t       t      grps -join   t       n       alist     aline    alist   Out-File D  Temp ADUsers csv

User · Answer

HI you can try this     Try     Ad   Get-ADUser -SearchBase  OU OUi DC company DC com   -Filter   -Properties employeeNumber         employeenumber -eq      Ad   Sort-Object -Property sn  givenName   Select     Export-Csv c  scripts ceridian NoClockNumber 2013 02 12 csv -NoTypeInformation   Or   Ad   Get-ADUser -SearchBase  OU OUi DC company DC com   -Filter   -Properties employeeNumber         employeenumber -eq  null   Ad   Sort-Object -Property sn  givenName   Select     Export-Csv c  scripts cer   Hope it works for you

User · Answer

From a Windows Server OS execute the following command for a dump of the entire Active Director   csvde -f test csv   This command is very broad and will give you more than necessary information   To constrain the records to only user records  you would instead want   csvde -f test csv -r objectClass user    You can further restrict the command to give you only the fields you need relevant to the search requested such as   csvde -f test csv -r objectClass user -l DN  sAMAccountName  department  memberOf   If you have an Exchange server and each user associated with a live person has a mailbox  as opposed to generic accounts for kiosk   lab workstations  you can use mailNickname in place of sAMAccountName

User · Answer

csvde -f test csv   This command will perform a CSV dump of every entry in your Active Directory server  You should be able to see the full DN s of users and groups   You will have to go through that output file and get rid off the unnecessary content

[powershell] How to Export-CSV of Active Directory Objects?

Examples related to powershell

Examples related to active-directory