Policy History Detail

Oct 3, 2009 at 5:22 AM

I have setup the V3 EPMF . I ran the powershell script and it populated the data in  "policy.PolicyHistory" table . however in the document you have mentioned  the following views to verify the data .

SELECT * FROM policy.v_PolicyHistory

View sourcecode

SELECT PH.PolicyHistoryID
  , PH.EvaluatedServer
  , PH.EvaluationDateTime
  , PH.EvaluatedPolicy
  , PH.PolicyResult
  , PH.ExceptionMessage
  , PH.ResultDetail
  , PH.EvaluatedObject
  , PH.policy_id
  , PH.CategoryName
  , PH.MonthYear
 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?

Coordinator
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.