How to query for users who have never logged in and whose accounts were added over 180 days ago?

[Peddiboyina Nagendrababu]

i just want to send reminders to the users who are not logged into jira with in 24 hours of time .

[Mohamed Benziane]

Hello,

Here a KB i think you will find what you want 

https://confluence.atlassian.com/jirakb/retrieve-last-login-dates-for-users-from-the-database-363364638.html

Regards