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