Precisely Speaking

Application Support => Prelude Support => Topic started by: DonQuixote on August 21, 2018, 12:48:00 PM

Title: User Activity
Post by: DonQuixote on August 21, 2018, 12:48:00 PM
Is there a list somewhere showing LOGIN activity by USER.ID?
I'm not saying all their actions; I'm just saying logging into the system.
Title: Re: User Activity
Post by: Tom Pellitieri on August 21, 2018, 02:50:01 PM
There isn't a standard report anywhere that I know about.  However....

Attribute 24 of the User ID Record in DMSECURITY appears to have a MV with the ten most recent SB+ login date, time, and port.  For example, my record (~TRP) has these values:


The first value shows I logged in today (Pick date 18496) at 36,387 seconds past midnight (10:06:27 am) on Port 11

There's no indication of when they log out. 

You may find additional information at the O/S level, using the O/S login.  In (Red Hat) Linux, you may use

last login-id

to get a list with login and duration.

Title: Re: User Activity
Post by: Tom Pellitieri on August 22, 2018, 06:35:27 AM
Just a follow up on this:

It appears that there's only one entry per Port number.  I checked the attribute, logged off SB+, then logged back in without disconnecting my Linux account.  I rechecked, and there was not a second value for the current port.  The login time matched the new login.

We're currently using SB+ on a Red Hat Linux system with UniData.  In UniData, users are assigned the lowest available port number when they connect.  This was true when we used AIX as well.  When we were on Advanced Pick/Pick D3 under AIX (17+ years ago), port numbers were static based on physical (tty) connections.
Title: Re: User Activity
Post by: DonQuixote on August 22, 2018, 08:16:47 AM
Thank you.  This is providing the information requested.
I am on a similar system as you describe.  Another suggestion someone else provided was on the AIX level.
They said all the login information is maintained in /etc/security/lastlog   file.   But, since only root has access the benefit is limited.
Thanks again.  I did have to create dictionary items since the attribute you mentioned is an undocumented feature.  lol.
Title: Re: User Activity
Post by: precisonline on October 11, 2018, 03:03:51 PM
There's an *nix command called "last" that might be useful as well.  That gives access to the user log file without being root.