need help to list users with second owner in a csv file

Question

Hello. 
 
 My Problem is, i have to list all Users in a specified OU, with entries in the Second Owner field. 
 How i can do this and export in a CSV File? 
 Would be great if someone could help. 
 
 Thanks and best regard 
 Eddi

JohnnyQuest · Accepted Answer

Here's what I think should work... 
 Get-QADUser -Sizelimit 0 -searchroot 'OU=example_Accounts_Users_external,OU=Accounts_Users_external,OU=external,OU=Users,OU=Accounts,DC=corp,DC=example,DC=com' -IncludedProperties edsvaSecondaryOwners | foreach { 
 # Store the user we are working on 
 $CurrentADUserDetails = $_ 
 # Process the secondary owners and build the additional output fields 
 $CurrentSecondaryOwners = $CurrentADUserDetails.edsvaSecondaryOwners 
 $CurrentSecondaryOwners | foreach 
 { 
 $CurrentSecondaryOwnersItem = $_ 
 # Get the samaccountname of the current Secondary Owner from the list of SecondaryOwners 
 $CurrentSecondaryOwnerSam = $(Get-QADUser -Identity $CurrentSecondaryOwnersItem).samaccountame # Results in 'JSmith' 
 $SecondaryOwnerSamList += "$CurrentSecondaryOwnerSam;" # Results in 'JSmith;FJones;' 
 # Format the CN of the Secondary Owner 
 $SecondaryOwnerCN = $_.split(",")[0] # Results in 'CN=John Smith' 
 $SecondaryOwnerCNList += "$SecondaryOwnerCN;" # Results in 'CN=John Smith;CN=Fred Jones;' 
 # Strip 'CN=' off the CN to get the 'Name' 
 $SecondaryOwnerName = $SecondaryOwnerCN.replace("CN=","") # Results in 'John Smith' 
 $SecondaryOwnerNameList += "$SecondaryOwnerName;" # Results in 'John Smith;Fred Jones;' 
 } # End of secondary owners processing 
 # Export the output 
 $CurrentADUserDetails | select Name,@{Name="SecondaryOwnerSamccountName";Expression={$SecondaryOwnerSamList}},` # Each item below builds a field name and its contents for the file @{Name="SecondaryOwnerSamccountName";Expression={$SecondaryOwnerSamList}},` @{Name="SecondaryOwnerName";Expression={$SecondaryOwnerNameList}},` @{Name="SecondaryOwnerDistinguishedNameCN";Expression={$SecondaryOwnerCNList}} | Export-CSV -Path c:	emp\UserExport2.csv -NoTypeInformation -Append 
 } # End of outer Users loop

Nick.Vance · Answer

Hey Eduard, 
 You can do this through the web interface. Browse to the OU and select it. Once the user list populates, hit the hamburger button next to the filter bar, and select "choose columns". Ensure only Name and Secondary Owners is selected. 
 The user list should now show a list of users and their secondary owners in separate columns. Click the hamburger button again and select "save to file" to export the list as a CSV.

JohnnyQuest · Answer

Had to edit the above...please re-check online version

Endpoint Privilege Management

need help to list users with second owner in a csv file

Top Replies