Author Topic: User Activity  (Read 177 times)

DonQuixote

  • Rock Star
  • *****
  • Posts: 188
  • To Dream the Impossible Dream...
User Activity
« 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.

Tom Pellitieri

  • Rock Star
  • *****
  • Posts: 223
  • Tom Pellitieri - Toledo, Ohio
Re: User Activity
« Reply #1 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:

1849636387.0011
1849634370.0058
1849632836.0049
1849557503.0007
1849540550.0072
1849529878.0054
1849529865.0053
1849229330.0056
1849229324.0043
1849131930.0057

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.

--Tom

Tom Pellitieri

  • Rock Star
  • *****
  • Posts: 223
  • Tom Pellitieri - Toledo, Ohio
Re: User Activity
« Reply #2 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.

DonQuixote

  • Rock Star
  • *****
  • Posts: 188
  • To Dream the Impossible Dream...
Re: User Activity
« Reply #3 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.

precisonline

  • President
  • Administrator
  • Rock Star
  • *****
  • Posts: 1592
    • Precision Solutions
Re: User Activity
« Reply #4 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.
-Kevin
Accidents "happen"; success, however, is planned and executed.