dhis2-users team mailing list archive

[Muhammad Nadeem <nadeem1@xxxxxxxxx>]

I am using 2.22

thanks
Nad

On Thu, May 11, 2017 at 10:03 AM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

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