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
