Section Access from user Active directory?

[#1]

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

[#2]

any one. know  how this can work?

[michael_maeuser]

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

see also attached pdf...

[#4]

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]

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]

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]

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]

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

[#9]

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*'

]

[#10]

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;