Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Active Directory LDAP


I have seen the discussions about query Active Directory from Qlikview.

I have used the application MasterActiveDirectory and it works great. Thank You for that!

I can query the AD and get Users but I have trouble finding out which User Account that are Enabled apart from the Disabled.

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.

I have Googled this and found one solution that was used in a T-SQL Query.

userAccountControl & 2 = 0

This is supposed to filter Enabled Account only.

I have tried to use this in MasterActiveDirectory but it doesn't work. Has anyone found a solution to filter out Enabled Accounts only?

Best Regards

/Bertil Palmqvist

Stockholm, Sweden