I am using 2.22 thanks Nad
On Thu, May 11, 2017 at 10:03 AM, Jason Pickering < [email protected]> wrote: > Hi Muhammad, > Which version are you using? > > Regards, > Jason > > On Thu, May 11, 2017, 6:54 AM Muhammad Nadeem <[email protected]> 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 < >> [email protected]> 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 <[email protected]> >>> 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 < >>>> [email protected]> 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 <[email protected]> >>>>> 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 : [email protected] >>>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>>> More help : https://help.launchpad.net/ListHelp >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Jason P. Pickering >>>>> email: [email protected] >>>>> tel:+46764147049 <076-414%2070%2049> >>>>> >>>> >>>> >>> >>> >>> -- >>> Jason P. Pickering >>> email: [email protected] >>> tel:+46764147049 >>> >> >>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
