Matthew Warren
12/15/2022, 4:12 PM1
to determine failure/pass respectively?Michal Nicpon
12/15/2022, 4:14 PMselect 1 …
in policy queries because we don’t care about the actual columns being returnedMatthew Warren
12/15/2022, 4:30 PMWITH expected_policies(DOMAIN, name, value) AS (
VALUES ('com.apple.applicationaccess',
'allowCloudDocumentSync',
'0'))
SELECT expected_policies.*,
CASE
WHEN managed_policies.domain IS NOT NULL THEN 'OK'
ELSE NULL
END complaince_check
FROM expected_policies
LEFT JOIN managed_policies ON (managed_policies.domain = expected_policies.domain
AND managed_policies.name = expected_policies.name
AND managed_policies.value = expected_policies.value)
ORDER BY expected_policies.domain,
expected_policies.name;
INNER JOIN
forces a null result as expected here. Does that look like the correct solution @Michal Nicpon or @Lucas Rodriguez?Michal Nicpon
12/16/2022, 1:12 PMINNER JOIN
, otherwise you will always return at least 1 row from the expected_policies
CTE.
However, I think you could simplify the query to the following
SELECT
1
FROM
managed_policies
WHERE
domain = 'com.apple.applicationaccess'
AND name = 'allowCloudDocumentSync'
AND value = '0';