Hi,
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
