Advertisement
naveenk232

powershell

Jan 19th, 2012
256
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. I have a AD query to export all group membership , that works perfectly.
  2.  
  3. Get-QADUser -searchRoot $OuDomain -SizeLimit 0 | Select-Object dn, sAMAccountName, @{Name="Groups";Expression={(Get-QADMemberOf $_ | Select-Object -expandProperty Name) -join
  4. ";"}} | export-csv $FilePath | Sort-Object SamAccountName
  5.  
  6. Result -
  7.  
  8. DN  SamAccountName  Groups
  9. abc.com     user1      group1;group2;group3
  10.  
  11. How to export the above result sin column ....like user1 group1
  12.                                                    user1 group2
  13.                                                    user1 group3
  14.  
  15. DN  SamAccountName  Groups
  16. abc.com  user1          group1
  17.          user1          group2
  18.          user1          group3
  19.  
  20. I want the output in  columns , presently I am getting all export in one row.
  21.  
  22. Thanks for your help.
  23.  
  24. Rgds
  25. Naveen
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement