Steps
  1. Open your PowerShell Window.
  2. Copy the code given below and paste it.
  3. Run the code given below.
  4. Open your SharePoint site.
  5. Check execution completed sucessfully.
  1. Code:
  2. # -----------------------------------------------------------------------------
  3. # Script :Export Active Directory Users Value in CSV
  4. # Author : Gowtham Rajamanickam
  5. # Date : February 16 2017
  6. # Version :1.0
  7. # -----------------------------------------------------------------------------
  10. $currentdate = Get-Date -Format ddmmyyyy:ss
  12. $csvreportfile = "C:\outputfiles\reportdate.csv"
  14. #import the ActiveDirectory Module
  15. Import-Module ActiveDirectory
  18. Get-ADUser -server $ADServer -searchbase "$SearchLoc" -Properties * -Filter * |
  19. Select-Object @{Label = "First Name";Expression = {$_.GivenName}},
  20. @{Label = "LastName";Expression = {$_.Surname}},
  21. @{Label = "DisplayName";Expression = {$_.DisplayName}},
  22. @{Label = "Logon Name";Expression = {$_.sAMAccountName}},
  23. @{Label = "Job Title";Expression = {$_.Title}},
  24. @{Label = "Company";Expression = {$_.Company}},
  25. @{Label = "Description";Expression = {$_.Description}},
  26. @{Label = "Department";Expression = {$_.Department}},
  27. @{Label = "City";Expression = {$_.City}},
  28. @{Label = "State";Expression = {$_.st}},
  29. @{Label = "Post Code";Expression = {$_.PostalCode}},
  30. @{Label = "Country/Region";Expression = {if (($_.Country -eq 'GB') ) {'United Kingdom'} Else {''}}},
  32. @{Label = "Email";Expression = {$_.Mail}},
  33. @{Label = "Last LogOn Date";Expression = {$_.lastlogondate}} |
  36. Export-Csv -Path $csvreportfile -NoTypeInformation
Thanks for reading my blog.