Solved

Getting First and Last Name from username

Posted on 2004-04-24
2
215 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
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

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…
There's a lot of hype surrounding blockchain technology. Here's how it works and some of the novel ways it' s now being used - including for data protection.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

856 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