We’re planning to switch gateway servers tonight and would like to gracefully shut off the old one without interrupting web users. Does anyone know of a way to determine if anyone is logged on to ‘webuser’? And better yet if they have any seats locked?
There is a shared report called Web Current Seat Locks. That will show you all locked seats for any season. You could also do sp_who in SSMS.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Vivino Sent: Monday, February 06, 2012 10:02 AM To: Gloria Ormsby Subject: [Tessitura Technical Forum] Who is logged in?
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!
There’s also the web api seat connection count…http://gateway/webapitest/tessitura.asmx/WebSeatServerConnectionCount Substitute gateway with your api server name, and webapitest with your Live or Test instance. ---Tak From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gloria OrmsbySent: Monday, February 06, 2012 10:12 AMTo: Lai, TakSubject: RE: [Tessitura Technical Forum] Who is logged in? There is a shared report called Web Current Seat Locks. That will show you all locked seats for any season. You could also do sp_who in SSMS. From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David VivinoSent: Monday, February 06, 2012 10:02 AMTo: Gloria OrmsbySubject: [Tessitura Technical Forum] Who is logged in? We’re planning to switch gateway servers tonight and would like to gracefully shut off the old one without interrupting web users. Does anyone know of a way to determine if anyone is logged on to ‘webuser’? And better yet if they have any seats locked? This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!Tak LaiManager, Network ArchitectureCarnegie Hall881 Seventh Avenue, New York, NY 10019Tel: 212-903-0905Fax: 212-822-7700tlai@carnegiehall.org carnegiehall.org | facebook | twitter | youtube | blog Please consider the environment before printing this e-mail This E-mail and any attachments thereto is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this E-mail or the information herein by anyone other than the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, is prohibited. If you receive this E-mail in error please immediately notify me at 212-903-9600 and permanently destroy the original E-mail message, all copies, and any printout thereof. [V.2007.0809.CARNEGIE.HALL.CORPORATION]
There’s also the web api seat connection count…
http://gateway/webapitest/tessitura.asmx/WebSeatServerConnectionCount
Substitute gateway with your api server name, and webapitest with your Live or Test instance.
---Tak
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gloria OrmsbySent: Monday, February 06, 2012 10:12 AMTo: Lai, TakSubject: RE: [Tessitura Technical Forum] Who is logged in?
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David VivinoSent: Monday, February 06, 2012 10:02 AMTo: Gloria OrmsbySubject: [Tessitura Technical Forum] Who is logged in?
carnegiehall.org | facebook | twitter | youtube | blog Please consider the environment before printing this e-mail This E-mail and any attachments thereto is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this E-mail or the information herein by anyone other than the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, is prohibited. If you receive this E-mail in error please immediately notify me at 212-903-9600 and permanently destroy the original E-mail message, all copies, and any printout thereof. [V.2007.0809.CARNEGIE.HALL.CORPORATION]
Please consider the environment before printing this e-mail
This E-mail and any attachments thereto is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this E-mail or the information herein by anyone other than the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, is prohibited. If you receive this E-mail in error please immediately notify me at 212-903-9600 and permanently destroy the original E-mail message, all copies, and any printout thereof.
[V.2007.0809.CARNEGIE.HALL.CORPORATION]
Thank you both very much! I will use both of your suggestions!!
…Dave
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tak Lai Sent: Monday, February 06, 2012 10:32 AM To: Vivino, David Subject: RE: [Tessitura Technical Forum] Who is logged in?
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gloria Ormsby Sent: Monday, February 06, 2012 10:12 AM To: Lai, Tak Subject: RE: [Tessitura Technical Forum] Who is logged in?
Tak Lai Manager, Network Architecture Carnegie Hall 881 Seventh Avenue, New York, NY 10019 Tel: 212-903-0905 Fax: 212-822-7700 tlai@carnegiehall.org
carnegiehall.org | facebook | twitter | youtube | blog