TRS views for EERP user last login date and time

Owned by Knowledge Assistant
Dec 29, 2023
1 min read





Description of Issue

Database tables or views for username and last login date and login time of munis user



Context

  • Tyler Reporting Services Views

  • Derived

  • Last Login Report

  • Tyler Hosted, SaaS, ASP Clients

  • OnPrem, Self-hosted Clients

  • Login Activity Log

  • SSRS, Crystal Reports



Cause

  • User attributes does not show database information.

  • User attributes exports Last login only in PDF format.

  • Need SSRS report of all EERP users and their Login datetime. 



Resolution

The username, last login date and login time in available in view sp_activity_log under columns a_idcode, al_start_date, al_start_time



Additional Information

There will be multiple records in sp_activity_log if user accesses different programs in EERP after they login. To get the time of login select the oldest record of the day or within a particular time period.

The following reference query gives the most earliest login time of user <EERP user name> on 08/12/2021

SELECT TOP 1
a_idcode,
al_program_name,
al_start_date,
al_start_time,
al_end_date,
al_end_time,
al_database
FROM sp_activity_log
WHERE a_idcode = '<munis user name>'
AND al_start_date = '20210812'
ORDER BY al_start_time ASC