Notifications
Clear all
Topic starter
Hi Everyone,
I am trying to find an efficient way to look at which users in a security group have accessed CPS in the past 3 months. This would help cut down our auditing time, since we would not have to check any user that did not access the system in the reporting period.
Has anyone done this, or even better, built a report that does this for them?
Thank you in advance. Our Security officer is most grateful as well! 🙂
Posted : August 26, 2015 9:30 am
There is a LAST_LOGIN_DATE field in the USR table.
Posted : August 26, 2015 9:47 am
Topic starter
This is excellent, thank you. If no one else has a report we will build ours using this. I'll still take an already made report if available, but if not, this will put me on the right track.
Posted : August 26, 2015 1:58 pm
