Powershell - Get information about users and export to CSV

All replies

• 

  

  1

  Sign in to vote

  This forum doesn't just write scripts for you. Learn PowerShell and attempt this issue first to let us know the SPECIFIC issues you are having.

  A rough sketch would be to join the first and last name and then do a get-aduser search using that.

  THIS IS A DUPLICATE, JUST REALISED!

  https://social.technet.microsoft.com/Forums/en-US/ef520e29-f574-4301-8e03-17c176d154c8/get-information-about-users-and-export-to-csv?forum=winserverpowershell

  ---

  Learn PowerShell                     Script Requests

  -Remember to mark the correct response as the answer-

  
  

  • Edited by I.T Delinquent Wednesday, May 30, 2018 2:03 PM

  Wednesday, May 30, 2018 8:29 AM
• 

  

  0

  Sign in to vote

  You would use Import-Csv and and Get-ADUser. Example (not tested):
  

  ---

  Import-Csv MyCSVFile.csv | ForEach-Object {
    Get-ADUser -LDAPFilter ("(&(givenName={0})(sn={1}))" -f $_.FirstName,$_.LastName) -Properties ... |
    Select-Object SurName,GivenName,DisplayName,Address,...
  } | Export-Csv NewCSVFile.Csv -NoTypeInformation
  

  ---

  You will need to put the appropriate column names from the CSV file after $_ (after the -f operator) and then put the appropriate property names after the -Properties parameter of Get-ADUser and also after Select-Object.
  

  ---

  -- Bill Stewart [Bill_Stewart]

  Wednesday, May 30, 2018 12:31 PM