Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Section Access from user Active directory?

Dear all,

i'm trying to find a way to manage section access by fetching users name from Active directory.

known that i don't have enterprise server licence .

in the attached file i can do it using script

to open the file ID: admin     

          password    admin

Thanks

10 Replies
Not applicable

Re: Section Access from user Active directory?

any one. know  how this can work?

michael_maeuser
Contributor III

Re: Re: Section Access from user Active directory?

in your section access table you just need the fields ACCESS, NTNAME, RESTRICTIONFIELD1...

see also attached pdf...

Not applicable

Re: Section Access from user Active directory?

thanks for the PDF file,

but the issue that i have to add them in the Qvd file one by one.

if there is way i can add group from active directory?

michael_maeuser
Contributor III

Re: Re: Section Access from user Active directory?

or do you want to read your users from Active Directory instead of write them manually in an inline load?

this is possible with an application from Rob Wunderlich Search Recipes | Qlikview Cookbook

michael_maeuser
Contributor III

Re: Re: Section Access from user Active directory?

ah ok, then like i wrote above, Rob´s file is what you need, just add an where clause in the script to only load the group you need

MVP
MVP

Re: Section Access from user Active directory?

It should work as in username, like:

SECTION Access;

LOAD * INLINE [

    ACCESS, NTNAME,  REGION

    USER, DOMAIN\AD_GROUP_1, NORTH

    USER, DOMAIN\AD_GROUP_2, SOUTH

    USER, DOMAIN\AD_GROUP_3, WEST

];


michael_maeuser
Contributor III

Re: Re: Re: Section Access from user Active directory?

here´s a file that might help you. as far as i know you definately need to list all users in section access, not just a group. but with this file you can create the list automatically from AD. in script tab "QV Groups" you can load a file with the groups or replace it by an inline load. it is Robs file, a little bit modified

Not applicable

Re: Re: Section Access from user Active directory?

Hello Michael

thanks for "ActiveDirectory.qvw"  but i'm not able to tune the file so it works with my network.

on Users Tab --> on SQL Select im getting error

[

ErrorSource: Active Directory, ErrorMsg: A referral was returned from the server.

SQL select
 
  name, distinguishedName, sAMAccountname 
FROM 'LDAP://DC=test, DC=test'  WHERE objectCategory='person'
  AND name = 'A*'

]

Not applicable

Re: Section Access from user Active directory?

Try express   , Use in hidden script

Section Access;
Star is *;
LOAD * INLINE [

    ACCESS, NTNAME, Team
   ADMIN, DOMAIN\NAME_USER, NORTH,
  USER,  DOMAIN\NAME_USER, NORTH,
   
]
;

Section Application;

Community Browser