topic Re: Where do I find log information about user role assignments in Qlik Sense? in Management & Governance

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

dchristophersen — Tue, 23 Jan 2024 10:52:51 GMT

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

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

rva — Tue, 23 Jan 2024 14:52:00 GMT

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";

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

dchristophersen — Fri, 26 Jan 2024 07:38:30 GMT

Hi Roland,

thanks a lot!
This works like a charm.

Best regards,
Daniel