Export AD users and attributes with CSVDE

CSVDE -f users.csv -r ObjectClass=person -l “cn,displayname,description,lastlogon,givenname,sn”

If importing the CSV file the Excel, convert lastlogon to a date using the following formula (make sure column is formatted as type date)

=IF(C4>0,C4/(8.64*10^11) – 109205,””)

where C4 is the reference to the LastLogon value

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s