dhis2-users team mailing list archive

[Muhammad Nadeem <nadeem1@xxxxxxxxx>]

Hi

I have tried earlier date and in my case its shows like as follows:

{"pager":{"page":1,"pageCount":2,"total":81,"pageSize":50,"nextPage":"http://greenstar/api/users?page=2"},"users":[{"userCredentials":{"lastLogin":"2017-02-26T14:40:53.728+0000"}},{"userCredentials":{"lastLogin":"2017-02-26T14:38:37.332+0000"}}

not showing who login to system.


please help



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

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