topic Active Directory LDAP in QlikView https://community.qlik.com/t5/QlikView/Active-Directory-LDAP/m-p/878410#M306712 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have seen the discussions about query Active Directory from Qlikview.</P><P>I have used the application MasterActiveDirectory and it works great. Thank You for that!</P><P></P><P>I can query the AD and get Users but I have trouble finding out which User Account that are Enabled apart from the Disabled.</P><P>userAccountControl is the field to go for but this is some kind of Bitmapped field. In QV it returns a number but that says nothing I've found.</P><P></P><P>I have Googled this and found one solution that was used in a T-SQL Query. </P><P></P><P>userAccountControl &amp; 2 = 0</P><P>This is supposed to filter Enabled Account only.</P><P></P><P>I have tried to use this in MasterActiveDirectory but it doesn't work. Has anyone found a solution to filter out Enabled Accounts only?</P><P></P><P>Best Regards</P><P>/Bertil Palmqvist</P><P>Stockholm, Sweden</P></BODY></HTML> Wed, 15 Jul 2015 12:03:59 GMT Anonymous 2015-07-15T12:03:59Z Active Directory LDAP https://community.qlik.com/t5/QlikView/Active-Directory-LDAP/m-p/878410#M306712 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have seen the discussions about query Active Directory from Qlikview.</P><P>I have used the application MasterActiveDirectory and it works great. Thank You for that!</P><P></P><P>I can query the AD and get Users but I have trouble finding out which User Account that are Enabled apart from the Disabled.</P><P>userAccountControl is the field to go for but this is some kind of Bitmapped field. In QV it returns a number but that says nothing I've found.</P><P></P><P>I have Googled this and found one solution that was used in a T-SQL Query. </P><P></P><P>userAccountControl &amp; 2 = 0</P><P>This is supposed to filter Enabled Account only.</P><P></P><P>I have tried to use this in MasterActiveDirectory but it doesn't work. Has anyone found a solution to filter out Enabled Accounts only?</P><P></P><P>Best Regards</P><P>/Bertil Palmqvist</P><P>Stockholm, Sweden</P></BODY></HTML> Wed, 15 Jul 2015 12:03:59 GMT https://community.qlik.com/t5/QlikView/Active-Directory-LDAP/m-p/878410#M306712 Anonymous 2015-07-15T12:03:59Z