Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
swarup_malli
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.

 

 

Labels (2)
5 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

thanks for the help Rob.

Unfortunately I run into QVX_UNEXPECTED_END_OF_DATA error when I reload the app
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Did you try the "FIRST 1000" workaround?

-Rob

hermod
Contributor II
Contributor II

Hi,

What is "FIRST 1000" workaround?

 

Regards,

Hermod

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

"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