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.picker...@gmail.com>: > Hi Jean, > <https://www.linkedin.com/company/informapro> 2018-02-06 12:00 GMT+01:00 Jason Pickering <jason.p.picker...@gmail.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 > > > > > On Tue, Feb 6, 2018 at 11:35 AM, Antonia - Pro <anto...@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 >> >> >> 2018-02-06 11:09 GMT+01:00 Jean de Dieu Anoubissi <jd.anoubi...@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 >>> >>> >>> 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 <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 >>>> >>>> >>>> <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@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