dhis2-users team mailing list archive

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

Hi Muhammad,
Which version are you using?

Regards,
Jason

On Thu, May 11, 2017, 6:54 AM Muhammad Nadeem <nadeem1@xxxxxxxxx> wrote:

> 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=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 <076-414%2070%2049>
>>>>
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.pickering@xxxxxxxxx
>> tel:+46764147049
>>
>
>