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())
Following up with my code I was too hurried to get away 2 days ago to pull up and copy. I can't remember where I found this, but it's clearly Neil's (assuming he's nc) except with my notes added since I found it.
/**************** Query to see every Tessitura Application login by user. Includes scheduled report runs by userid Does not include TOTG. Note: counting TOTG might be a good thing for hosted costs since they don't use cloud login resources. cp.RP_CONCURRENT_USERS only hits TA_AUDIT_LOGON_INTERNAL https://www.tessituranetwork.com/Help_System/Content/Reports/Concurrent-User.htm Posted on Tessitura's Website "AD Hoc Queries" (wish I could find that!) Modified slightly - nc 3/7/2021 status values 0 = successful login 1 = invalid tessitura login 2 = login is already locked 3 = SQL Server login failed 4 = too many invalid attempts so locking login 5 = invalid password entered 6 = no app access per group security settings ****************/ DECLARE @User_id VARCHAR(8) = 'userid' SELECT TOP 100 * FROM TA_AUDIT_LOGON_INTERNAL WHERE user_id = @User_id --AND --tess_ug_id = 'Admin' ORDER BY logon_dt DESC ;
Oooo, I like your commented version better. Thanks John.
Neil (nc)