How can I create an alert (with email subscription) when content fails to validate on a distribution point or distribution po

Not with the buildin alerting. You should be able to trigger a custom action based on specific status messages. For a list with status messages see: http://eskonr.com/2013/01/sccm-configmgr-2012-distribution-content-status-message-ids-and-state-message-ids/

AJM

Did you come up with a solution for this? We are using SCOM to monitor the SMSDPMON.log on our DP's for a string of "Failed to evaluate package".

Also, I have built a custom SQL report to query the SCCM database for this information and it is sent to me once a week, the day after content validation runs on the DP's. Below is the SQL code I am using, use it to build your own custom SCCM report. 

select LastUpdateDate, MessageID,vSMS_DistributionDPStatus.PackageID,v_package.Name as PackageName, vSMS_DistributionDPStatus.Name as DistributionPoint

from vSMS_DistributionDPStatus,v_package

Where vSMS_DistributionDPStatus.PackageID = v_package.PackageID and MessageID = 9517

-Tony

• Proposed as answer by Tony Chirillo 16 hours 6 minutes ago
• Edited by Tony Chirillo 16 hours 3 minutes ago