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())
Thanks John and Neil! This is so helpful!