Active Directory

[brindlogcool]

I am trying to pull the Active directory details in to QlikView. How to identify the fields in the Active directory group.

[sudeepkm]

you mean you want to find the users within each AD groups.

I think under QMC > Users tab you can search for a user and it can tell you the group to which it belongs to.

[brindlogcool]

Thanks Sudeep. I trying to use the script to pull the Active directory data but not sure what are columns in the Active directory.

[MarcoWedel]

not exactly the same topic, but has some example fields:

Importing user pictures from active directory

regards

Marco

[sudeepkm]

oh ok.

Please take a look at the given below url. It shows the Active Directory database field attribute details.

User Attributes - Inside Active Directory

[MarcoWedel]

List of AD attributes:

see page: msdn.microsoft.com/en-us/library/ms675090(v=vs.85).aspx

regards

Marco

[brindlogcool]

Thanks Marco and Sudeep.

Is there any limitation in the number of records that can be queried from the Active directory?

[MarcoWedel]

yes, there is some restriction.

Windows Server 2008 and newer domain controller returns only 5000 values in a LDAP response

http://www-01.ibm.com/support/docview.wss?uid=swg21439593

http://blogs.technet.com/b/qzaidi/archive/2010/09/02/override-the-hardcoded-ldap-query-limits-introd...

[#9]

This might help

Connecting to and Querying Active Directory for Users