Skip to main content
Top
Review meshIQ Products (G2.com)

It is possible to know the last time a user logged into Navigator

The Domain Server maintains the last login time for each account.   However, in some cases, the requirement is to get data specific to Navigator.   This is possible via a number of methods.

Option 1: It is possible to get this information from the SQL database maintained by Navigator.    This query could be used to create a report of the last time each user logged in. 

SELECT logins.login_id, logins.login_name, max(login_data.login_date)
       FROM logins INNER JOIN login_data ON logins.login_id = login_data.login_id  
       group by logins.login_id, logins.login_name 
       order by login_name;

The use of group by is required since Navigator tracks logins by IP address. 

mceclip5.png

Option 2: If you want to know the history of when a user logged in, this can be done using the audit facility.  EXCMD_INQUIRE_ACTIVE_MANAGER is the first command a user executes when connecting to a WGS.    By adding this command in Audit Management, you can capture these by user.  

mceclip1.png

and then show with audit report selecting by user and time as required.

mceclip3.png

Option 3: It is also possible to run SQL similar to option 1 against the audit tables from option 2 to create custom reports.   For example, the following query reports on each login sorted by user and time 

select USER_IDENTIFIER as "User",
       AUDIT_TIME_STRING as "Last Login",
       AUDIT_TIME_STAMP as "Time Stamp"
    from ADTINFO 
        where COMMAND_ID = '10108' 
    order by USER_IDENTIFIER,AUDIT_TIME_STAMP asc;

which produces a report like the following

mceclip6.png 

You could add various attributes to the where clause, such as for specific users or time frames.   For time frame, it is easier to use the time stamp column which is a Unix time stamp available in the databases although implemented differently.   For example, the following would return the logins from ADMIN for the last day with a MySQL database.

where COMMAND_ID = '10108' 
and USER_IDENTIFIER = 'ADMIN' 
and AUDIT_TIME_STAMP > UNIX_TIMESTAMP(now() - INTERVAL 1 DAY)

Note that with Navigator 10.3 and higher, there is a new column in the database that can be added to this select clause to see what group granted the user login right (if the user has multiple groups, this would be the first that provided this right). 

GROUP_NAME as "User Group" ,

Shows the following 

mceclip7.png