CSVDE code to export without DN attribute

[LucasYew]

Does anyone know is there a way to export AD attribute using CSVDE without exporting DN attribute? I do not wan't the DN to be exported.

[chroma]

You need to know about the LDAP attribute. The LDAP attribute is equivalent of common Active Directory names. You must try importing LDAP which serves the best CSVDE import. The secret of learning the names of LDAP attributes is to compare what you see in Active Directory Users and Computers with the the equivalent in ADSI Edit. A variation of this technique is to match a value in the Excel export with the same value on the Active Directory properties sheet.

[Macarenas]

ActiveWidgets

ActiveWidgets is a fast and compact javascript component library. It includes very powerful datagrid control, AJAX data tools for JSON, XML and CSV, and several additional controls, like tabs, combo, tree, checkbox list and others.

ActiveWidgets is one of the most popular commercial AJAX component libraries and is used in production since 2003 in government, military, banking, telecommunications, logistics, manufacturing and many other industries.

[ThoMas321]

Hall of fame LDAP attribute - DN distinguished name

As the word 'distinguished' suggests, this is THE LDAP attribute that uniquely defines an object. Each DN must have a different name and location from all other objects in Active Directory. The other side of the coin is that DN provides a way of selecting any object in Active Directory. Once you have select the object, then you can change its attributes.

Time spent in getting to know the DN attribute will repay many fold. Observe the different components CN=common name, OU = organizational unit. DC often comes with two entries, DC=CP, DC=COM. Note that DC=CP.COM would be wrong. Incidentally in this situation, DC means domain content rather than domain controller.

Another point with the syntax is to check the speech marks; when used with VBScript commands, DN is often enclosed in "speech marks". Even the speech marks have to be of the right type, "double quotes are correct", 'single quotes may be ignored' with unpredictable results. Finally, pay particular attention to commas in distinguished names.

[LucasYew]

Thanks for the reply. I know the usage of the DN but i need a .csv file without DN field to run some in house application for other usage. The file will not use to import back into AD. Does have any vbsript to remove the entire column of the .csv file? any idea?