Everyday we get some copies of the production database for our development environment. The name of the copy is the type of backup + timestamp. (example: PRD_backup_201010042130.DBB) This means that the name of the file is/should be changing every day. Because the backup copy action sometimes fails, I would like to monitor the file, so I can sent an alarm notification to the dba if the copy fails and it would be nice to collect some statistics to see how often it goes wrong. The problem is that I don't know how to monitor a file with a changing name. Is it possible to use wildcards in some way? Is there a custom sensor that allows me to monitor files with changing names or could someone help me with a wmi script if that is even possible?
Thanks in advance!