dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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 <nadeem1@xxxxxxxxx> 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     : 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