Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry. Saviynt Copilot Icon
This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

AD LastLogonTimeStamp not getting converted into DATE in data analyzer

SeemaDas
New Contributor III
New Contributor III

‎07/29/2024 03:58 AM

Hello Team,

        I need to find the records of users whose lastlogontimestamp is older than 30 days. In data analyzer when I am trying to provide any DATE related sql query it is not working. Is there any other way to find out such records which can be then later get used in analytics.

 

Regards,

Seema Das

Labels:
0 Kudos
1 REPLY 1

rushikeshvartak
All-Star
All-Star

‎07/29/2024 08:01 AM

Share query and sample value in accounts table


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.
0 Kudos
Copyright © 2024 Khoros, LLC