Wednesday, January 6, 2010

PSACCESSLOG Table


I got a requirement to create a dashboard for a recruiter to display the Job openings created after his previous login. I first thought of using PSOPRDEFN table to pick the last sign out date time. But it won't work as every time it gets updated for each login and logout.

I came to know about the table, PSACCESSLOG, which stores the IP address, login ,logout and, the oprid. The IP address refers to the system from which the user logs into the system. It can be from the company's intranet, from home or from a internet café.

All I have to do is to fetch the second maximum login, logout time to complete by requirement

0 comments:

Post a Comment

Total Pageviews

Copyright © Tech & Management Notes