dhis2-users team mailing list archive

[Muhammad Nadeem <nadeem1@xxxxxxxxx>]

Thanks Jason,

I did process and follow your instruction and in result this is what i have
got it.



{"pager":{"page":1,"pageCount":1,"total":0,"pageSize":50},"users":[]}



please help me

thanks Nad



On Mon, May 8, 2017 at 12:48 PM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> 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
>