Login Information

[moshe]

Is there any table in the OTM which captures the login information such that we can query on the number of user's logged in currently?

[oliver]

Re: Login Information

I think that this information is part of either the App or Web-Server. In OTM you can have a look at GL_USER, but its per user so you would need to write your own summary-qry. Table :


GL_USER_GID VARCHAR2(12NOT NULL GL_USER_XID VARCHAR2(50)NOT NULL GL_PASSWORDVARCHAR2(12NOT NULL DOMAIN_NAMEVARCHAR2(50)NOT NULL IS_AD_HOC_REPORTS_USERVARCHAR2(1)NOT NULL Y/N LAST_LOGIN_DATEDATE AD_HOC_REPORTS_DB_TYPEVARCHAR2(100) OLTP/ODS GL_ACCOUNT_POLICY_GID (FK: GL_ACCOUNT_POLICY)VARCHAR2(101) PW_EXPIRATION_DATE DATE ACCOUNT_LOCKOUT_TIME DATE USERNAMEVARCHAR2(101) UNIQUE DEFAULT_USER_ROLE_GID (FK: USER_ROLE)VARCHAR2(101)NOT NULL IS_ADVANCED_ANALYTICS_USERVARCHAR2(1)NOT NULL Y/N DEFAULT_AA_REPORTVARCHAR2(100) DOCUMENT_USE_PROFILE_GID (FK: DOCUMENT_USE_PROFILE)VARCHAR2(101) INSERT_USERVARCHAR2(12NOT NULL INSERT_DATEDATENOT NULL UPDATE_USERVARCHAR2(12 UPDATE_DATEDATE

[cunninghamg]

Re: Login Information

Hi Moshe

Actually the GL_user table only shows the configured users (unless its changed since v4.5).

If you add an Account Policy to each user, where the Account Policy has the Record Login box checked, then OTM will log attempts (sucessful or not) in the table gl_login_history.

This will only tell you when they log in though - there's no way to know when they log out.

Hope this helps
Gary

[chrisplough]

Re: Login Information

Gary is right -- OTM doesn't provide this functionality.

Back in an earlier version (v4.0, I think) there was a servlet that would list out current sessions (and therefore logged-in users), however it broke when we upgraded Tomcat versions, and the code was never updated. I'd recommend creating an Enhancement Request for this through Oracle, as this would be a very helpful admin utility.

In addition, I've heard the same request from many OTM administrators -- if we can get enough requests to Oracle, they'll get it done.

--Chris

[gokul]

Re: Login Information

HI

Guys is it possible to see the history in 5.5 and later versions, in 5.5.3 there is no check box called Record Login, only there is a check box called keep login history but there is no records in gl_login_history,

whether there is any files in the sever side to this records, if so please let me know.

[cunninghamg]

Re: Login Information

Hi Gokul

It is the 'keep login history' that needs checking as you point out.

Make sure that your users have the Account Policy applied in the User Manager. Each User must have the policy applied before this will work.

It is certainly working in 5.5

Gary

btw - You can see login history from the UI - look in Configuration and Administration -> User Management -> Login History

[gokul]

Re: Login Information

Hi Gary,

i checked the user in the user management, the account policy is properly assigned but it is not refelected in the gl_login_history as well as in the application Login History.

[cunninghamg]

Re: Login Information

Hi Gokul

These are the steps required.
It is all I needed to do.
If you are still having a problem - you should talk to support.

Cheers

Gary

[gokul]

Re: Login Information

Hi Gray,

Thanks For ur assistance

[kiru_i]

Re: Login Information

Hi Gokul,

Did you manage to solve the issue....?

I am also having the same probem, not populating gl_login_history table after done all the necessary stpes like setup Account Policy and assigned it to the users...

We are using OTM v5.5 CU2.

Any advice....

Thanks in advance,

Rgds,
Kiru.