Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Get-ADUser -Filter * -Properties * | Select-Object -Property Name,SamAccountName,Description,EmailAddress,LastLogonDate,Manager,Title,Department,whenCreated,Enabled,Organization | Sort-Object -Property Name | ConvertTo-CSV
- 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
- Get-ADUser -Filter * -Properties * | Sort-Object -Property Name | ForEach-Object {
- $_ | Format-List -Property Name,SamAccountName,Description,EmailAddress,LastLogonDate,Manager,Title,Department,whenCreated,Enabled
- $_.MemberOf | Get-ADGroup | ForEach-Object {$_.Name} | Sort-Object
- } | ConvertTo-CSV
- $alist = "Name`tAccountName`tDescription`tEmailAddress`tLastLogonDate`tManager`tTitle`tDepartment`tCompany`twhenCreated`tAcctEnabled`tGroups`n"
- $userlist = Get-ADUser -Filter * -Properties * | Select-Object -Property Name,SamAccountName,Description,EmailAddress,LastLogonDate,Manager,Title,Department,Company,whenCreated,Enabled,MemberOf | Sort-Object -Property Name
- $userlist | ForEach-Object {
- $grps = $_.MemberOf | Get-ADGroup | ForEach-Object {$_.Name} | Sort-Object
- $arec = $_.Name,$_.SamAccountName,$_.Description,$_.EmailAddress,$_LastLogonDate,$_.Manager,$_.Title,$_.Department,$_.Company,$_.whenCreated,$_.Enabled
- $aline = ($arec -join "`t") + "`t" + ($grps -join "`t") + "`n"
- $alist += $aline
- }
- $alist | Out-File D:TempADUsers.csv
- csvde -f test.csv
- csvde -f test.csv
- csvde -f test.csv -r objectClass=user
- csvde -f test.csv -r objectClass=user -l DN, sAMAccountName, department, memberOf
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement