Days Since Last Backup - RegEx Exception

 how do i write a Days Since Last Backup Exception for database names with a pattern such as DW_ARCHIVE_20170501_To_20170531 where DW_ARCHIVE has the  date pattern like "_20170501_To_20170531" then do not alert

  • Hi Cbaker,

    It is difficult to determine the specific criteria that you are requesting in a regular expression based on the prefix and date range you indicated.

    Very simple matching expressions can be made using .*

    For example,
    DW_ARCHIVE_.*
    would match all strings beginning with DW_ARCHIVE_

    I have found that using an online Regex tester, such as https://regex101.com/ is effective at helping to create and troubleshoot regular expressions.

    John

  • In reply to John.Sakalauskas:

    Thank you John, sorry for the delayed reply I had filtering on my email.