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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Bill PrewIT / Software Engineering ConsultantCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jskfanAuthor Commented:
Thank you
0
Bill PrewIT / Software Engineering ConsultantCommented:
Welcome.


»bp
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.