Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Solution: Getting members of a group from AD / Active Directory

I had a need to get the members of one AD group so I could use their OSUser name as part of a conditional expression on a tab.

Rob's applet returned the entire AD and took 16 minutes for a company with less than 1000 UserDNs.  It was overkill for my needs.

I created an applet that takes the AD group name (or set of AD group names) and returns the members of that (those) groups.

This takes a few seconds.

(Error checking is left as an exercise for the students.)

ADMembersOf.PNG

Thanks to hints from Rob's applet (see below link) and from some posting on various SQL forums.

(http://qlikviewcookbook.com/download/load-users-and-groups-from-active-directory/)

John