Tesstiura User log - tracking usage of applicaiton

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())

Parents Reply Children
No Data