dhis2-users team mailing list archive

[Antonia - Pro <antonia@xxxxxxxxxxx>]

 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
<https://www.linkedin.com/company/informapro>

2018-02-06 12:00 GMT+01:00 Jason Pickering <jason.p.pickering@xxxxxxxxx>:

> Hi Jean,
>
<https://www.linkedin.com/company/informapro>

2018-02-06 12:00 GMT+01:00 Jason Pickering <jason.p.pickering@xxxxxxxxx>:

> 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 <antonia@xxxxxxxxxxx>
> 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 <jd.anoubissi@xxxxxxxxx
>> >:
>>
>>> 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.ima@xxxxxxxxxx>:
>>>
>>>> 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.ima@xxxxxxxxxx
>>>>
>>>> *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@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Jean de Dieu Anoubissi
>>>> *Sent:* Tuesday, February 6, 2018 11:51 AM
>>>> *To:* DHIS Users <dhis2-users@xxxxxxxxxxxxxxxxxxx>
>>>> *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
>>>>
>>>>
>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon> Virus-free.
>>>> www.avast.com
>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link>
>>>> <#m_3414479469341756019_m_3355446565635688959_m_5664956289659349146_m_-5275009958228714629_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>>>
>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049 <+46%2076%20414%2070%2049>
>