Use QlikView to read an active directory

Its really easy to use QlikView to read out a Active Directory. Here is how:

Simple use a OLE DB connection and the "OLE DB provider for Microsoft Directory Services" which should be default installed in must windows computers if not google for the driver.

In the connection tab, set the Data source to: LDAP://your.adserver.com < where the last part is any AD node in the network.

And use any username that has the rights to read the AD

In the edit script place the lines below:

users:
 load  
 distinguishedName as KEY_User,
 cn as Userid,
 displayName,
 givenName,
 sn, 
 mail,
 userAccountControl;
 sql select distinguishedName,cn,displayName,
givenName,sn, mail,userAccountControl from 'LDAP:// 
your.adserver.com';
 
 groups:
 load  
 distinguishedName as GroupKey,
     cn as "Group Name",
     subfield(member,'|') as KEY_User;
 sql select distinguishedName,cn,member from 'LDAP://
your.adserver.com';

No more needs for the silly logparser application :)