Advertisement
Guest User

Untitled

a guest
Aug 15th, 2013
308
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.71 KB | None | 0 0
  1. Get-ADUser -Filter * -Properties * | Select-Object -Property Name,SamAccountName,Description,EmailAddress,LastLogonDate,Manager,Title,Department,whenCreated,Enabled,Organization | Sort-Object -Property Name | ConvertTo-CSV
  2.  
  3. 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
  4.  
  5. Get-ADUser -Filter * -Properties * | Sort-Object -Property Name | ForEach-Object {
  6. $_ | Format-List -Property Name,SamAccountName,Description,EmailAddress,LastLogonDate,Manager,Title,Department,whenCreated,Enabled
  7. $_.MemberOf | Get-ADGroup | ForEach-Object {$_.Name} | Sort-Object
  8. } | ConvertTo-CSV
  9.  
  10. $alist = "Name`tAccountName`tDescription`tEmailAddress`tLastLogonDate`tManager`tTitle`tDepartment`tCompany`twhenCreated`tAcctEnabled`tGroups`n"
  11. $userlist = Get-ADUser -Filter * -Properties * | Select-Object -Property Name,SamAccountName,Description,EmailAddress,LastLogonDate,Manager,Title,Department,Company,whenCreated,Enabled,MemberOf | Sort-Object -Property Name
  12. $userlist | ForEach-Object {
  13. $grps = $_.MemberOf | Get-ADGroup | ForEach-Object {$_.Name} | Sort-Object
  14. $arec = $_.Name,$_.SamAccountName,$_.Description,$_.EmailAddress,$_LastLogonDate,$_.Manager,$_.Title,$_.Department,$_.Company,$_.whenCreated,$_.Enabled
  15. $aline = ($arec -join "`t") + "`t" + ($grps -join "`t") + "`n"
  16. $alist += $aline
  17. }
  18. $alist | Out-File D:TempADUsers.csv
  19.  
  20. csvde -f test.csv
  21.  
  22. csvde -f test.csv
  23.  
  24. csvde -f test.csv -r objectClass=user
  25.  
  26. csvde -f test.csv -r objectClass=user -l DN, sAMAccountName, department, memberOf
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement