Hi Muhammad, We fixed a bug a while back which allowed access to protected tables. This query may have worked for you before (but it was intended not to) but it should not work now. The "users" tables contains user password hashes, and should be considered to be very sensitive. That query could expose user password hashes to all users who can access SQL views, which would not be a great idea to have available via an SQL query, thus it has been protected to be exposed via an SQL query.
There are other ways of achieving what you want to do. For instance. https://play.dhis2.org/dev/api/users.json?fields=userCredentials[code,lastLogin]&filter=userCredentials.lastLogin:gt:2017-05-01 would show you all users (with their user name) who have logged in since May 1st 2017. You can also look for inactive users easily through the user admin app Hope this helps. Best regards, Jason On Mon, May 8, 2017 at 9:37 AM, Muhammad Nadeem <[email protected]> wrote: > Hi All, > > I am having problems in retrieving user log in and log out status. Any > one can help me out in how to get details who's login and log out > details. Please help me out. > > I am using SQL view query "SELECT * from USERS;" it shows me some > information but not the updated one. > > Please help me out. > > Thanks > Nad > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: [email protected] tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
