Forum Home
Press F1
 
Thread ID: 103743 2009-10-05 01:34:00 Exporting data from Active Directory chiefnz (545) Press F1
Post ID Timestamp Content User
816965 2009-10-05 01:34:00 Hi all,

I'm trying to extract specific information from Active Directory from our primary domain controller.

I have downloaded numerous tools but thusfar none of them are giving me exactly what I want which is...

First Name
Last Name
Email Address
Description (Which is the users job title)

Ideally, it would handy if it was exported as a csv file in the following format

First Name, Last Name, Description, Email Address

Any help would be greatly appreciated.

Cheers, 		chiefnz (545)
816966 2009-10-05 01:54:00 If you can't find a tool that does the whole task in one go, have you considered just dumping the relevant fields as LDIF and then piping it through sed?

You can also get LDAP clients that will allow you to export to CSV directly.

Note that any LDAP client should talk to your domain controller quite happily - you don't need to find one that's specifically intended for use with AD. 		Erayd (23)
816967 2009-10-05 02:40:00 Hi all,

I'm trying to extract specific information from Active Directory from our primary domain controller.

I have downloaded numerous tools but thusfar none of them are giving me exactly what I want which is...

First Name
Last Name
Email Address
Description (Which is the users job title)

Ideally, it would handy if it was exported as a csv file in the following format

First Name, Last Name, Description, Email Address

Any help would be greatly appreciated.

Cheers,


You shouldn't need any 3rd party tools (www.cmsconnect.com) 		nofam (9009)
816968 2009-10-06 00:01:00 Found an application call ADManage Engine Plus.

made by a compnay called ZOHO.

Great piece of software, gives me exactly what I want.

Cheers for the advice. 		chiefnz (545)
816969 2009-10-06 00:39:00 Found an application call ADManage Engine Plus.

made by a compnay called ZOHO.

Great piece of software, gives me exactly what I want.

Cheers for the advice.

Glad to hear you got it working chief; still curious as to why you needed a 3rd part app to do this though? I was able to export the fields you need to .csv natively from AD? 		nofam (9009)
816970 2009-10-06 05:22:00 I suspect it may have something to do with the fact that user accounts are held within individual business unit OU's.

I would have to run seperate commands for each OU, which would have taken a while, so that's why I opted for a 3rd party applications.

Which commands did you use?

Cheers, 		chiefnz (545)
1