Policy History Detail

Oct 3, 2009 at 6: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 1: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.