List of Users in KNIME Server

[narayanan]

Hi All,

Can anyone help to update how to get the list of users logged/connected in KNIME Server via web & KNIME AP.

I see one option on the Web portal under license tab which shows the connected.

Is there any option or script we can able to fetch the list of users in the KNIME server based on the access logs?

Regards
Narayanan.

[nagarjun36]

Hi @narayanan,

Welcome to KNIME Forum !!

As you suggested we can get the list of users connected to KNIME Server from KNIME AP from the License tab on KNIME Webportal.

Usually the KNIME Server admin will be providing the user access to the KNIME Webportal by adding the users and consumers accounts/groups to the KNIME Server configuration. If you are the admin then you can check which groups/accounts are added and then fetch the list of users/consumers.

Access logs might provide details about logged in users and might not be accurate in providing the list of all users.

In order to understand better can we know why do we need to fetch the list of all users? Looking forward to your response.

Regards,
Nagarjun S

[narayanan]

Thank you Nagarjun for the reply.
Specifically we are looking for the list of users getting logged in/out or connected to the KNIME server daily or weekly to track the usage via Web or KNIME AP. if this possible to configure and send the user details via email based on the server access logs? Kindly advise.

Regards
Narayanan.

[nagarjun36]

Hi @narayanan,

As of now there is no direct way of analysing the list of users via KNIME Server, However all of the user details who access the KNIME Server are written to the locahost_access logs. You can try the below workflow(log analysis) available on KNIME HUB, log-analysis_v0.2 – KNIME Community Hub

With this workflow you can upload the downloaded logs from KNIME Server and access the localhost_access logs and filter out the necessary data.

Let me know if this helps, looking forward to your response.

Regards,
Nagarjun S

[narayanan]

Thanks Nagarjun for the reply. Nice workflow.

I have tried to execute the workflow using the local log files (.zip) but couldn’t get the Configure option enabled from the “Select Source” option. Please advise how configure for uploading the log files in the node.

[marvin.kickuth]

Hi @narayanan,

the workflow was started with the idea of being run in the WebPortal. Hence, the node is configured in the view (Execute and Open Views) or when run in the WebPortal.

You can of course also go into the component and change it to use configurations rather than widgets.

Kind regards
Marvin

[narayanan]

Hi Marvin/Nagarjun,

Thanks for your help and guidance.

I am trying to upload the download knime-server logs.zip file to the source but after this screen (attached), didnt get any option to browse the file.

In the next component “upload local logs.zip”, tried execute and open views, able to select the log files (.zip) applied and executed the workflow but didnt get the output, showing below error in the log explorer

Kindly advise if i am missing anything to configure under the components?

Regards
Narayanan

[narayanan]

Sorry… Found out the cause. Now the workflow works fine and able to view the interactive report without any issues.

In the report, few of the graphs shows No data available & /dummy/workflow (screenshot attached). Is this due to the data missing on the logs?

Please suggest.

Regards
Narayanan.

[marvin.kickuth]

Hi @narayanan,

the workflow tries to process the job logs, which aren’t enabled by default. If you want to enable them on the server, see Job Tracing in our documentation:
https://docs.knime.com/latest/server_admin_guide/index.html#log-files

This Workflow is not meant as a business-ready solution, but was something I played around with for myself. Please consider it a starting point for your own workflow building, rather than a finished solution (hence the low version number).

Kind regards
Marvin

[narayanan]

Hi Marvin,

its Good try and useful. Thanks for your efforts

Can you please help to guide if this can be modified to get the report on month wise by changing the process logs metanode component.

job count per user per month
Monthly unique users

Regards
Narayanan

[narayanan]

Thank you Marvin & Nagarjun for the suggestion and Inputs on this query. Much appreciated your support.