MSCITS Job Status

JobNumber	15824
RequestDate	7/30/2007
ScheduledDate	8/13/2007
CompletionDate
SuperBillingName	PEDIATRICS
Building	McDonnell Ped Research Bldg
Room
JobDescription
ContactFirstName	Craig
ContactLastName	Koopman
Results
Applix Incident

Misc
I need two static IP's lines We didn't install PRB-4A-4227, but we did install PRB-4A-4226 - 10.39.101.198 PRB-3A-3218 10.39.100.227

Sort By: [Job.Description] [19 : 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 ='15824'