I'm writing query to a develop a list of programs used for production. Then use that list to check if they exist in a file directory. If not, trigger an email notification.
There are a few ways that I can think of, I'll leave you to Google up some tutorials as there are plenty out there:
I'd say SSIS as I assume (doh!) that you're already running packages in your estate.
20 People are following this question.