This condition evaluates to True when it finds databases with stored procedures that have been created with the past hour.
The results returned are number of procedures in a database that meet the condition (Value) and the name of the database that has the created procedures (Key).
If the condition evaluates to True, run the following query against the database(s) in the result set to get a list of all procedures created today:
SELECT schema_name(schema_id), [name], create_date
FROM sys.procedures
WHERE create_date >= (SELECT CONVERT(DATE,GETDATE()))
ORDER BY create_date DESC;
An Execute SQL action can also be used to automatically email a list to you. See the sentryone-samples repo on GitHub for a sample you can use.
See Also:
https://docs.sentryone.com/help/github-advisory-conditions