Solved

Getting First and Last Name from username

Posted on 2004-04-24
2
226 Views
Last Modified: 2010-04-13
I have an excel/comma delimited file that contains a list of usernames. Is there a way to use that list and get the First and Last Name of the users so that they can be imported into excel? This is on Windows 2000 Active Directory by the way.
0
Comment
Question by:gbarrientos
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Expert Comment

by:stafi
ID: 10909275
open excel - file>open - change the "files of type" to text files and open the csv file
now you have to configure the "text import wizard" and when you finish you mast save the result again as an excel file.

0
 
LVL 11

Accepted Solution

by:
Quetzal earned 500 total points
ID: 10909635
Open Active Directory for Users and Computers.  Click on the Container that has the users defined.  Click on View->Choose Columns and select User Logon Name, First Name, and Last Name.  Right-click the container and choose Export List.  Choose tab delimited format.   You can use the Excel text import wizard to import this file, just be sure to choose tab as the delimiter.
0

Featured Post

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
Unified and professional email signatures help maintain a consistent company brand image to the outside world. This article shows how to create an email signature in Exchange Server 2010 using a transport rule and how to overcome native limitations …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question