PowerShell Eliminating Few Output Columns While Showing Result

hi,

i'm using powershell export active directory user properties. i'm typing below command in powershell result.

get-aduser rtp -properties employeeid,name,givenname,sn,displayname,samaccountname,mail,department,title,mobile,manager,company |select -property employeeid,name,givenname,sn,displayname,samaccountname,mail,department,title,mobile,manager,company|ft -autosize |out-string -width 4096 |out-file d:\test.csv

please have @ below output when issue above command powershell. have observed truncating last 2 columns of properties viz. manager , company. also, if separately export manager, shows complete path of user in format - cn=username,ou=..,ou..,ou..,dc=..,dc=.. need name of manager.

i have searched on net , found $formatenumerationlist needs set -1 using command $formatenumerationlist=-1 before issuing command. tried still the result same. there link in regard (https://poshoholic.com/2010/11/11/powershell-quick-tip-creating-wide-tables-with-powershell/), not address issue i'm facing. please if knows solution problem.

---

mps

hi mps,

don't use format, rather export csv:

et-aduser rtp -properties employeeid,name,givenname,sn,displayname,samaccountname,mail,department,title,mobile,manager,company |select -property employeeid,name,givenname,sn,displayname,samaccountname,mail,department,title,mobile,manager,company | export-csv user.csv

this allows read file in excel, maintaining columns. lot more useful in conceivable scenario.

cheers,
fred

note: format-commands designed display output on console window, not way handle data. useful data output can generated using either export-csv, export-clixml or convertto-html.

---

there's no place 127.0.0.1

Windows Server  >  Windows PowerShell