Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Extract users names from the AD group used in QMC

Hi,

 

Has anyone extracted the user names fromt he AD groups used in qmc ?

 

Instead of using ldap browser to check the user in a AD group ,I wanted to extract the data into a qlik sense app.

 

No sure which  connector to use to connect to the AD group.

 

 

5 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Extract users names from the AD group used in QMC

You can download a Qlik Sense script sample here:

Qlik Cookbook: Load Users and Groups from Active Directory http://qlikviewcookbook.com/recipes/download-info/load-users-and-groups-from-active-directory/

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Highlighted
Specialist
Specialist

Re: Extract users names from the AD group used in QMC

thanks for the help Rob.

Unfortunately I run into QVX_UNEXPECTED_END_OF_DATA error when I reload the app
Highlighted
MVP & Luminary
MVP & Luminary

Re: Extract users names from the AD group used in QMC

Did you try the "FIRST 1000" workaround?

-Rob

Highlighted
Contributor II
Contributor II

Re: Extract users names from the AD group used in QMC

Hi,

What is "FIRST 1000" workaround?

 

Regards,

Hermod

Highlighted
MVP & Luminary
MVP & Luminary

Re: Extract users names from the AD group used in QMC

"First 1000" means to put the prefix "First 1000" on the Load statement that is throwing an error.  First 1000 will limit the Load to returning 1000 rows at a time.  As the script is coded to loop, you will get all the rows eventually.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com