topic Re: Re: Section Access from user Active directory? in QlikView

Section Access from user Active directory?

Wed, 16 Jul 2014 10:32:00 GMT

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

Re: Section Access from user Active directory?

Wed, 16 Jul 2014 11:01:35 GMT

any one. know how this can work?

Re: Re: Section Access from user Active directory?

michael_maeuser — Wed, 16 Jul 2014 11:11:37 GMT

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

Re: Section Access from user Active directory?

Wed, 16 Jul 2014 11:13:55 GMT

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?

Re: Re: Section Access from user Active directory?

michael_maeuser — Wed, 16 Jul 2014 11:14:23 GMT

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

Re: Re: Section Access from user Active directory?

michael_maeuser — Wed, 16 Jul 2014 11:15:51 GMT

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

Re: Section Access from user Active directory?

tresB — Wed, 16 Jul 2014 11:21:08 GMT

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

];

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

michael_maeuser — Wed, 16 Jul 2014 11:26:30 GMT

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

Re: Re: Section Access from user Active directory?

Wed, 16 Jul 2014 11:33:32 GMT

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

]

Re: Section Access from user Active directory?

Wed, 16 Jul 2014 18:11:02 GMT

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;

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

michael_maeuser — Thu, 17 Jul 2014 09:10:54 GMT

Ok, please try attached version. it loads all users with there group and ntname from ad and stores it in qvds.

so in the next step you can just load from qvds with "where group=...".

hope this helps!