Extract from AD

You can Use a software such as LDAPsoft


http://www.ldapsoft.com/tutorials.html

Link to download:
http://www.ldapsoft.com/download.html

If you are not comfortable with the command line there is a free tool called adinfo that you may like

http://www.cjwdev.co.uk/Software/ADReportingTool/Info.html

Having said that you should start to get familiar with the command line and poweshell is a good start so at least try what Ken gave you above.

Thanks


Mike

Ken,
I typed in the command you wrote exactly and it errored.
Z:\>get-qaduser -sizelimit 0 | Select Name, Title, department | export-csv c:\temp\users.csv -notype

"The term 'get-qaduser' is not recognized as the name of a cmdlet....
I also tried "get-aduser"

great tool, I wonder why MS just cant make it like that?
now the next question will be how do I edit all those users at once? Need to update the pulled info.

You can use third party software True Last Logon 2.9.You can export the file in excel for report creation.You can use the trial version this will achieve what you are looking for.

True Last Logon displays the following Active Directory information:
--Users real name and logon name
--Detailed account status
--Last Logon Date & Time
--Last Logon Timestamp (Replicated value)
--Account Expiry Date & Time
--Enabled or Disabled Account
--Locked Accounts
--Password Expires
--Password Last Set Date & Time
--Logon Count
--Bad Password Count
--Expiry Date
--You can also query for any other attribute (Example: Description, telephone Number, custom attibutes etc)

Refer the below link for trial version:
http://www.dovestones.com/products/True_Last_Logon.asp