Highlighted
Respected Contributor.. Respected Contributor..
Respected Contributor..
1792 views

NEED A WAY TO LOG USERS WHO LOG IN AND OUT OF ASSET MANAGER WEB

Currently, the only way I can log user info is by IP in Tomcat 6.0.32.  I need a way to log who logs in and out of Asset Manager web.

0 Likes
14 Replies
Highlighted
Absent Member.. Absent Member..
Absent Member..

Make use of AmLoginSlot table. Whenever user logs into the AM, a connection slot is assigned to him. This info is maintained in AmLoginSlot table.
0 Likes
Highlighted
Contributor.
Contributor.

Hello Jason,

 

GouravRane's statement is correct around the amLoginSlot table but please bear in mind that the connection slots get destroyed as soon as the user logs out.

 

As you did not mention which version you are currently running on it is worth mentioning that the ability to track logins for the web client was only introduced in HP Asset Manager 9.30.

 

Regards,

Deon

0 Likes
Highlighted
Respected Contributor.. Respected Contributor..
Respected Contributor..

I am running Asset Manager 5.22 (latest build) and Tomcat 6.0.32.  So I just make the change in the AmLoginslot table and it will log it in the web?

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Probably you might need to create some triggers on the database side to monitor this amLoginSlot table to log the users log in and log out of the system.

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

I have the same problem.

 

Nobody have solved the question?

 

The amloginslot track the client access.

 

If i connect via web client the amlogin slot is withouth record.

 

Thanks a lot

0 Likes
Highlighted
Micro Focus Contributor
Micro Focus Contributor

Spoiler

Am setting this up at moment so not fully there yet, however, you can approach this in a couple of ways.

Firstly, using the amLoginSlot mechanism which will capture logins to the system. If you turn on the Track modifier against this table then the records of a user logging in will be recorded in the history records. The defaults to update the table are slow so that's probably why you haven't seen the updates and you will need to change the defaults in the web config.

The second mechanism is to use change the logging settings in the log4j.properties file (this is Tomcat based but should be the same if using other web servers). Unfortunately you have to set DEBUG mode so I made this as specific as possible:

log4j.appender.fileout.File = <changed to where I wanted log file to output>

log4j.appender.fileout.MaxFileSize = 5MB

log4j.logger.com.peregrine.ac.auth.ACWSLoginModule = DEBUG, fileout

log4j.additivity.com.peregrine.ac.auth.ACWSLoginModule = false

 

This second mechanism also allows you to capture failed logins if this is useful.

 

Both of these approaches capture logins but not logouts but it should be possible to monitor the amLoginSlot table to trigger when a user logs off.

 

Hope this helps, Phil

 

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Hi Phil,

 

thanks a lot for reply.

 

I have some question for either solution :

 

 

Solution 1)How can i configure the track modifier in amloginslot table?Side asset manager o side Oracle?

What is the file and the parameter to increase side web to create record in amloginslot in web acces login?

 

Solution 2)I found many  log4j.properties.

 

C:\Tomcat55\webapps\AssetManager\WEB-INF\classes

C:\Tomcat55\webapps\AssetManagerWebService\WEB-INF\classes

 

For example the first path contain :

 

log4j.rootLogger = INFO, file
log4j.appender.file = org.apache.log4j.RollingFileAppender
log4j.appender.file.File = c:\\AssetManager.log
log4j.appender.file.layout = org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern = %d{ABSOLUTE} %5p - %c - %m%n

 

What is the most important and what i must modified?

I have open all the log4j. propierties and paramer are different.

 

Thanks a lot for the answer.

0 Likes
Highlighted
Absent Member.
Absent Member.

With the AM web client, you can monitor the connections to the database,

On Oracle there is an easy solution, by a trigger on the Oracle database when a Users logs in or out of the AM schema If that is coupled with a trigger on amloginslot, then wyouwill have your entry/exit journal.

On MS SQL Server it will be a little more complex but it can be done.

 

But this will not monitor the Users login in and out of Asset Manager Web because there is a DBMS connection pool maintained in the web Service.

Connections can be reused.

Therefore a trigger on amloginslot will probably not capture real activity of the End Users on the Web.

 

 

0 Likes
Highlighted
Absent Member.
Absent Member.

Can we clear on which version of AM web we're talking about, as has already been stated the slot usage is only getting tracked from AM 9.30 web.

0 Likes
Highlighted
Absent Member.
Absent Member.

Yes you are right tracking starts with AM 9.30.
What I am saying is that even with AM 9.30 tracking Web Users through the DBMS side is not obvious anyway.
0 Likes
Highlighted
Absent Member.
Absent Member.

HP have scripts for this as part of their SAM Best Practices, I think you can get these on Live Net now.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.