Capturing machine name

Hi Monic

Why not just add all the new machine names to the table in advance? Easy enough to script that, or just add them manually if there aren’t that many. Certainly much easier than trying to do it with a trigger.

Tess won’t automatically add the machine name into the table until someone tries to connect for the first time.

________________________________
Ken McSwain

Systems and Technology Manager

Australian Chamber Orchestra

ken.mcswain@aco.com.au

Ph   +61 2 8274 3833 ::  Mob +61 418 659 360 :: Fax  +61 2 8274 3801

PO Box R21, Royal Exchange NSW 1225

2 East Circular Quay, Sydney NSW 2000

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Monic Verma
Sent: Friday, 23 September 2011 09:54
To: Ken McSwain
Subject: [Tessitura Ticketing Forum] Capturing machine name

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

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!