01-03-2019 12:05 PM
Can somenone please help me filter this sql query by a particular master/domain ?
SELECT
domain_PolicyClient.clientName as "Client Name",
domain_PolicyClient.policyName as "Policy Name",
lookup_PolicyType.name as "Policy Type",
nb_Policy.fileList as "Backup Selection"
FROM
domain_PolicyClient, domain_Client,lookup_PolicyType, domain_Policy, nb_Policy
WHERE
lookup_PolicyType.id = domain_Policy.type AND
domain_PolicyClient.clientName = domain_Client.name AND
domain_PolicyClient.masterServerId = domain_Client.masterServerId AND
domain_PolicyClient.policyName = domain_Policy.name AND
domain_PolicyClient.masterServerId = domain_Policy.masterServerId AND
domain_PolicyClient.policyDomainName = domain_Policy.policyDomainName AND
domain_PolicyClient.policyVersionNo= domain_Policy.versionNo AND
domain_Policy.name = nb_Policy.name AND
domain_Policy.masterServerId = nb_Policy.masterServerId AND
domain_Policy.versionNo = nb_Policy.versionNo AND
domain_Policy.policyDomainName = nb_Policy.policyDomainName AND
domain_Policy.status = 0 AND
domain_Policy.active = 1 AND
lookup_PolicyType.name LIKE 'MS%'
-- domain_Policy.name LIKE '%PR%'
-- domain_PolicyClient.clientName LIKE '%winprd%'
ORDER BY domain_PolicyClient.clientName