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

[dchristophersen]

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:

Best regards,
Daniel

[rva · Accepted solution]

 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]

Hi Roland,

thanks a lot!
This works like a charm.

Best regards,
Daniel