I have been searching for a report or log that will give me user information such as number of times they have logged into the system for a period of time. I do know of the field "Last_Logon_Date" in KNTA_USERS table. Is there another table used for logging?
Just a note on this table. Only the unsuccessful attempts are kept over time. Unfortunately, the succeeded attempts are only kept temporarily. Not sure of the pattern of what is kept. But it's only about a weeks worth of past signons.
This file is not going to help find the usage of a user over a certain period of time, unfortunately.
Don't know if this will help, but I have a "Users Not Using" query for this kind of analysis: SELECT max(la.creation_date) LAST_LOGIN, round(sysdate - max(la.creation_date)) DAYS_FROM_LOGIN, u.authentication_mode,p.product_name LICENSE_NAME, (u.first_name || ' ' || u.last_name) FULL_NAME, u.username USERNAME,u.email_address, u.user_id USER_ID, u.creation_date CREATION_DATE FROM KNTA_USERS u, KNTA_LOGON_ATTEMPTS la, knta_products p, knta_user_products up WHERE up.user_id=u.user_id AND ((u.end_date is NULL) OR (u.end_date > sysdate)) and p.product_id = up.product_id AND u.USER_ID = la.USER_ID (+) GROUP BY u.user_id, u.username, u.email_address,u.first_name, u.last_name, u.authentication_mode, p.product_name, u.creation_date order by days_from_login desc
Thanks. This is similar to a query I use that will group users that have signed on < 30 days, < 60 days or over 60 days ago.
I really am looking for information that will tell me that resource managers are in the tool on an average of 99 times month. Unless there is a log that keeps track of all the successful times a user has signed on, I don't believe I can gather this data.
Hello Dana, I spent some time in the DB, the table I mentioned seems to be cleaned up by PPM periodically and I don't know a server.conf paramter to control this. Maybe you can derive the information you need from some transaction tables in PPM (like kcrt_transactions). This way you won't capture "readers", of course.