Query to see active sessions in Enterprise ERP

Client wants to see a list of users that have open sessions in Enterprise ERP

• Enterprise ERP any version

• Tyler Reporting Services

• SaaS, OnPrem hosted clients

• System Audit

Client wants to report on active sessions outside of the Diagnostic Utility 

The following sample SQL query will give you who is currently logged into ERP with an active window:

SELECT *  
FROM sp_activity_log 
WHERE
CAST(al_start_date AS DATE) =CAST(GETDATE() AS DATE)
AND al_end_date  is NULL