?
Solved

Getting First and Last Name from username

Posted on 2004-04-24
2
Medium Priority
?
237 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 1500 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

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…
An introduction to the wonderful sport of Scam Baiting.  Learn how to help fight scammers by beating them at their own game. This great pass time helps the world, while providing an endless source of entertainment. Enjoy!
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses
Course of the Month11 days, 16 hours left to enroll

752 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