Question export info from Active Directory windows server 2003. (1 Viewer)

[xaysana]

Hi there,
Thank you for saying Happy Birth Day to me.

By the way, my FO line manager wants an IT report, i am wandering if there is any posibility to search and export users. The report should show in the status column who are disabled, who are enabled, date created and date expired in date column in active directory windows server 2003 evironment please?

Thank you in advance for your advice.

Best regards,

 

[Galaxiom]

It is pretty heady stuff to get into your own database. LDAP uses a two level structure where some field values are arrays. This will get you started.

Here is an explanation of LDAP attributes of computers and users in Active Directory.
http://www.computerperformance.co.uk/Logon/LDAP_attributes_active_directory.htm#LDAP_Attribute_

Connect to the LDAP server using an ADO connection.

Set ADConn = CreateObject("ADODB.Connection")
ADConn.Provider = "ADsDSOObject"
ADConn.Open "Active Directory Provider"

The general syntax for a query against this connection:

SELECT somefield FROM 'LDAP://ServerName' WHERE objectCategory= 'someCategory' AND someattribute='somevalue'