topic Extract users names from the AD group used in QMC in App Development

Extract users names from the AD group used in QMC

swarup_malli — Sat, 16 Nov 2024 06:24:25 GMT

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.

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

rwunderlich — Fri, 08 Mar 2019 04:24:06 GMT

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

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

swarup_malli — Fri, 05 Apr 2019 19:02:35 GMT

thanks for the help Rob.

Unfortunately I run into QVX_UNEXPECTED_END_OF_DATA error when I reload the app

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

rwunderlich — Sun, 14 Apr 2019 05:27:17 GMT

Did you try the "FIRST 1000" workaround?

-Rob

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

hermod — Mon, 09 Sep 2019 12:18:40 GMT

Hi,

What is "FIRST 1000" workaround?

Regards,

Hermod

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

rwunderlich — Mon, 09 Sep 2019 18:12:38 GMT

"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