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.