Project and Portfolio Management Practitioners Forum
cancel

Login History of Users

Highlighted
rhussain
New Member.

Login History of Users

Hi

 

I was interested to know if it is possible to fetch the following information about the users

- When any particular user logged in - Logged Out
- How many users are logging in to the PPM system

- A particular user is accessing how many Projects / Demands

 

etc.

If any body know this, please let me know

 

regards

- raheel
2 REPLIES
Utkarsh_Mishra
Acclaimed Contributor.

Re: Login History of Users

For log-in & log-out information you can query knta_users_v

for How many user currently logged in... you can run this report from workbench.. Server Admin->Admin Tool-> Server Logon Report

for accessing issue.. I believe there is no option.
Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Celil
Acclaimed Contributor.

Re: Login History of Users

Hi,

 

Utkarsh said current PPM ability. You can extend it with some oracle development by triggers. For example KNTA_USERS table just show us last login date-time. When user log in to system this field is updating. If you catch this action up by oracle triger and write down required information to a cutomized table, you can get login information statistics.

 

Celil

Celil

IT Governance Professional
& PPM Solution Architect