How to track users activity in Dhis2

You can get a file (xml or json - then convert in Excel if you want) with the user’s metadata using the export - there are also the last login time of all users, if this is what you want.

Best

Antonia

image

···

2018-02-06 11:09 GMT+01:00 Jean de Dieu Anoubissi jd.anoubissi@gmail.com:

Hi Bernard
I cannot use sql query in our instance because I don’t have access to the server. And SQL View is too limited.

Best


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2018-02-06 10:54 GMT+01:00 Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org:

Hello Jean,

I am pretty sure you can run a query in the DB to do so, not sure the graphical interface has this (other than the SQL view to run the queries)

@Others, please correct me if I am mistaken.

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.pu-ami.org

From: Dhis2-users [mailto:dhis2-users-bounces+lib.ima=pu-ami.org@lists.launchpad.net] On Behalf Of Jean de Dieu Anoubissi
Sent: Tuesday, February 6, 2018 11:51 AM
To: DHIS Users dhis2-users@lists.launchpad.net
Subject: [Dhis2-users] How to track users activity in Dhis2

Hello all,

Is it possible to know what users are doing in the system.?

If yes what is the procedure

Thank you


Virus-free. www.avast.com

Hi Jean,

If you have the possibility, using Google Analytics is an option. There are some security considerations you may need to take into account however.

At the moment however, this approach is a bit limited, as many apps do not use Google Analytics due to this limitation https://jira.dhis2.org/browse/DHIS2-1436.

If you are able to create an SQL view through the data administration app, you should be able to get some CSV data back which you could work up in Excel.

Here is a simple SQL snippet which might help you get started.

SELECT username,eventtype,extract(month from timestamp) as month,count(*)

from datastatisticsevent where age(now(),timestamp) < ‘6 months’::interval

GROUP BY username,eventtype,extract(month from timestamp)

Note, that usernames can be exposed here, so you should be careful who has access to this view.

The easiest way is to just use the “Usage analytics app” which will provide you basically the same data, but not per user.

Hope this helps.

Best regards,

Jason

image

···

On Tue, Feb 6, 2018 at 11:35 AM, Antonia - Pro antonia@informa.pro wrote:

You can get a file (xml or json - then convert in Excel if you want) with the user’s metadata using the export - there are also the last login time of all users, if this is what you want.

Best

Antonia


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2018-02-06 11:09 GMT+01:00 Jean de Dieu Anoubissi jd.anoubissi@gmail.com:

Hi Bernard
I cannot use sql query in our instance because I don’t have access to the server. And SQL View is too limited.

Best


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2018-02-06 10:54 GMT+01:00 Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org:

Hello Jean,

I am pretty sure you can run a query in the DB to do so, not sure the graphical interface has this (other than the SQL view to run the queries)

@Others, please correct me if I am mistaken.

All the best,

Bernard

Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib.ima@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.pu-ami.org

From: Dhis2-users [mailto:dhis2-users-bounces+lib.ima=pu-ami.org@lists.launchpad.net] On Behalf Of Jean de Dieu Anoubissi
Sent: Tuesday, February 6, 2018 11:51 AM
To: DHIS Users dhis2-users@lists.launchpad.net
Subject: [Dhis2-users] How to track users activity in Dhis2

Hello all,

Is it possible to know what users are doing in the system.?

If yes what is the procedure

Thank you


Virus-free. www.avast.com

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

1 Like