User log in and log out status

Support - Assistance technique
1

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

2

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

3

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

image

···

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

–

4

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

5

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

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

–

6

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

–

7

I am using 2.22

thanks

Nad

image

···

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

–

8

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

9

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

image

···

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

–