Section Access Automation

[imrasyed]

Hi Experts,

I have  an excel source for Section Access placed at a location.Now When a user gets Access to a AD group,that particular user needs to be manually added to the Excel source.Can we basically Automate this Process like A User gets access to AD group and that user shd be getting added to Excel?

Really appreciate your help.

Thanks

Syed Imran 

[dplr-rn]

Should be possible but thats a non qlikview issue.
What i have implemented is to use a DB table instead of excel (exactly same format) and use a simple custom web app to add new user into the table. Basically this webapp will be operated by admin team and becomes part of the process

[Miguel_Angel_Baeyens]

Adding to what was posted above, you can connect directly to the AD and read users and groups from Qlik script.

AD:
LOAD DISTINCT *;
SQL SELECT
sAMAccountName, name, distinguishedName, userPrincipalName
FROM 'LDAP://DC=subdomain, DC=domain, DC=net' WHERE objectCategory='person';

You have a more refined example in Rob's recipe: http://qlikviewcookbook.com/list-recipes/

[Vegar]

It is possible to assign section access based on AD group. You need to use the section access field name GROUP.

I've pasted in an SA examlple using GROUP below.

section access;
LOAD * inline [
ACCESS, USERID, GROUP, REDUCTION, OMIT
USER, *, ADMIN, *,
USER, *, A, 1,
USER, *, B, 2, NUM
USER, *, C, 3, ALPHA
USER, *, GROUP1, 3,
ADMIN, INTERNAL\SA_SCHEDULER, *, *,
];
section application;

T1:
LOAD
*,
NUM AS REDUCTION;
LOAD
Chr( RecNo()+ord('A')-1) AS ALPHA,
RecNo() AS NUM
AUTOGENERATE 3;

[imrasyed]

Hi MVP,

Thanks for the help

but  if I want a particular user to get restricted for some territories(not all) under that group Will I be able to achieve it?

Thanks

Syed Imran

[imrasyed]

Hi I am not able to see the example in the link you provided.Can you send me the correct link or do i need anything else to view the content.