User log in and log out status

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

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

image

Hope this helps.

Best regards,

Jason

···

On Mon, May 8, 2017 at 9:37 AM, Muhammad Nadeem nadeem1@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

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@gmail.com 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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

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

image

···

On Mon, May 8, 2017 at 2:24 PM, Muhammad Nadeem nadeem1@gmail.com 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@gmail.com 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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

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](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@gmail.com 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@gmail.com 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


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Mon, May 8, 2017 at 12:48 PM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Hi Muhammad,

Which version are you using?

Regards,

Jason

image

···

On Mon, May 8, 2017 at 5:37 PM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Mon, May 8, 2017 at 12:48 PM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

I am using 2.22

thanks

Nad

···

On Thu, May 11, 2017 at 10:03 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Muhammad,

Which version are you using?

Regards,

Jason

On Thu, May 11, 2017, 6:54 AM Muhammad Nadeem nadeem1@gmail.com 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](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@gmail.com 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@gmail.com 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


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Mon, May 8, 2017 at 12:48 PM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

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

image

···

On Thu, May 11, 2017 at 7:53 AM, Muhammad Nadeem nadeem1@gmail.com wrote:

I am using 2.22

thanks

Nad

On Thu, May 11, 2017 at 10:03 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Muhammad,

Which version are you using?

Regards,

Jason

On Thu, May 11, 2017, 6:54 AM Muhammad Nadeem nadeem1@gmail.com 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](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@gmail.com 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@gmail.com 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


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Mon, May 8, 2017 at 12:48 PM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Hi Jason,

Many thanks for help. API you provided does worked but now the only problem we are facing its not work for specific dates like 2017-02-28, 2017-03-30, 2017-04-30 and 2017-05-30.

Rest all dates its has worked liked all previous dates.

thanks

Nadeem

···

On Thu, May 11, 2017 at 4:55 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

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@gmail.com wrote:

I am using 2.22

thanks

Nad


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Thu, May 11, 2017 at 10:03 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Muhammad,

Which version are you using?

Regards,

Jason

On Thu, May 11, 2017, 6:54 AM Muhammad Nadeem nadeem1@gmail.com 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](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@gmail.com 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@gmail.com 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


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Mon, May 8, 2017 at 12:48 PM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049