01/10/2023 06:06 PM
Hi Forum,
Do we have any ootb analytic report which captures all the logins made via login screen. I could not see any such under default analytics but came to know from other sources that Saviynt by default provides similar analytic repot.
01/11/2023 04:51 AM
Whats required details in report
01/11/2023 02:07 PM
Hi Rushikesh,
Thank you for the reply. Just want to confirm whether any default report available to pull details like who logged in, ipaddress, time etc..
We can write a custom one using Users, UserLogins, Userlogins_access tables. But looking for ootb report.
01/11/2023 02:24 PM
I dont find any but you can use below query
select username, ipaddress, logintime, logoutdate from userlogins ul join users u on u.userkey = ul.userkey and ul.logintime > date_sub(Now(), interval 1 hour);
02/15/2023 12:16 PM
Hi @jdoma ,
We currently do not have any OOTB analytics report that captures login transactions as you requested. But yes, you can create a custom report and schedule it as per your frequency requirement.
Thanks,