Hi,
We are about to roll out windows 7 and was wondering how does Tessitura capture machine name in TX_machine_location table?
The reason I want to understand this process is to we want user to be able to run application right after its installed and shouldn't have to see "This machine does not have assigned location".
The way I want to approach this is to have a SQL trigger to run stored procedure to update TX_machine_location avoiding to display that annoying message to user.
Has anyone worked on this or has any other way to achieve what we want to?
Many Thanks,
--Monic
I built a report that supervisors have access to that they can run anytime that one of the users gets the error. All that the report does is run the following query.
UPDATE TX_MACHINE_LOCATION
SET location = 1 WHERE location IS null
Once you get the error, Tessitura put the name in the table already and all you need to do is set the location.
Marty Jones
Director of Information Services
Omaha Performing Arts 1200 Douglas Street
Omaha, Nebraska 68102
P 402.661.8469
Marty.Jones@omahaperformingarts.org
www.omahaperformingarts.org
For tickets, call Ticket Omaha at 402.345.0606