2008R2 Policy Based Management

• Loundy

  SSCertifiable

  Points: 6080

  More actions

  January 26, 2012 at 4:21 am

  #255557

  Hi All,

  Can anyone tell me if its possible to do the following when setting a condition in Policy Based Management. It's not letting me do it...

  Facet:

  Database

  Expression:

  Field = @LastBackupDate

  Operator >=

  Value = CONVERT(CHAR(11),GETDATE(),120)

  I basically want to see if the last backupdate is greater or equal to the current day without specifying a time.

  Cheers,

  Chris

  [font="Times New Roman"]There's no kill switch on awesome![/font]

• Loundy

  SSCertifiable

  Points: 6080

  More actions

  January 26, 2012 at 5:33 am

  #1438699

  I've managed to come up with 1 solution:

  ExecuteSql('DATETIME', 'SELECT CONVERT(CHAR(11),GETDATE(),120)')

  this will give the expected result. if anyone can come up with a better way to do this I'm all ears 🙂

  [font="Times New Roman"]There's no kill switch on awesome![/font]