Hi,
I'm looking for a report or function that will show me a list of how many times an individual user has logged in to Tessitura, with date and time etc. I'm sure it exists somewhere but i can't seem to pin it down.
We've recently moved over to Tessitura and our desk team work on a rolling 5 over 7 contract meaning some individuals may be on the desk more than their colleagues, depending on what their days off are. We'd like to be able to see how many times an individual user has logged into the system so we can make sure we allocate the desk positions fairly. We have a manual process where we record the positions of the staff in a spreadsheet but it would be good to have a report from the system that backs it up/acts as a fall back.
Any help gratefully received.
Thanks
Crichton
Here is a SSMS query that should work:
/****************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_INTERNALWHERE user_id = @User_id--AND --tess_ug_id = 'Admin'ORDER BY logon_dt DESC;
Note that the results above will also include results from scheduled reports. For example, I have daily scheduled reports set at to run at 9:00 am and 2:00 pm daily. Those show up as a logon_dt within the results. You'll notice that the location results will be different for those.
Tessitura itself only keeps a record of the most recent login date. This is sometimes complicated in its meaning, as Neil points out.
All Tessitura user accounts are connected to internal SQL accounts. I do not know if SQL Server has more extensive login reporting, but if it does you could perhaps look to that.
Lastly, Citrix (if you are a THS client) also has user logging (I know because we've used it to better estimate our average and maximum concurrency), but that will miss processes such as scheduled reports and also Tessitura Web logins.
Thank you,
Ill have a look at those suggestions.
Neil Cole said:FROM TA_AUDIT_LOGON_INTERNAL
I've used Tessitura for a long time and have never heard of this table before today. You really do learn something(s) new every day.
It doesn't appear to be referenced in Tess sprocs very much. I see a new RP_CONCURRENT_USERS sproc created just this year. I briefly thought that the table might also be new, but, no, I see in it an entry for every time I've logged in/out since before we went live, back in March 2008. 15,755 logins/outs since then. *sigh*
A few years ago we wanted to track logout as well as login date/times, and I wish I'd known about this table then.
Huh, myself neither. Although I might have been happier not knowing...
When you gaze long into an TA_AUDIT table the TA_AUDIT table also gazes into you