Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
jcramirez472
New Contributor III

SECTION ACCESS WITH AD GROUPS NOT WORKING IN SENSE

Hi All,

The Problem --> Qlik Sense section access is working with USERID, NTNAME, but not ADGROUPS.

Currently we use LDAP to grab users from Active Directory.

EXAMPLE:

ADGROUP SYNTAX --> EXAMPLE1: Call.Center.MGMT

                                      EXAMPLE2: Sales.Account.Team

NTNAME-->  EXAMPLE1: JRAM

                    EXAMPLE2: SREE

USERID SYNTAX --> EXAMPLE1: JRAM

                                  EXAMPLE2: SREE

JRAM is a part of Call.Center.MGMT

SREE is a part of Sales.Account.Team

DOMAIN --> QLIKWORKS

OSUSER() --> QLIKWORKS\JRAM

HERE IS WHAT WORKS AND WHAT DOESN'T WORK:

USERID WORKS:

SECTION ACCESS;

LOAD * INLINE [

    ACCESS, USERID, AREAID, REGIONID, TERRITORYID

ADMIN, QVSENSE

USER, INTERNAL\SA_SCHEDULER

USER, DOMAIN\USERID

USER, DOMAIN\USERID, 01

USER, DOMAIN\USERID, 02, P111111

USER, DOMAIN\USERID, 08, K111111

];

SECTION APPLICATION;


NTNAME WORKS:

SECTION ACCESS;

LOAD * INLINE [

    ACCESS, NTNAME, AREAID, REGIONID, TERRITORYID

ADMIN, QVSENSE

USER, INTERNAL\SA_SCHEDULER

USER, DOMAIN\NTNAME

USER, DOMAIN\NTNAME, 01

USER, DOMAIN\NTNAME, 02, P111111

USER, DOMAIN\NTNAME, 08, K111111

];

SECTION APPLICATION;

ADGROUP DOES NOT WORK:

SECTION ACCESS;

LOAD * INLINE [

    ACCESS, NTNAME, AREAID, REGIONID, TERRITORYID

ADMIN, QVSENSE

USER, INTERNAL\SA_SCHEDULER

USER, DOMAIN\ADGROUP

USER, DOMAIN\ADGROUP, 01

USER, DOMAIN\ADGROUP, 02, P111111

USER, DOMAIN\ADGROUP, 08, K111111

];

SECTION APPLICATION;


Any Ideas?


I have tried UPPER(NTNAME), and also doing all caps on the ADGROUP field without the upper function.


THANKS!

1 Reply
arthur_dom
Contributor III

Re: SECTION ACCESS WITH AD GROUPS NOT WORKING IN SENSE

Hi! I read briefly on qlik sense help (https://help.qlik.com/sense/2.0/en-us/online/#../Subsystems/Hub/Content/Scripting/Security/sections-...) but cannot find the groupid ...

Community Browser