SQLcm Alert help

by Aug 28, 2019

I would like to generate an alert in SQL Compliance Manager if someone attempts to login with a login that doesn't exist in SQL Server.   Does anyone have a simple way to do that?   I was originally trying to set one up under SQL Agent Alerts triggering on Message Text "Could not find a login matching" but I can't get it to fire.   So I decided to try using SQL CM.   

Thanks