Post reply

Create alert in CMS

  • March 4, 2012 at 11:38 pm

    #257828

    I want to create alert for policy evaluation failure in Central Management Server. I google'd it but didnt fount any relevant material to refer.

    Anyone implemented ???

    Sagar Sonawane
    ** Every DBA has his day!!:cool:

  • March 5, 2012 at 12:52 am

    #1454659

    EXEC msdb.dbo.sp_send_dbmail

    @profile_name ='SAGAR',

    @recipients=N'ssonawane@systime.net',

    @subject ='Policy Alert',

    @query='SELECT TOP 100 [EvaluatedServer]

    ,[EvaluatedPolicy]

    ,[EvaluatedObject]

    ,[PolicyResult]

    FROM [ManagementDatabase].[policy].[PolicyHistoryDetail] where [PolicyResult]= ''FAIL'' ',

    @query_result_separator='||' ,

    @query_result_no_padding=1;

    I have created this script this script will fetch Failed policies from given centralised database where all policy evaluation data is stored by a powershell script.

    There is one job scheduled which automatically evaluates policies against Central management Server.

    I want to update user through the mail as my job will be evaluated. But I want results after job evaluation. please help

    Sagar Sonawane
    ** Every DBA has his day!!:cool:

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply