Re: [Dhis2-users] How to track users activity in Dhis2

2018-02-06 Thread Antonia - Pro 
 Thanks Jason,
I created this JIRA issue to solve problems exactly like this one. Hope it
will be resolved into the next release as declared. It will be very useful.

Best regards,
Antonia


*Eng. Antonia Bezenchek*
CIO - ICT Engineer
*InformaPRO S.r.l.* via Guido Guinizelli, 98/100, Roma 00152, Italy
www.informapro.it - *Follow us on* LinkedIn


2018-02-06 12:00 GMT+01:00 Jason Pickering :

> Hi Jean,
>


2018-02-06 12:00 GMT+01:00 Jason Pickering :

> 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
>
>
>
>
> On Tue, Feb 6, 2018 at 11:35 AM, Antonia - 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
>>
>>
>> 2018-02-06 11:09 GMT+01:00 Jean de Dieu Anoubissi > >:
>>
>>> 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
>>>
>>>
>>> 2018-02-06 10:54 GMT+01:00 Bernard Sadaka (IM Advisor) <
>>> lib@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



 [image: cid:image002.png@01D36F50.572585A0]

 *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@pu-ami.org

 *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)

 *Skype:* imapuami

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





 *From:* Dhis2-users [mailto:dhis2-users-bounces+lib.ima=
 pu-ami@lists.launchpad.net] *On Behalf Of *Jean de Dieu Anoubissi
 *Sent:* Tuesday, February 6, 2018 11:51 AM
 *To:* DHIS Users 
 *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
 
 <#m_3414479469341756019_m_3355446565635688959_m_5664956289659349146_m_-5275009958228714629_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

>>>
>>>
>>> ___
>>> 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
>>>
>>>
>>
>> ___
>> 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
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049 <+46%2076%20414%2070%2049>
>
___
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

Re: [Dhis2-users] How to track users activity in Dhis2

2018-02-06 Thread Jason Pickering 
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




On Tue, Feb 6, 2018 at 11:35 AM, Antonia - 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
>
>
> 2018-02-06 11:09 GMT+01:00 Jean de Dieu Anoubissi 
> :
>
>> 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
>>
>>
>> 2018-02-06 10:54 GMT+01:00 Bernard Sadaka (IM Advisor) <
>> lib@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
>>>
>>>
>>>
>>> [image: cid:image002.png@01D36F50.572585A0]
>>>
>>> *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@pu-ami.org
>>>
>>> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>>>
>>> *Skype:* imapuami
>>>
>>> *Website:* https://www.pu-ami.org
>>>
>>>
>>>
>>>
>>>
>>> *From:* Dhis2-users [mailto:dhis2-users-bounces+lib.ima=
>>> pu-ami@lists.launchpad.net] *On Behalf Of *Jean de Dieu Anoubissi
>>> *Sent:* Tuesday, February 6, 2018 11:51 AM
>>> *To:* DHIS Users 
>>> *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
>>> 
>>> <#m_3355446565635688959_m_5664956289659349146_m_-5275009958228714629_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>>
>>
>>
>> ___
>> 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
>>
>>
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
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

Re: [Dhis2-users] How to track users activity in Dhis2

2018-02-06 Thread Antonia - Pro 
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


2018-02-06 11:09 GMT+01:00 Jean de Dieu Anoubissi :

> 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
>
>
> 2018-02-06 10:54 GMT+01:00 Bernard Sadaka (IM Advisor)  >:
>
>> 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
>>
>>
>>
>> [image: cid:image002.png@01D36F50.572585A0]
>>
>> *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@pu-ami.org
>>
>> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>>
>> *Skype:* imapuami
>>
>> *Website:* https://www.pu-ami.org
>>
>>
>>
>>
>>
>> *From:* Dhis2-users [mailto:dhis2-users-bounces+lib.ima=
>> pu-ami@lists.launchpad.net] *On Behalf Of *Jean de Dieu Anoubissi
>> *Sent:* Tuesday, February 6, 2018 11:51 AM
>> *To:* DHIS Users 
>> *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
>> 
>> <#m_5664956289659349146_m_-5275009958228714629_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>
>
>
> ___
> 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
>
>
___
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

Re: [Dhis2-users] How to track users activity in Dhis2

2018-02-06 Thread Jean de Dieu Anoubissi 
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


2018-02-06 10:54 GMT+01:00 Bernard Sadaka (IM Advisor) :

> 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
>
>
>
> [image: cid:image002.png@01D36F50.572585A0]
>
> *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@pu-ami.org
>
> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (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 
> *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
> 
> <#m_-5275009958228714629_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
___
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

Re: [Dhis2-users] How to track users activity in Dhis2

2018-02-06 Thread Bernard Sadaka (IM Advisor) 
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@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@lists.launchpad.net] On Behalf 
Of Jean de Dieu Anoubissi
Sent: Tuesday, February 6, 2018 11:51 AM
To: DHIS Users 
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



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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