Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

any one. know  how this can work?

michael_maeuser
Partner Ambassador
Partner Ambassador

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

see also attached pdf...

Not applicable
Author

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
Partner Ambassador
Partner Ambassador

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
Partner Ambassador
Partner Ambassador

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

tresesco
MVP
MVP

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
Partner Ambassador
Partner Ambassador

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
Author

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
Author

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;