SQL Query

SQL Query

I have this SQL Query, which works fine. However I have another table domain_SLPImage, that has a field named"storageServiceName" that I want to add to the result of the quey below. the key is "masterServerId"

Thank you
select TOP 20 START AT 1 domain_MasterServer.id as "domain_MasterServer.id",domain_MediaServer.id as "domain_MediaServer.id",domain_Policy.name as "domain_Policy.name",domain_Policy.keyword as "domain_Policy.keyword",domain_Schedule.hasCalendarSched as "domain_Schedule.hasCalendarSched",domain_Schedule.frequency as "domain_Schedule.frequency",domain_Schedule.name as "domain_Schedule.name",domain_Schedule.numberOfCopies as "domain_Schedule.numberOfCopies",domain_Schedule.type as "domain_Schedule.type",nb_JobAttemptArchive.destStorageUnit as "nb_JobAttemptArchive.destStorageUnit",domain_Client.id as "domain_Client.id",domain_Client.osType as "domain_Client.osType",domain_DiskPool.name as "domain_DiskPool.name",nb_DiskVolume.name as "nb_DiskVolume.name",nb_StorageServer.name as "nb_StorageServer.name" from domain_JobArchive , domain_DiskPool , domain_Client , domain_MediaServer , domain_MasterServer , domain_Policy , domain_Schedule , nb_JobAttemptArchive , nb_DiskVolume , nb_StorageServer , nb_JobArchive , nb_DiskPool , domain_ImageCopy , domain_ImageFragment , domain_JobImage , domain_Image , domain_ScheduledJob where domain_MasterServer.id = domain_JobArchive.masterServerId and domain_MasterServer.id = domain_DiskPool.masterServerId and domain_MasterServer.id = domain_Client.masterServerId and domain_MasterServer.id = domain_MediaServer.masterServerId and domain_MasterServer.id = domain_Policy.masterServerId and domain_MasterServer.id = domain_Policy.masterServerId AND domain_Policy.masterServerId = domain_Schedule.masterServerId and domain_Policy.name = domain_Schedule.policyName and domain_Policy.policyDomainName = domain_Schedule.policyDomainName and domain_Policy.versionNo = domain_Schedule.policyVersionNo and domain_MasterServer.id = domain_JobArchive.masterServerId AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id AND nb_JobArchive.masterServerId = nb_JobAttemptArchive.masterserverId and nb_JobArchive.clientName = nb_JobAttemptArchive.clientName and nb_JobArchive.id = nb_JobAttemptArchive.jobId and domain_MasterServer.id = nb_DiskPool.masterServerId AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId and nb_DiskPool.name = nb_DiskVolume.diskPoolId and nb_DiskPool.serverType = nb_DiskVolume.serverType and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName and domain_MasterServer.id = nb_StorageServer.masterServerId and domain_MediaServer.masterServerId = domain_JobArchive.masterServerId and domain_MediaServer.name = domain_JobArchive.jobMediaServerName and domain_DiskPool.masterServerId = nb_DiskPool.masterServerId and domain_DiskPool.name = nb_DiskPool.name and domain_DiskPool.serverType = nb_DiskPool.serverType and domain_DiskPool.storageServerName = nb_DiskPool.storageServerName AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId and nb_DiskPool.name = nb_DiskVolume.diskPoolId and nb_DiskPool.serverType = nb_DiskVolume.serverType and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId and domain_ImageCopy.imageId = domain_ImageFragment.imageId and domain_ImageCopy.id = domain_ImageFragment.copyId AND domain_MediaServer.masterServerId = domain_ImageCopy.masterServerId and domain_MediaServer.name = domain_ImageCopy.mediaServerName and domain_Client.masterServerId = domain_JobArchive.masterServerId and domain_Client.name = domain_JobArchive.clientName AND domain_MediaServer.masterServerId = domain_JobArchive.masterServerId and domain_MediaServer.name = domain_JobArchive.jobMediaServerName and domain_MediaServer.masterServerId = domain_JobArchive.masterServerId and domain_MediaServer.name = domain_JobArchive.jobMediaServerName AND domain_Policy.masterServerId = domain_JobArchive.masterServerId and domain_Policy.name = domain_JobArchive.policyName and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName and domain_Policy.versionNo = domain_JobArchive.policyVersionNo and domain_MediaServer.masterServerId = domain_JobArchive.masterServerId and domain_MediaServer.name = domain_JobArchive.jobMediaServerName AND domain_Schedule.masterServerId = domain_JobArchive.masterServerId and domain_Schedule.policyName = domain_JobArchive.policyName and domain_Schedule.policyDomainName = domain_JobArchive.policyDomainName and domain_Schedule.policyVersionNo = domain_JobArchive.policyVersionNo and domain_Schedule.name = domain_JobArchive.scheduleName and domain_MediaServer.masterServerId = nb_JobAttemptArchive.masterserverId and domain_MediaServer.masterServerId = nb_JobAttemptArchive.masterserverId and ( domain_MediaServer.name = nb_JobAttemptArchive.srcMediaServerName OR domain_MediaServer.name = nb_JobAttemptArchive.destMediaServerName ) and domain_MediaServer.masterServerId = domain_ImageCopy.masterServerId and domain_MediaServer.name = domain_ImageCopy.mediaServerName AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId and domain_ImageCopy.imageId = domain_ImageFragment.imageId and domain_ImageCopy.id = domain_ImageFragment.copyId AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId and domain_MediaServer.masterServerId = domain_ImageCopy.masterServerId and domain_MediaServer.name = domain_ImageCopy.mediaServerName AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId and domain_ImageCopy.imageId = domain_ImageFragment.imageId and domain_ImageCopy.id = domain_ImageFragment.copyId AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId and nb_DiskPool.name = nb_DiskVolume.diskPoolId and nb_DiskPool.serverType = nb_DiskVolume.serverType and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName AND nb_StorageServer.masterServerId = nb_DiskPool.masterServerId and nb_StorageServer.serverType = nb_DiskPool.serverType and nb_StorageServer.name = nb_DiskPool.storageServerName and domain_DiskPool.masterServerId = nb_DiskPool.masterServerId and domain_DiskPool.name = nb_DiskPool.name and domain_DiskPool.serverType = nb_DiskPool.serverType and domain_DiskPool.storageServerName = nb_DiskPool.storageServerName AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId and nb_DiskPool.name = nb_DiskVolume.diskPoolId and nb_DiskPool.serverType = nb_DiskVolume.serverType and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId and domain_ImageCopy.imageId = domain_ImageFragment.imageId and domain_ImageCopy.id = domain_ImageFragment.copyId AND domain_Image.masterServerId = domain_ImageCopy.masterServerId and domain_Image.id = domain_ImageCopy.imageId AND domain_Image.masterServerId = domain_JobImage.masterServerId and domain_Image.id = domain_JobImage.imageId AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId and domain_JobArchive.clientName = domain_JobImage.clientName and domain_JobArchive.id = domain_JobImage.jobId AND domain_Policy.masterServerId = domain_JobArchive.masterServerId and domain_Policy.name = domain_JobArchive.policyName and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName and domain_Policy.versionNo = domain_JobArchive.policyVersionNo and domain_Client.masterServerId = domain_JobArchive.masterServerId and domain_Client.name = domain_JobArchive.clientName AND domain_Policy.masterServerId = domain_JobArchive.masterServerId and domain_Policy.name = domain_JobArchive.policyName and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName and domain_Policy.versionNo = domain_JobArchive.policyVersionNo and domain_Policy.masterServerId = domain_JobArchive.masterServerId and domain_Policy.name = domain_JobArchive.policyName and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName and domain_Policy.versionNo = domain_JobArchive.policyVersionNo AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id AND nb_JobArchive.masterServerId = nb_JobAttemptArchive.masterserverId and nb_JobArchive.clientName = nb_JobAttemptArchive.clientName and nb_JobArchive.id = nb_JobAttemptArchive.jobId and domain_Policy.masterServerId = domain_JobArchive.masterServerId and domain_Policy.name = domain_JobArchive.policyName and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName and domain_Policy.versionNo = domain_JobArchive.policyVersionNo AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId and domain_JobArchive.clientName = domain_JobImage.clientName and domain_JobArchive.id = domain_JobImage.jobId AND domain_Image.masterServerId = domain_JobImage.masterServerId and domain_Image.id = domain_JobImage.imageId AND domain_Image.masterServerId = domain_ImageCopy.masterServerId and domain_Image.id = domain_ImageCopy.imageId AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId and domain_ImageCopy.imageId = domain_ImageFragment.imageId and domain_ImageCopy.id = domain_ImageFragment.copyId AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId and domain_Policy.masterServerId = domain_JobArchive.masterServerId and domain_Policy.name = domain_JobArchive.policyName and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName and domain_Policy.versionNo = domain_JobArchive.policyVersionNo AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId and domain_JobArchive.clientName = domain_JobImage.clientName and domain_JobArchive.id = domain_JobImage.jobId AND domain_Image.masterServerId = domain_JobImage.masterServerId and domain_Image.id = domain_JobImage.imageId AND domain_Image.masterServerId = domain_ImageCopy.masterServerId and domain_Image.id = domain_ImageCopy.imageId AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId and domain_ImageCopy.imageId = domain_ImageFragment.imageId and domain_ImageCopy.id = domain_ImageFragment.copyId AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId and nb_DiskPool.name = nb_DiskVolume.diskPoolId and nb_DiskPool.serverType = nb_DiskVolume.serverType and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName AND nb_StorageServer.masterServerId = nb_DiskPool.masterServerId and nb_StorageServer.serverType = nb_DiskPool.serverType and nb_StorageServer.name = nb_DiskPool.storageServerName and domain_DiskPool.masterServerId = nb_DiskPool.masterServerId and domain_DiskPool.name = nb_DiskPool.name and domain_DiskPool.serverType = nb_DiskPool.serverType and domain_DiskPool.storageServerName = nb_DiskPool.storageServerName AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId and nb_DiskPool.name = nb_DiskVolume.diskPoolId and nb_DiskPool.serverType = nb_DiskVolume.serverType and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId and domain_ImageCopy.imageId = domain_ImageFragment.imageId and domain_ImageCopy.id = domain_ImageFragment.copyId AND domain_Image.masterServerId = domain_ImageCopy.masterServerId and domain_Image.id = domain_ImageCopy.imageId AND domain_Image.masterServerId = domain_JobImage.masterServerId and domain_Image.id = domain_JobImage.imageId AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId and domain_JobArchive.clientName = domain_JobImage.clientName and domain_JobArchive.id = domain_JobImage.jobId AND domain_Schedule.masterServerId = domain_JobArchive.masterServerId and domain_Schedule.policyName = domain_JobArchive.policyName and domain_Schedule.policyDomainName = domain_JobArchive.policyDomainName and domain_Schedule.policyVersionNo = domain_JobArchive.policyVersionNo and domain_Schedule.name = domain_JobArchive.scheduleName and domain_Client.masterServerId = domain_ScheduledJob.masterServerId and domain_Client.name = domain_ScheduledJob.clientName AND domain_Schedule.masterServerId = domain_ScheduledJob.masterServerId and domain_Schedule.policyName = domain_ScheduledJob.policyName and domain_Schedule.policyDomainName = domain_ScheduledJob.policyDomainName and domain_Schedule.policyVersionNo = domain_ScheduledJob.policyVersionNo and domain_Schedule.name = domain_ScheduledJob.scheduleName and domain_Schedule.masterServerId = domain_JobArchive.masterServerId and domain_Schedule.policyName = domain_JobArchive.policyName and domain_Schedule.policyDomainName = domain_JobArchive.policyDomainName and domain_Schedule.policyVersionNo = domain_JobArchive.policyVersionNo and domain_Schedule.name = domain_JobArchive.scheduleName AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id AND nb_JobArchive.masterServerId = nb_JobAttemptArchive.masterserverId and nb_JobArchive.clientName = nb_JobAttemptArchive.clientName and nb_JobArchive.id = nb_JobAttemptArchive.jobId and domain_Schedule.masterServerId = domain_JobArchive.masterServerId and domain_Schedule.policyName = domain_JobArchive.policyName and domain_Schedule.policyDomainName = domain_JobArchive.policyDomainName and domain_Schedule.policyVersionNo = domain_JobArchive.policyVersionNo and domain_Schedule.name = domain_JobArchive.scheduleName AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId and domain_JobArchive.clientName = domain_JobImage.clientName and domain_JobArchive.id = domain_JobImage.jobId AND domain_Image.masterServerId = domain_JobImage.masterServerId and domain_Image.id = domain_JobImage.imageId AND domain_Image.masterServerId = domain_ImageCopy.masterServerId and domain_Image.id = domain_ImageCopy.imageId AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId and domain_ImageCopy.imageId = domain_ImageFragment.imageId and domain_ImageCopy.id = domain_ImageFragment.copyId AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId and domain_Schedule.masterServerId = domain_JobArchive.masterServerId and domain_Schedule.policyName = domain_JobArchive.policyName and domain_Schedule.policyDomainName = domain_JobArchive.policyDomainName and domain_Schedule.policyVersionNo = domain_JobArchive.policyVersionNo and domain_Schedule.name = domain_JobArchive.scheduleName AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId and domain_JobArchive.clientName = domain_JobImage.clientName and domain_JobArchive.id = domain_JobImage.jobId AND domain_Image.masterServerId = domain_JobImage.masterServerId and domain_Image.id = domain_JobImage.imageId AND domain_Image.masterServerId = domain_ImageCopy.masterServerId and domain_Image.id = domain_ImageCopy.imageId AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId and domain_ImageCopy.imageId = domain_ImageFragment.imageId and domain_ImageCopy.id = domain_ImageFragment.copyId AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId and nb_DiskPool.name = nb_DiskVolume.diskPoolId and nb_DiskPool.serverType = nb_DiskVolume.serverType and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName AND nb_StorageServer.masterServerId = nb_DiskPool.masterServerId and nb_StorageServer.serverType = nb_DiskPool.serverType and nb_StorageServer.name = nb_DiskPool.storageServerName and domain_DiskPool.masterServerId = nb_DiskPool.masterServerId and domain_DiskPool.name = nb_DiskPool.name and domain_DiskPool.serverType = nb_DiskPool.serverType and domain_DiskPool.storageServerName = nb_DiskPool.storageServerName AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId and nb_DiskPool.name = nb_DiskVolume.diskPoolId and nb_DiskPool.serverType = nb_DiskVolume.serverType and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId and domain_ImageCopy.imageId = domain_ImageFragment.imageId and domain_ImageCopy.id = domain_ImageFragment.copyId AND domain_Image.masterServerId = domain_ImageCopy.masterServerId and domain_Image.id = domain_ImageCopy.imageId AND domain_Image.masterServerId = domain_JobImage.masterServerId and domain_Image.id = domain_JobImage.imageId AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId and domain_JobArchive.clientName = domain_JobImage.clientName and domain_JobArchive.id = domain_JobImage.jobId AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id AND nb_JobArchive.masterServerId = nb_JobAttemptArchive.masterserverId and nb_JobArchive.clientName = nb_JobAttemptArchive.clientName and nb_JobArchive.id = nb_JobAttemptArchive.jobId and domain_Client.masterServerId = domain_JobArchive.masterServerId and domain_Client.name = domain_JobArchive.clientName AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id AND nb_JobArchive.masterServerId = nb_JobAttemptArchive.masterserverId and nb_JobArchive.clientName = nb_JobAttemptArchive.clientName and nb_JobArchive.id = nb_JobAttemptArchive.jobId and nb_JobArchive.masterServerId = nb_JobAttemptArchive.masterserverId and nb_JobArchive.clientName = nb_JobAttemptArchive.clientName and nb_JobArchive.id = nb_JobAttemptArchive.jobId AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId and domain_JobArchive.clientName = domain_JobImage.clientName and domain_JobArchive.id = domain_JobImage.jobId AND domain_Image.masterServerId = domain_JobImage.masterServerId and domain_Image.id = domain_JobImage.imageId AND domain_Image.masterServerId = domain_ImageCopy.masterServerId and domain_Image.id = domain_ImageCopy.imageId AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId and domain_ImageCopy.imageId = domain_ImageFragment.imageId and domain_ImageCopy.id = domain_ImageFragment.copyId AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId and nb_DiskPool.name = nb_DiskVolume.diskPoolId and nb_DiskPool.serverType = nb_DiskVolume.serverType and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName AND nb_StorageServer.masterServerId = nb_DiskPool.masterServerId and nb_StorageServer.serverType = nb_DiskPool.serverType and nb_StorageServer.name = nb_DiskPool.storageServerName and domain_Client.masterServerId = domain_JobArchive.masterServerId and domain_Client.name = domain_JobArchive.clientName AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId and domain_JobArchive.clientName = domain_JobImage.clientName and domain_JobArchive.id = domain_JobImage.jobId AND domain_Image.masterServerId = domain_JobImage.masterServerId and domain_Image.id = domain_JobImage.imageId AND domain_Image.masterServerId = domain_ImageCopy.masterServerId and domain_Image.id = domain_ImageCopy.imageId AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId and domain_ImageCopy.imageId = domain_ImageFragment.imageId and domain_ImageCopy.id = domain_ImageFragment.copyId AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId and nb_DiskPool.name = nb_DiskVolume.diskPoolId and nb_DiskPool.serverType = nb_DiskVolume.serverType and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName AND domain_DiskPool.masterServerId = nb_DiskPool.masterServerId and domain_DiskPool.name = nb_DiskPool.name and domain_DiskPool.serverType = nb_DiskPool.serverType and domain_DiskPool.storageServerName = nb_DiskPool.storageServerName and domain_Client.masterServerId = domain_JobArchive.masterServerId and domain_Client.name = domain_JobArchive.clientName AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId and domain_JobArchive.clientName = domain_JobImage.clientName and domain_JobArchive.id = domain_JobImage.jobId AND domain_Image.masterServerId = domain_JobImage.masterServerId and domain_Image.id = domain_JobImage.imageId AND domain_Image.masterServerId = domain_ImageCopy.masterServerId and domain_Image.id = domain_ImageCopy.imageId AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId and domain_ImageCopy.imageId = domain_ImageFragment.imageId and domain_ImageCopy.id = domain_ImageFragment.copyId AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId and nb_DiskPool.name = nb_DiskVolume.diskPoolId and nb_DiskPool.serverType = nb_DiskVolume.serverType and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName AND nb_StorageServer.masterServerId = nb_DiskPool.masterServerId and nb_StorageServer.serverType = nb_DiskPool.serverType and nb_StorageServer.name = nb_DiskPool.storageServerName and domain_DiskPool.masterServerId = nb_DiskPool.masterServerId and domain_DiskPool.name = nb_DiskPool.name and domain_DiskPool.serverType = nb_DiskPool.serverType and domain_DiskPool.storageServerName = nb_DiskPool.storageServerName AND nb_StorageServer.masterServerId = nb_DiskPool.masterServerId and nb_StorageServer.serverType = nb_DiskPool.serverType and nb_StorageServer.name = nb_DiskPool.storageServerName and ( ( (domain_JobArchive.endTime BETWEEN '137340756000000000' AND '137367107990000000') ) AND ( (domain_DiskPool.isValid = '1') ) AND ( (domain_Client.isValid = '1') ) AND ( (domain_MediaServer.isValid = '1') ) AND ( (domain_MasterServer.valid = '1') ) AND ( (domain_Policy.isValid = '1') ) AND ( (domain_Schedule.isValid = '1') ) AND ( ( (domain_MasterServer.id IN (61,906039 )) ) ) )

