• Skip to primary navigation
  • Skip to content
  • Skip to footer
Dovestones Software

Dovestones Software

Active Directory Software and Services

  • Products
    • AD Toolset Bundle
    • AD Bulk Users
    • AD Bulk Contacts
    • AD Reporting
    • AD Bulk Export
    • AD Photos
    • AD Find and Replace
    • True Last Logon
    • AD Self Password Reset
    • AD Phonebook
    • AD Self Update
  • Solutions
    • Import users into Active Directory
    • Import Active Directory photos into SharePoint
    • Update users that already exist in Active Directory
    • Report on Active Directory Users
    • Allow users to reset their own passwords.
    • Allow employees to update their own details Active Directory.
  • Testimonials
  • Downloads
  • Buy Online
    • Pricing
    • Resellers
  • Support
    • Frequently Asked Questions (FAQs)
    • Documentation
    • Support Request Form
    • Uninstall Products
    • End User License Agreement
    • Blog
  • About Us
    • Enquiry Form

Users show as firstname lastname in AD Users and Computers, how can I change it to lastname firstname?

May 21, 2017 Knowledge Base

To import users using first name and last name or vice versa you can add a column to your CSV/Excel file called cn and set the value to %firstname% %lastname%. Below is an example.

firstnamelastname

Other wildcards you can use in your import file are:

%username% (reads the value found in the sAMAccountName column)
%firstname% (reads the value found in the givenName column)
%lastname% (reads the value found in the sn column)
%givenName% (reads the value found in the givenName column)
%sn% (reads the value found in the sn column)
%sAMAccountName% (reads the value found in the sAMAccountName column)
%userPrincipalName% (reads the value found in the userPrincipalName column)
%initials% (reads the value found in the initials column)
%email% (reads the value found in the mail column)
%firstNamefirst% (reads the first letter of the value found in the givenName column)
%firstNamelast% (reads the last letter of the value found in the givenName column)
%lastNamefirst% (reads the first letter of the value found in the sn column)
%lastNamelast% (reads the last letter of the value found in the sn column)

 AD Bulk Users

Related Knowledge Base Posts –

  • How do I add users to multiple groups?
  • How do I update the sAMAcountName?
  • Can I bulk update passwords using AD Bulk Users?

Footer

Dovestones Software Ltd

Copyright 2005 - 2017 Dovestones Software Ltd
All rights reserved.
Registered in England No. 5588703
Privacy

Registered office:

Dovestones Software LTD
Warblers, Brook Road, Tarporley,
CW6 9HH, United Kingdom

Our Newsletter

Subscribe to our newsletter to receive the latest updates. We respect your privacy.