oO.... Ya, don't use Format-Table. Format-Table will display to the screen but won't go to the file. For this you can use Select-Object. Select-Object has some other side effects that aren't important in this context.
I tested with $user = Get-QADUser -sizelimit 0 $user | select displayname, name, passwordlastset -first 10 | Export-Csv ./testFile.csv -NoTypeInformation Once that worked, I removed the -first 10 from select The -NoTypeInformation is to remove the annoying .NET type line that gets put on the first line of the CSV file. The -sizelimit 0 will get you past the default query limit of AD. $user | select displayname, name, passwordlastset | Export-Csv ./testFile.csv -NoTypeInformation Side notes... When dealing with larger data, I tend to dump the query into a variable. This way I am playing with the data locally and not waiting for the query to complete each time I test. There are three nice powershell videos you may want to check out here: http://www.blkmtn.org/TechEd-2012-Videos Steven Peck http://www.blkmtn.org On Mon, Aug 6, 2012 at 11:04 AM, Jimmy Tran <jt...@teachtci.com> wrote: > I’m trying to get a list of passwords last set from AD for my users.**** > > ** ** > > I run: **** > > add-PSSnapin quest.activeroles.admanagement**** > > Get-QADUser |ft displayname,PasswordLastSet | export-csv -path > c:\PasswordLastSet.csv**** > > ** ** > > But the data doesn’t come back as expected. If I omit the export command, > the results show fine in PS. What am I doing wrong?**** > > ** ** > > TIA,**** > > > Jimmy**** > > ** ** > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to listmana...@lyris.sunbeltsoftware.com > with the body: unsubscribe ntsysadmin > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin
