dhis2-users team mailing list archive

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

Well that means no one has logged in since the 1st of May. Try an earlier
date maybe like?


https://play.dhis2.org/dev/api/users.json?fields=userCredentials[code,
lastLogin]&filter=userCredentials.lastLogin:gt:2016-05-01

On Mon, May 8, 2017 at 2:24 PM, Muhammad Nadeem <nadeem1@xxxxxxxxx> wrote:

> 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=userCredent
>> ials[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 <076-414%2070%2049>
>>
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049