Close

Open in new window

jskfanAsked:
Who is Participating?
 
Bill PrewCommented:
Try this:

select TOP 20 START AT 1 domain_MasterServer.id as "domain_MasterServer.id", domain_MediaServer.id as "domain_MediaServer.id", domain_Policy.name as "domain_Policy.name", domain_Policy.keyword as "domain_Policy.keyword", domain_Schedule.hasCalendarSched as "domain_Schedule.hasCalendarSched", domain_Schedule.frequency as "domain_Schedule.frequency", domain_Schedule.name as "domain_Schedule.name", domain_Schedule.numberOfCopies as "domain_Schedule.numberOfCopies", domain_Schedule.type as "domain_Schedule.type", nb_JobAttemptArchive.destStorageUnit as "nb_JobAttemptArchive.destStorageUnit", domain_Client.id as "domain_Client.id", domain_Client.osType as "domain_Client.osType", domain_DiskPool.name as "domain_DiskPool.name", nb_DiskVolume.name as "nb_DiskVolume.name", nb_StorageServer.name as "nb_StorageServer.name", domain_SLPImage.storageServiceName as "domain_SLPImage.storageServiceName" from domain_JobArchive, domain_DiskPool, domain_Client, domain_MediaServer, domain_MasterServer, domain_Policy, domain_Schedule, nb_JobAttemptArchive, nb_DiskVolume, nb_StorageServer, nb_JobArchive, nb_DiskPool, domain_ImageCopy, domain_ImageFragment, domain_JobImage, domain_Image, domain_ScheduledJob, domain_SLPImage where domain_MasterServer.id = domain_JobArchive.masterServerId  and domain_MasterServer.id = domain_DiskPool.masterServerId  and domain_MasterServer.id = domain_Client.masterServerId  and domain_MasterServer.id = domain_MediaServer.masterServerId  and domain_MasterServer.id = domain_Policy.masterServerId  and domain_MasterServer.id = domain_Policy.masterServerId  and domain_MasterServer.id = domain_SLPImage.masterServerId AND domain_Policy.masterServerId = domain_Schedule.masterServerId  and domain_Policy.name = domain_Schedule.policyName  and domain_Policy.policyDomainName = domain_Schedule.policyDomainName  and domain_Policy.versionNo = domain_Schedule.policyVersionNo  and domain_MasterServer.id = domain_JobArchive.masterServerId  AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId  and domain_JobArchive.clientName = nb_JobArchive.clientName  and domain_JobArchive.id = nb_JobArchive.id  AND nb_JobArchive.masterServerId = nb_JobAttemptArchive.masterserverId  and nb_JobArchive.clientName = nb_JobAttemptArchive.clientName  and nb_JobArchive.id = nb_JobAttemptArchive.jobId  and domain_MasterServer.id = nb_DiskPool.masterServerId  AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId  and nb_DiskPool.name = nb_DiskVolume.diskPoolId  and nb_DiskPool.serverType = nb_DiskVolume.serverType  and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName  and domain_MasterServer.id = nb_StorageServer.masterServerId  and domain_MediaServer.masterServerId = domain_JobArchive.masterServerId  and domain_MediaServer.name = domain_JobArchive.jobMediaServerName  and domain_DiskPool.masterServerId = nb_DiskPool.masterServerId  and domain_DiskPool.name = nb_DiskPool.name  and domain_DiskPool.serverType = nb_DiskPool.serverType  and domain_DiskPool.storageServerName = nb_DiskPool.storageServerName  AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId  and nb_DiskPool.name = nb_DiskVolume.diskPoolId  and nb_DiskPool.serverType = nb_DiskVolume.serverType  and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName  AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId  and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId  AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId  and domain_ImageCopy.imageId = domain_ImageFragment.imageId  and domain_ImageCopy.id = domain_ImageFragment.copyId  AND domain_MediaServer.masterServerId = domain_ImageCopy.masterServerId  and domain_MediaServer.name = domain_ImageCopy.mediaServerName  and domain_Client.masterServerId = domain_JobArchive.masterServerId  and domain_Client.name = domain_JobArchive.clientName  AND domain_MediaServer.masterServerId = domain_JobArchive.masterServerId  and domain_MediaServer.name = domain_JobArchive.jobMediaServerName  and domain_MediaServer.masterServerId = domain_JobArchive.masterServerId  and domain_MediaServer.name = domain_JobArchive.jobMediaServerName  AND domain_Policy.masterServerId = domain_JobArchive.masterServerId  and domain_Policy.name = domain_JobArchive.policyName  and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName  and domain_Policy.versionNo = domain_JobArchive.policyVersionNo  and domain_MediaServer.masterServerId = domain_JobArchive.masterServerId  and domain_MediaServer.name = domain_JobArchive.jobMediaServerName  AND domain_Schedule.masterServerId = domain_JobArchive.masterServerId  and domain_Schedule.policyName = domain_JobArchive.policyName  and domain_Schedule.policyDomainName = domain_JobArchive.policyDomainName  and domain_Schedule.policyVersionNo = domain_JobArchive.policyVersionNo  and domain_Schedule.name = domain_JobArchive.scheduleName  and domain_MediaServer.masterServerId = nb_JobAttemptArchive.masterserverId  and domain_MediaServer.masterServerId = nb_JobAttemptArchive.masterserverId  and  ( domain_MediaServer.name = nb_JobAttemptArchive.srcMediaServerName  OR domain_MediaServer.name = nb_JobAttemptArchive.destMediaServerName  ) and domain_MediaServer.masterServerId = domain_ImageCopy.masterServerId  and domain_MediaServer.name = domain_ImageCopy.mediaServerName  AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId  and domain_ImageCopy.imageId = domain_ImageFragment.imageId  and domain_ImageCopy.id = domain_ImageFragment.copyId  AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId  and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId  and domain_MediaServer.masterServerId = domain_ImageCopy.masterServerId  and domain_MediaServer.name = domain_ImageCopy.mediaServerName  AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId  and domain_ImageCopy.imageId = domain_ImageFragment.imageId  and domain_ImageCopy.id = domain_ImageFragment.copyId  AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId  and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId  AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId  and nb_DiskPool.name = nb_DiskVolume.diskPoolId  and nb_DiskPool.serverType = nb_DiskVolume.serverType  and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName  AND nb_StorageServer.masterServerId = nb_DiskPool.masterServerId  and nb_StorageServer.serverType = nb_DiskPool.serverType  and nb_StorageServer.name = nb_DiskPool.storageServerName  and domain_DiskPool.masterServerId = nb_DiskPool.masterServerId  and domain_DiskPool.name = nb_DiskPool.name  and domain_DiskPool.serverType = nb_DiskPool.serverType  and domain_DiskPool.storageServerName = nb_DiskPool.storageServerName  AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId  and nb_DiskPool.name = nb_DiskVolume.diskPoolId  and nb_DiskPool.serverType = nb_DiskVolume.serverType  and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName  AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId  and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId  AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId  and domain_ImageCopy.imageId = domain_ImageFragment.imageId  and domain_ImageCopy.id = domain_ImageFragment.copyId  AND domain_Image.masterServerId = domain_ImageCopy.masterServerId  and domain_Image.id = domain_ImageCopy.imageId  AND domain_Image.masterServerId = domain_JobImage.masterServerId  and domain_Image.id = domain_JobImage.imageId  AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId  and domain_JobArchive.clientName = domain_JobImage.clientName  and domain_JobArchive.id = domain_JobImage.jobId  AND domain_Policy.masterServerId = domain_JobArchive.masterServerId  and domain_Policy.name = domain_JobArchive.policyName  and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName  and domain_Policy.versionNo = domain_JobArchive.policyVersionNo  and domain_Client.masterServerId = domain_JobArchive.masterServerId  and domain_Client.name = domain_JobArchive.clientName  AND domain_Policy.masterServerId = domain_JobArchive.masterServerId  and domain_Policy.name = domain_JobArchive.policyName  and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName  and domain_Policy.versionNo = domain_JobArchive.policyVersionNo  and domain_Policy.masterServerId = domain_JobArchive.masterServerId  and domain_Policy.name = domain_JobArchive.policyName  and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName  and domain_Policy.versionNo = domain_JobArchive.policyVersionNo  AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId  and domain_JobArchive.clientName = nb_JobArchive.clientName  and domain_JobArchive.id = nb_JobArchive.id  AND nb_JobArchive.masterServerId = nb_JobAttemptArchive.masterserverId  and nb_JobArchive.clientName = nb_JobAttemptArchive.clientName  and nb_JobArchive.id = nb_JobAttemptArchive.jobId  and domain_Policy.masterServerId = domain_JobArchive.masterServerId  and domain_Policy.name = domain_JobArchive.policyName  and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName  and domain_Policy.versionNo = domain_JobArchive.policyVersionNo  AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId  and domain_JobArchive.clientName = domain_JobImage.clientName  and domain_JobArchive.id = domain_JobImage.jobId  AND domain_Image.masterServerId = domain_JobImage.masterServerId  and domain_Image.id = domain_JobImage.imageId  AND domain_Image.masterServerId = domain_ImageCopy.masterServerId  and domain_Image.id = domain_ImageCopy.imageId  AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId  and domain_ImageCopy.imageId = domain_ImageFragment.imageId  and domain_ImageCopy.id = domain_ImageFragment.copyId  AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId  and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId  and domain_Policy.masterServerId = domain_JobArchive.masterServerId  and domain_Policy.name = domain_JobArchive.policyName  and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName  and domain_Policy.versionNo = domain_JobArchive.policyVersionNo  AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId  and domain_JobArchive.clientName = domain_JobImage.clientName  and domain_JobArchive.id = domain_JobImage.jobId  AND domain_Image.masterServerId = domain_JobImage.masterServerId  and domain_Image.id = domain_JobImage.imageId  AND domain_Image.masterServerId = domain_ImageCopy.masterServerId  and domain_Image.id = domain_ImageCopy.imageId  AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId  and domain_ImageCopy.imageId = domain_ImageFragment.imageId  and domain_ImageCopy.id = domain_ImageFragment.copyId  AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId  and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId  AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId  and nb_DiskPool.name = nb_DiskVolume.diskPoolId  and nb_DiskPool.serverType = nb_DiskVolume.serverType  and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName  AND nb_StorageServer.masterServerId = nb_DiskPool.masterServerId  and nb_StorageServer.serverType = nb_DiskPool.serverType  and nb_StorageServer.name = nb_DiskPool.storageServerName  and domain_DiskPool.masterServerId = nb_DiskPool.masterServerId  and domain_DiskPool.name = nb_DiskPool.name  and domain_DiskPool.serverType = nb_DiskPool.serverType  and domain_DiskPool.storageServerName = nb_DiskPool.storageServerName  AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId  and nb_DiskPool.name = nb_DiskVolume.diskPoolId  and nb_DiskPool.serverType = nb_DiskVolume.serverType  and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName  AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId  and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId  AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId  and domain_ImageCopy.imageId = domain_ImageFragment.imageId  and domain_ImageCopy.id = domain_ImageFragment.copyId  AND domain_Image.masterServerId = domain_ImageCopy.masterServerId  and domain_Image.id = domain_ImageCopy.imageId  AND domain_Image.masterServerId = domain_JobImage.masterServerId  and domain_Image.id = domain_JobImage.imageId  AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId  and domain_JobArchive.clientName = domain_JobImage.clientName  and domain_JobArchive.id = domain_JobImage.jobId  AND domain_Schedule.masterServerId = domain_JobArchive.masterServerId  and domain_Schedule.policyName = domain_JobArchive.policyName  and domain_Schedule.policyDomainName = domain_JobArchive.policyDomainName  and domain_Schedule.policyVersionNo = domain_JobArchive.policyVersionNo  and domain_Schedule.name = domain_JobArchive.scheduleName  and domain_Client.masterServerId = domain_ScheduledJob.masterServerId  and domain_Client.name = domain_ScheduledJob.clientName  AND domain_Schedule.masterServerId = domain_ScheduledJob.masterServerId  and domain_Schedule.policyName = domain_ScheduledJob.policyName  and domain_Schedule.policyDomainName = domain_ScheduledJob.policyDomainName  and domain_Schedule.policyVersionNo = domain_ScheduledJob.policyVersionNo  and domain_Schedule.name = domain_ScheduledJob.scheduleName  and domain_Schedule.masterServerId = domain_JobArchive.masterServerId  and domain_Schedule.policyName = domain_JobArchive.policyName  and domain_Schedule.policyDomainName = domain_JobArchive.policyDomainName  and domain_Schedule.policyVersionNo = domain_JobArchive.policyVersionNo  and domain_Schedule.name = domain_JobArchive.scheduleName  AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId  and domain_JobArchive.clientName = nb_JobArchive.clientName  and domain_JobArchive.id = nb_JobArchive.id  AND nb_JobArchive.masterServerId = nb_JobAttemptArchive.masterserverId  and nb_JobArchive.clientName = nb_JobAttemptArchive.clientName  and nb_JobArchive.id = nb_JobAttemptArchive.jobId  and domain_Schedule.masterServerId = domain_JobArchive.masterServerId  and domain_Schedule.policyName = domain_JobArchive.policyName  and domain_Schedule.policyDomainName = domain_JobArchive.policyDomainName  and domain_Schedule.policyVersionNo = domain_JobArchive.policyVersionNo  and domain_Schedule.name = domain_JobArchive.scheduleName  AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId  and domain_JobArchive.clientName = domain_JobImage.clientName  and domain_JobArchive.id = domain_JobImage.jobId  AND domain_Image.masterServerId = domain_JobImage.masterServerId  and domain_Image.id = domain_JobImage.imageId  AND domain_Image.masterServerId = domain_ImageCopy.masterServerId  and domain_Image.id = domain_ImageCopy.imageId  AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId  and domain_ImageCopy.imageId = domain_ImageFragment.imageId  and domain_ImageCopy.id = domain_ImageFragment.copyId  AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId  and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId  and domain_Schedule.masterServerId = domain_JobArchive.masterServerId  and domain_Schedule.policyName = domain_JobArchive.policyName  and domain_Schedule.policyDomainName = domain_JobArchive.policyDomainName  and domain_Schedule.policyVersionNo = domain_JobArchive.policyVersionNo  and domain_Schedule.name = domain_JobArchive.scheduleName  AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId  and domain_JobArchive.clientName = domain_JobImage.clientName  and domain_JobArchive.id = domain_JobImage.jobId  AND domain_Image.masterServerId = domain_JobImage.masterServerId  and domain_Image.id = domain_JobImage.imageId  AND domain_Image.masterServerId = domain_ImageCopy.masterServerId  and domain_Image.id = domain_ImageCopy.imageId  AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId  and domain_ImageCopy.imageId = domain_ImageFragment.imageId  and domain_ImageCopy.id = domain_ImageFragment.copyId  AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId  and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId  AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId  and nb_DiskPool.name = nb_DiskVolume.diskPoolId  and nb_DiskPool.serverType = nb_DiskVolume.serverType  and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName  AND nb_StorageServer.masterServerId = nb_DiskPool.masterServerId  and nb_StorageServer.serverType = nb_DiskPool.serverType  and nb_StorageServer.name = nb_DiskPool.storageServerName  and domain_DiskPool.masterServerId = nb_DiskPool.masterServerId  and domain_DiskPool.name = nb_DiskPool.name  and domain_DiskPool.serverType = nb_DiskPool.serverType  and domain_DiskPool.storageServerName = nb_DiskPool.storageServerName  AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId  and nb_DiskPool.name = nb_DiskVolume.diskPoolId  and nb_DiskPool.serverType = nb_DiskVolume.serverType  and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName  AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId  and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId  AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId  and domain_ImageCopy.imageId = domain_ImageFragment.imageId  and domain_ImageCopy.id = domain_ImageFragment.copyId  AND domain_Image.masterServerId = domain_ImageCopy.masterServerId  and domain_Image.id = domain_ImageCopy.imageId  AND domain_Image.masterServerId = domain_JobImage.masterServerId  and domain_Image.id = domain_JobImage.imageId  AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId  and domain_JobArchive.clientName = domain_JobImage.clientName  and domain_JobArchive.id = domain_JobImage.jobId  AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId  and domain_JobArchive.clientName = nb_JobArchive.clientName  and domain_JobArchive.id = nb_JobArchive.id  AND nb_JobArchive.masterServerId = nb_JobAttemptArchive.masterserverId  and nb_JobArchive.clientName = nb_JobAttemptArchive.clientName  and nb_JobArchive.id = nb_JobAttemptArchive.jobId  and domain_Client.masterServerId = domain_JobArchive.masterServerId  and domain_Client.name = domain_JobArchive.clientName  AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId  and domain_JobArchive.clientName = nb_JobArchive.clientName  and domain_JobArchive.id = nb_JobArchive.id  AND nb_JobArchive.masterServerId = nb_JobAttemptArchive.masterserverId  and nb_JobArchive.clientName = nb_JobAttemptArchive.clientName  and nb_JobArchive.id = nb_JobAttemptArchive.jobId  and nb_JobArchive.masterServerId = nb_JobAttemptArchive.masterserverId  and nb_JobArchive.clientName = nb_JobAttemptArchive.clientName  and nb_JobArchive.id = nb_JobAttemptArchive.jobId  AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId  and domain_JobArchive.clientName = nb_JobArchive.clientName  and domain_JobArchive.id = nb_JobArchive.id  AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId  and domain_JobArchive.clientName = domain_JobImage.clientName  and domain_JobArchive.id = domain_JobImage.jobId  AND domain_Image.masterServerId = domain_JobImage.masterServerId  and domain_Image.id = domain_JobImage.imageId  AND domain_Image.masterServerId = domain_ImageCopy.masterServerId  and domain_Image.id = domain_ImageCopy.imageId  AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId  and domain_ImageCopy.imageId = domain_ImageFragment.imageId  and domain_ImageCopy.id = domain_ImageFragment.copyId  AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId  and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId  AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId  and nb_DiskPool.name = nb_DiskVolume.diskPoolId  and nb_DiskPool.serverType = nb_DiskVolume.serverType  and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName  AND nb_StorageServer.masterServerId = nb_DiskPool.masterServerId  and nb_StorageServer.serverType = nb_DiskPool.serverType  and nb_StorageServer.name = nb_DiskPool.storageServerName  and domain_Client.masterServerId = domain_JobArchive.masterServerId  and domain_Client.name = domain_JobArchive.clientName  AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId  and domain_JobArchive.clientName = domain_JobImage.clientName  and domain_JobArchive.id = domain_JobImage.jobId  AND domain_Image.masterServerId = domain_JobImage.masterServerId  and domain_Image.id = domain_JobImage.imageId  AND domain_Image.masterServerId = domain_ImageCopy.masterServerId  and domain_Image.id = domain_ImageCopy.imageId  AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId  and domain_ImageCopy.imageId = domain_ImageFragment.imageId  and domain_ImageCopy.id = domain_ImageFragment.copyId  AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId  and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId  AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId  and nb_DiskPool.name = nb_DiskVolume.diskPoolId  and nb_DiskPool.serverType = nb_DiskVolume.serverType  and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName  AND domain_DiskPool.masterServerId = nb_DiskPool.masterServerId  and domain_DiskPool.name = nb_DiskPool.name  and domain_DiskPool.serverType = nb_DiskPool.serverType  and domain_DiskPool.storageServerName = nb_DiskPool.storageServerName  and domain_Client.masterServerId = domain_JobArchive.masterServerId  and domain_Client.name = domain_JobArchive.clientName  AND domain_JobArchive.masterServerId = domain_JobImage.masterServerId  and domain_JobArchive.clientName = domain_JobImage.clientName  and domain_JobArchive.id = domain_JobImage.jobId  AND domain_Image.masterServerId = domain_JobImage.masterServerId  and domain_Image.id = domain_JobImage.imageId  AND domain_Image.masterServerId = domain_ImageCopy.masterServerId  and domain_Image.id = domain_ImageCopy.imageId  AND domain_ImageCopy.masterServerId = domain_ImageFragment.masterServerId  and domain_ImageCopy.imageId = domain_ImageFragment.imageId  and domain_ImageCopy.id = domain_ImageFragment.copyId  AND nb_DiskVolume.masterServerId = domain_ImageFragment.masterServerId  and nb_DiskVolume.diskMediaId = domain_ImageFragment.diskMediaId  AND nb_DiskPool.masterServerId = nb_DiskVolume.masterServerId  and nb_DiskPool.name = nb_DiskVolume.diskPoolId  and nb_DiskPool.serverType = nb_DiskVolume.serverType  and nb_DiskPool.storageServerName = nb_DiskVolume.storageServerName  AND nb_StorageServer.masterServerId = nb_DiskPool.masterServerId  and nb_StorageServer.serverType = nb_DiskPool.serverType  and nb_StorageServer.name = nb_DiskPool.storageServerName  and domain_DiskPool.masterServerId = nb_DiskPool.masterServerId  and domain_DiskPool.name = nb_DiskPool.name  and domain_DiskPool.serverType = nb_DiskPool.serverType  and domain_DiskPool.storageServerName = nb_DiskPool.storageServerName  AND nb_StorageServer.masterServerId = nb_DiskPool.masterServerId  and nb_StorageServer.serverType = nb_DiskPool.serverType  and nb_StorageServer.name = nb_DiskPool.storageServerName  and  ( ( (domain_JobArchive.endTime BETWEEN '137340756000000000' AND '137367107990000000') )  AND  ( (domain_DiskPool.isValid = '1')  ) AND  ( (domain_Client.isValid = '1')  ) AND  ( (domain_MediaServer.isValid = '1')  ) AND  ( (domain_MasterServer.valid = '1')  ) AND  ( (domain_Policy.isValid = '1')  ) AND  ( (domain_Schedule.isValid = '1')  ) AND  ( ( (domain_MasterServer.id IN  ( 61, 906039  ) ) )  ) ) 

Open in new window


»bp
0
 
dovidfCEOCommented:
select TOP 20 START AT 1 domain_MasterServer.id as "domain_MasterServer.id",domain_MediaServer.id as "domain_MediaServe, domain_SLPImage.storageServiceName where domain_MasterServer.id  = domain_SLPImage.masterServerId

should work
0
 
jskfanAuthor Commented:
Thank you
0
 
Bill PrewCommented:
Welcome.


»bp
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.