To get the statistics report of active and logged users in HCL Connections 6.5 | New production environment | RHEL 7.8

HCL Connections Connections Forum
, ,
1

Hello, This is the new production Connections environment, We want to know the user statistics reports for users, how can I get the active and logged users in the HCL Connections 6.5 CR1?

I would appreciate your answers. Thank you in advance.

2

Hi, depending on your deployment you have several options.

Older deployments often have Cognos deployed and show statistics on /metrics, this was replaced with Kubernetes and Elasticsearch in newer versions. So you need to install component pack to get the usage statistics.

If you just need bare stats like logged in users, each application has a hidden statistics page. I need to search in my backyard (brain) I think I have these links somewhere.

And last option, you can grab data from the db2/sql/oracle databases and build it on your own. Then there are 3rd party apps for deeper analysis.

3

Hi @Christoph Stoettner Thanks for your response. I don't have the Cognos/Metrics/Elasticsearch,etc report in my environment.

I am using the DB2 database for Connections. Is there any command to run on db2 which can help to get the report? or is there any console available in Connections to get the statistics?

Thanks.

4

Hi again

the databases are a black hole and I wouldn't recommend that.

There is a way to grab basic stats with wsadmin:

https://help.hcl-software.com/connections/v65/admin/admin/r_admin_act_monitor_stats.html

I think there should be the command for each application (or most of them).

To be honest, the same data can be retrieved through the browser, but I can't remember the links ;)

5

Hi Elango,

One easy way to get active users in connections through database query. You just run the below query and export the data into excel.

select * from EMPINST.EMPLOYEE where PROF_STATE=0

Thanks,

Venkat

6

That query only shows who could possibly login, so nice from a licensing perspective.

Add prof_lastlogin to it and sort it, so you get the users sorted by lastlogin, but this query is problematic in Europe, because you can monitor your users on a name base.

I would do a (not sure about prof_last_login, I have no database here in the moment.

select count(prof_state) from empinst.employee where prof_state=0 AND prof_last_login >= '20200701 00:00:00.000' AND PROF_LAST_LOGIN < '20200730 00:00:00.000'


To get the active users logged-in in July.

7

I got the query to verify users who logged from particular day. You can tune this query based on your requirement for last five days or last two hours, etc...

select * from EMPINST.PROFILE_LAST_LOGIn where PROF_LAST_LOGIN >= '2020-06-27 00:00:00'

Thanks,

Venkat

8

Hi Christ, Thanks for your response. I got the below output.

[db2inst1@ ~]$ db2 "select count(prof_state) from empinst.employee where prof_state=0 AND prof_last_login >= '20200701 00:00:00.000' AND PROF_LAST_LOGIN < '20200730 00:00:00.000'"
SQL0206N "PROF_LAST_LOGIN" is not valid in the context where it is used.
SQLSTATE=42703
[db2inst1@~]$

9

Hi,

we can offer a simple audit tool http://www.whitesoft.eu/solutions/white-solutions/whitecat or you can try a more robust analytical solution Connections Expert from panagenda.

--Jan