• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 59 subscribers
  • Views 3848 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Days Since Last Backup - RegEx Exception

cbaker
over 6 years ago

 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

  • 0 over 6 years ago

    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

  • 0 over 6 years ago
    Thank you John, sorry for the delayed reply I had filtering on my email.