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
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
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