I have setup the V3 EPMF . I ran the powershell script and it populated the data in
table . however in the document you have mentioned the following views to verify the data .
SELECT * FROM policy.v_PolicyHistory
FROM policy.PolicyHistoryDetail PH
INNER JOIN msdb.dbo.syspolicy_policies AS p ON p.name = PH.EvaluatedPolicy
INNER JOIN msdb.dbo.syspolicy_policy_categories AS c ON
p.policy_category_id = c.policy_category_id
I see 1 issues ,not sure they are issues or i am seeing them worngly
If you dont setup any policy catagory this view will not return any results.
Could you please help me to understand this?
Oct 4, 2009 at 12:36 AM
Hello wonderingdba. Good catch! You are not seeing it wrong. This issue was presented to me after the last release, and I will be fixing the join in the next release. In the meantime, you can update the views to a left join.