Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Fetch users who have NOT logged in since past 30/60/90 days and send reminder email — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Fetch users who have NOT logged in since past 30/60/90 days and send reminder email

Accepted answer
51
Views
4
Comments
edited Jan 9, 2023 11:16AM in Reporting and Analytics for HCM 4 comments

Summary:

Fetch users who have NOT logged in since past 30/60/90 days and send reminder email

Content (required):

I need to fetch list of users who have NOT logged in since past 30/60/90 days. Using below snippet for 30 days. I am using same query in bursting and able to send mails. How do I modify the date condition so that I can use ESS Job to send emails.

Version (include the version you are using, if applicable):it


Code Snippet (add any code snippets that support your topic, if applicable):

select 

pea.EMAIL_ADDRESS,

pu.USERNAME,

TO_CHAR(auli.LAST_LOGIN_DATE,'mm-dd-yyyy') LAST_LOGIN_DATE,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!