List of AD groups granting access to users for streams

[Raju_6952]

Hi,

I am exploring a ways to build custom report in Qlik sense enterprise on windows which needs to have details like as  follows.

Any suggestions would be highly appreciated on this requirement.

Regards,

Raju

[henrikalmen]

If you grab the AD groups in the virtual proxy that users log in with, it's quite simple:

section access;
access:
load distinct * inline [
ACCESS, USERID, GROUP
ADMIN, AD\QLIKSVC, *
ADMIN, AD\MYNAME, *
ADMIN, INTERNAL\SA_SCHEDULER, *
USER, *, 'cn=it-gruppchefer,dc=prefix,dc=mydomain,dc=com'
USER, *, 'cn=groupname1,dc=prefix,dc=mydomain,dc=com'
USER, *, 'cn=groupname2,dc=prefix,dc=mydomain,dc=com'
];
section application;

This, of course, depends on what the group data from your AD looks like.

Se this page in the manual: https://help.qlik.com/en-US/qlikview/Subsystems/QMC/Content/QV_QMC/QMC_Users_SectionAccessManagement... and you could also look at this post: https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-Section-Access-with-Groups-i...