Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
swarup_malli
Valued Contributor

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

swarup_malli
Valued Contributor

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
MVP & Luminary
MVP & Luminary

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

Did you try the "FIRST 1000" workaround?

-Rob

hermod_svingeru
New Contributor II

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

Hi,

What is "FIRST 1000" workaround?

 

Regards,

Hermod

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