Hi all,
We have users who submit data to the same org unit through the data entry forms in tracker and event programs and we were wondering if there is a way to view data per user. we need this to track the performance of each user as there may users are not performing well, and we need a mechanism to monitor each one’s activity. In sum, we would like a user monitoring report. How can we achieve this in DHIS 2?
Thanks
Hello, Fernando shake.
In response to your inquiry, I recommend that you query the database using the SQL view section of the maintenance app.
Here’s an example of a SQL query for per-user enrolment.
Select q.name as name1, p.name as name2, o.name, storedby as user, COUNT(storedby) as total_enrollment
FROM trackedentityattributevalue
INNER JOIN trackedentityinstance ON trackedentityattributevalue.trackedentityinstanceid = trackedentityinstance.trackedentityinstanceid
INNER JOIN organisationunit o ON trackedentityinstance.organisationunitid = o.organisationunitid
LEFT OUTER JOIN organisationunit p on p.organisationunitid = o.parentid
LEFT OUTER JOIN organisationunit q on q.organisationunitid = p.parentid
WHERE trackedentityattributeid IN
(SELECT trackedentityattributeid FROM trackedentityattribute WHERE trackedentityattribute.name = ‘Enrollment ID’)
AND trackedentityattributevalue.created BETWEEN ‘2000-03-01’ AND ‘2000-08-15’
GROUP BY storedby, q.name, p.name, o.name
ORDER BY q.name, storedby;
I hope our response is able to solve the issue you were facing.
With 
from the Dhistance Team.
DHISTANCE.com: The Easiest DHIS2 Setup. Up and running in 5 minutes!
No technical knowledge needed! Great Support with Data Security/Confidentiality.
