MSCITS Job Status

JobNumber	18521
RequestDate	4/24/2009
ScheduledDate	5/8/2009
CompletionDate
SuperBillingName	PSYCHIATRY
Building	East Building
Room	3429
JobDescription	Activate 1 line. Contact customer to set up time to do this. Cancelled. No line to activate. Customer not want new line at this time.
ContactFirstName	Ted
ContactLastName	Ji
Results	ids are phone line. No available data line.
Applix Incident

Misc
Ted will be moving a server and will need his static IP moved from port EAST-3A-3056D to EAST-3A-3051D. Please contact him first to coordinate date and time so he can move server at the same time. IP is 10.39.170.202.

Sort By: [Jobstatus.description] [6 : 18041]
The following data is the associated Line number(s) and IP addresse(s) for the displayed job.There may not be any records associated with the job.

Warning: User supplied query returns no records for display
SELECT Unumber.unumber , A.description, C.description ,Unumber.IPaddress FROM Unumber,ActivityType A,ConnectionType C WHERE A.activitytypecode = Unumber.activitytypecode and C.connectiontypecode = Unumber.connectiontypecode and Unumber.Jobnumber ='18521'