Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
L
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') ;
Thank you Khan, let me try, will let you know
L
In QMC, where do you define these lists of groups with access to specific documents?
Peter
Documents - Edit Task - Distribute
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
thanks Peter!