jskfan
asked on
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome.
»bp
»bp
ASKER