===== export ad user powershell script & groupe===== ====Pour exporter les utilisateurs==== PROCESS #This is where the script executes { $ADServer = "\\127.0.0.1" $SearchLoc = "CN=Users,DC=eichromlab,DC=com" $path = Split-Path -parent "$CSVReportPath\*.*" $pathexist = Test-Path -Path $path If ($pathexist -eq $false) {New-Item -type directory -Path $path} $reportdate = Get-Date -Format ssddmmyyyy $csvreportfile = $path + "\ALLADUsers_$reportdate.csv" #import the ActiveDirectory Module Import-Module ActiveDirectory #Perform AD search. The quotes "" used in $SearchLoc is essential #Without it, Export-ADUsers returuned error Get-ADUser -searchbase "$SearchLoc" -Properties * -Filter * | Select-Object @{Label = "First Name";Expression = {$_.GivenName}}, @{Label = "Last Name";Expression = {$_.Surname}}, @{Label = "Display Name";Expression = {$_.DisplayName}}, @{Label = "Logon Name";Expression = {$_.sAMAccountName}}, @{Label = "Full address";Expression = {$_.StreetAddress}}, @{Label = "City";Expression = {$_.City}}, @{Label = "State";Expression = {$_.st}}, @{Label = "Post Code";Expression = {$_.PostalCode}}, @{Label = "Country/Region";Expression = {if (($_.Country -eq 'GB') ) {'United Kingdom'} Else {''}}}, @{Label = "Job Title";Expression = {$_.Title}}, @{Label = "Company";Expression = {$_.Company}}, @{Label = "Description";Expression = {$_.Description}}, @{Label = "Department";Expression = {$_.Department}}, @{Label = "Office";Expression = {$_.OfficeName}}, @{Label = "Phone";Expression = {$_.telephoneNumber}}, @{Label = "Email";Expression = {$_.Mail}}, @{Label = "Manager";Expression = {%{(Get-AdUser $_.Manager -Properties DisplayName).DisplayName}}}, @{Label = "Account Status";Expression = {if (($_.Enabled -eq 'TRUE') ) {'Enabled'} Else {'Disabled'}}}, # the 'if statement# replaces $_.Enabled @{Label = "Last LogOn Date";Expression = {$_.lastlogondate}} | #Export CSV report Export-Csv -Encoding UTF8 -Path ./ADUser.csv -NoTypeInformation } ====Pour exporter le groupes==== Get-ADGroup -Properties managedby |select Name | Export-csv -Encoding UTF8 grp.csv Filter: * {{tag>export ad user group groupe active_directory }}