Hi,
I'm curious if anyone has discovered an accurate way to track how long users spend utilzing Tessitura during the day.
So far, I found a useful SSMS query in the forums, but I think this only looks at the most recent log in. Is there a daily log somewhere that provides th time stamps other than the TX_MACHINE_LOCATION table?
Here's the nifty query I found so far... Anyone have a better way?
SELECT * FROM TX_MACHINE_LOCATION tml
WHERE tml.last_logout_dt < tml.last_login_dt
AND last_login_dt >= CONVERT(DATE,getdate())
Yep, John is correct.
/****************
Query to see every Tessitura Application login by user.
Posted on Tessitura's Website "AD Hoc Queries"
Modified slightly - nc 3/7/2021
****************/
DECLARE @User_id VARCHAR(8) = 'ncole'
SELECT
TOP 100
*
FROM TA_AUDIT_LOGON_INTERNAL
WHERE
user_id = @User_id
--AND
--tess_ug_id = 'Admin'
ORDER BY logon_dt DESC
;