Nik's Technology Blog

Travels through programming, networks, and computers

Active Directory Exports using CSVDE

CSVDE - Comma Separated Value Data Exchange

If you need to export all or part of Active Directory a handy Windows utility exists called CSVDE.exe which is located in the System32 directory of Windows 2000 servers.

CSVDE exports to a .CSV file which you can then manipulate in Excel or import into SQL Server.

CSVDE is run from the command prompt and has various switches to enable you to obtain the information you require.

The simplest export, which would export the whole Active Directory would be:

CSVDE -f activedirectory.csv

This would export a file called activedirectory.csv to the directory where CSVDE was run from and would contain all the fields, and there are a lot!

To specify certain fields like the NT logon and email address for example you would use the -l switch:

CSVDE -f activedirectory.csv -l "mailNickname,mail"

CSVDE uses the current users account to log into Active Directory by default, to use another account use the -b switch and specify username, domain and password.

CSVDE -f activedirectory.csv -b username domain password

CSVDE also allows you to create an LDAP search filter, so you can choose to only export only users who match certain criteria. Use the -r switch. The following only exports your details based on a surname match:

CSVDE -f activedirectory.csv -r "(&(objectClass=user)(sn=yoursurname))"

If you have more than one domain controller you can use the -s switch to select the correct one.

Active Directory imports can also be performed using CSVDE by using the -i switch, which sets the mode to import otherwise export is the default mode.

Cisco CCNA Certification

The CCNA, Cisco Certified Network Associate, is a networking exam designed to provide an introduction to networking skills and Cisco products. It is the first of three major Cisco exams the others being CCNP (Cisco Certified Network Professional) and CCIE (Cisco Certified Internetwork Expert).

The exam covers a great deal of topics, and will introduce you to Local Area Networks (LAN), Wide Area Networks (WAN), switching and routing. You will learn how to configure and troubleshoot Cisco routers, as well as basic configuration of Cisco switches, and of course, you will learn how to set up your own LAN and WANs.

My Cisco CCNA revision notes

Cisco CCNA Test Questions

The CCNA 640-607 exam lasts for 90 minutes and contains between 55-65 questions, which vary in difficulty. No two people sitting the exam will get the same questions as they are chosen from a pool of CCNA test questions, which are only used for a short period of time.

The exam has a several different types of questions, the site below is an excellent resource for testing your knowledge. CCNA test questions include multiple choice, multiple choice with multiple answer, drag and drop and fill in the blanks questions. Along with these you will get various router simulations, in which you will need to configure a network of routers or determine a fault in a network of routers and fix the problem. These are aimed at testing your knowledge of networking and Cisco IOS, however I advise you to read the test questions thoroughly and make sure you understand what is being asked of you, otherwise you WILL get caught out. For example, some test questions you will have to 'choose all that apply', if you miss read this and only check one box, you will not get any marks for that question.

Before the CCNA exam starts you will have to read and accept the terms of the Cisco Career Certifications and Confidentiality Agreement. Otherwise you will not be able to continue.

The exams are set in a controlled environment where you are not allowed notes or calculators and you must not talk to anyone else. You will be provided with blank paper for making notes, which will be collected at the end of the exam.

The time will fly past, and before you know it you will be running out of time unless you practise taking tests with test software, before you consider buying test software I advise you to look for free resources on the web, follow the link at the bottom of the page, and don't spend too long on each answer. Each type of question is allocated a different amount of marks. The router simulation questions are worth the most, so spend more time on those.

Currently the CCNA is under going a change and will be broken up into two separate exams.

I recommend the Sybex book below for your revision. It's explanations and examples helped me pass my CCNA with a score of 912. It also comes with CD test software which will help you practise answering questions to a set time, as well as getting you used to the terminology of the questions.

This material is not sponsored, endorsed or affiliated with Cisco Systems, Inc. Cisco, Cisco Systems, CCIP, the CCIP Logo, the CCNA Logo, the CCNP Logo, the CCDA Logo and the CCDP Logo are trademarks of Cisco Systems, Inc. and its affiliates. CCNA®, CCNP®, CCDA® and CCDP® are registered trademarks of Cisco Systems, Inc. and its affiliates.

Free Networking Quiz to help you prepare for the CCNA test questions