dhis2-users team mailing list archive

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

Hi Muhammad,
Try this on 2.22

api/users?fields=userCredentials[name,lastLogin]&filter=userCredentials.lastLogin:gt:2015-03-30


Adjust the date to which ever date you want.

Regards,s
Jason


On Thu, May 11, 2017 at 7:53 AM, Muhammad Nadeem <nadeem1@xxxxxxxxx> wrote:

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


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