Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
dchristophersen
Contributor II
Contributor II

Where do I find log information about user role assignments in Qlik Sense?

Dear Qlik community,

 

I am trying to find very specific information in the Qlik Sense log files.

Namely, the information which roles a user has assigned when they log in to the QMC.

I am 100% confident that I once found this information in one of the Qlik Sense log files, but I currently cannot find this information again unfortunately.

As far as I can remember, the information looked something like "user X logged in with context /qmc and has following roles assigned: role 1, role 2, etc."

 

Do you have any idea where I can find this information?

Could it be an issue with log levels maybe?

 

We are using Qlik Sense Enterprise May 2023 Patch 6.

Our log level is currently set to following:

dchristophersen_0-1706007062198.png

 

Best regards,
Daniel

Labels (3)
1 Solution

Accepted Solutions
rva
Partner - Contributor III
Partner - Contributor III

 HI Daniel!

 

I didn't find it in a single logfile. But you coud join the information from the QSR database. The field "RolesString" would hold the information like "Rootadmin" etc.. 

 

LOAD
    Sequence#,
    "ProductVersion",
    "Timestamp",
    Hostname,
    Id,
    Description,
    ProxySessionId,
    ProxyPackageId,
    RequestSequenceId,
    UserDirectory,
    "UserId",
    ObjectId,
    ObjectName,
    Service,
    Origin,
    Context,
    Command,
    Result,
    Message,
    Id2
FROM [lib://Logs_Repository_Audit/SERVERNAME_AuditActivity_Repository.txt]
(txt, utf8, embedded labels, delimiter is '\t', msq, no eof) 
 
where Origin = 'ManagementAccess';
 
LIB CONNECT TO 'PostgreSQL_localhost_QSRDatabase';
 
LOAD UserId,  //join key
UserDirectory,  //join key
RolesString, 
ModifiedDate, 
ModifiedByUserName;
 
[Users]:
SELECT "UserId", 
"UserDirectory",
"RolesString",
"ModifiedDate",
"ModifiedByUserName"
FROM "public"."Users";
 

 

View solution in original post

2 Replies
rva
Partner - Contributor III
Partner - Contributor III

 HI Daniel!

 

I didn't find it in a single logfile. But you coud join the information from the QSR database. The field "RolesString" would hold the information like "Rootadmin" etc.. 

 

LOAD
    Sequence#,
    "ProductVersion",
    "Timestamp",
    Hostname,
    Id,
    Description,
    ProxySessionId,
    ProxyPackageId,
    RequestSequenceId,
    UserDirectory,
    "UserId",
    ObjectId,
    ObjectName,
    Service,
    Origin,
    Context,
    Command,
    Result,
    Message,
    Id2
FROM [lib://Logs_Repository_Audit/SERVERNAME_AuditActivity_Repository.txt]
(txt, utf8, embedded labels, delimiter is '\t', msq, no eof) 
 
where Origin = 'ManagementAccess';
 
LIB CONNECT TO 'PostgreSQL_localhost_QSRDatabase';
 
LOAD UserId,  //join key
UserDirectory,  //join key
RolesString, 
ModifiedDate, 
ModifiedByUserName;
 
[Users]:
SELECT "UserId", 
"UserDirectory",
"RolesString",
"ModifiedDate",
"ModifiedByUserName"
FROM "public"."Users";
 

 

dchristophersen
Contributor II
Contributor II
Author

Hi Roland,

thanks a lot!
This works like a charm.

Best regards,
Daniel