Qlik User List

[pjpkumar26]

Hi Friends,

can anyone please suggest how can I get the list of user who have accessed the Stream and Apps last 1 year 

below is the data I am try to get out of Qlik QMC.

I got full admin access and need to know id there any default reports we have with the product are do we need to create?

your help is very much appreciated.

Thanks,

Kumar

[JandreKillianRIC]

Hi @pjpkumar26 

You can build your own application using the Engine Session logs. The location for these files are 

"C:\ProgramData\Qlik\Sense\Log\Engine\Trace" - Just have a look at the session logs. Should look something like this xxxxxx_Session_Engine.txt

You might need to include some archived logs if you want to go back that far. You can have a look in QMC for this 

This log contains the following fields 

LOAD
    Sequence#,
    "Timestamp",
    Level,
    Hostname,
    Logger,
    Thread,
    Id,
    ServiceUser,
    Message,
    ProxySessionId,
    ActiveUserDirectory,
    ActiveUserId,
    EngineTimestamp,
    EngineThread,
    ProcessId,
    SessionId,
    "Exe Version",
    "Server Started",
    ProxyPackageId,
    AppId,
    "App Title",
    "Doc Timestamp",
    "Exit Reason",
    "Session Start",
    "Session Duration",
    "CPU Spent (s)",
    "Bytes Received",
    "Bytes Sent",
    Calls,
    Selections,
    "Authenticated User",
    "Secure Protocol",
    Id2
FROM [lib://Engine Logs (qsadmin)/Trace/xxxxxx_Session_Engine.txt]
(txt, utf8, embedded labels, delimiter is '\t', msq);

I normally use this to archive old applications / and or just remove the reloads as the apps I identify are not in use anymore. 

Alternatively you can use the Monitoring Apps > Operations Monitor

This also has the session logs included. Just make sure that this app is reloading on your side. 

Regards Jandre

[Øystein_Kolsrud]

I think you should be able to get information like this from the "Operations Monitor" app. But you might need to create some custom sheet to present the information in a way that is useful to you. And I'm not sure it loads data as far back as 1 year by default.

[pjpkumar26]

Thanks Jandre and Kolsrud.

I can now able to see the stats in Operations Monitor in production and get the requires information.

Regards,

Kumar