topic Re: AD and QlikView Management for Section Access in QlikView

AD and QlikView Management for Section Access

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am looking for a solution to create a list of users and schools to be used in a dashboard's Section Access.

1 - List of ALL users and locations comes from HR DB

2 - AD has groups with users

3 - QlikViewManagement Console has a list of groups with access to the dashboard.

My question is how to access list #3 to narrow down list of users to build users QVD to be used by the dashboard.

Thanks,

Re: AD and QlikView Management for Section Access

Anonymous — Sat, 04 Jun 2016 06:24:55 GMT

Hi Larisa,

Use this code to read from QMC.

Sub readFiles (root)

//Will check for reach root file named like "Sessions"

For each File in filelist ('$(root)\Sessions*.log')

vsFileCheck = index(File,'~$');

//If File Exists

if vsFileCheck=0 then

//Generate a temporary table with log information

Acessos:

LOAD [Exe Type],

[Exe Version],

[Server Started],

Timestamp,

Document,

[Document Timestamp],

[QlikView User],

[Exit Reason],

[Session Start],

[Session Duration],

[CPU spent (s)],

[Bytes Received],

[Bytes Sent],

Calls,

Selections,

[Authenticated user],

[Identifying user],

[Client machine identification],

[Serial number],

[Client Type],

[Client Build Version],

[Secure Protocol],

[Tunnel Protocol],

[Server Port],

[Client Address],

[Client Port],

[Cal Type],

[Cal Usage Count]

FROM

[$(File)] (txt, utf8, embedded labels, delimiter is '\t', msq);

endif//Until there are no more log files

Next File;

EXIT Script

//If files do not exists, a blank structure will be created

Acessos:

LOAD * INLINE

[

Exe Type,Exe Version,Server Started,Timestamp,Document,Document Timestamp,QlikView User,Exit Reason,Session Start,Session Duration,CPU spent (s),Bytes Received,Bytes Sent,Calls,Selections,Authenticated user,Identifying user,Client machine identification,Serial number,Client Type,Client Build Version,Secure Protocol,Tunnel Protocol,Server Port,Client Address,Client Port,Cal Type,Cal Usage Count

];

//finally the temporary table will turned in qvd file

store Acessos into DADOS\Acessos.qvd;

//temp table is dropped

drop table Acessos;

End sub;

call readFiles('C:\ProgramData\QlikTech\QlikViewServer') ;

Re: AD and QlikView Management for Section Access

Mon, 06 Jun 2016 13:41:31 GMT

Thank you Khan, let me try, will let you know

Re: AD and QlikView Management for Section Access

Peter_Cammaert — Mon, 06 Jun 2016 14:16:25 GMT

In QMC, where do you define these lists of groups with access to specific documents?

Peter

Re: AD and QlikView Management for Section Access

Tue, 07 Jun 2016 12:11:51 GMT

Documents - Edit Task - Distribute

Re: AD and QlikView Management for Section Access

Peter_Cammaert — Tue, 07 Jun 2016 13:20:22 GMT

Then check out the following task detail configuraiton file in QVPR (Publisher database):

C:\ProgramData\QlikTech\ManagementService\QVPR\DistributionDetails.xml

At the bottom of that file, you'll find the distribution targets for all published documents.

You may need to process other files in the same folder as well, because all objects are referenced using large cryptic identifiers. Check out rwunderlich QVPR Analysis tool at Tools | Qlikview Cookbook. It will be very helpful.

Best,

Peter

Re: AD and QlikView Management for Section Access

Tue, 07 Jun 2016 13:32:44 GMT

thanks Peter!