search

chainguard-dev / rumble

Data collection for base image CVEs etc.
Apache License 2.0
4 stars 8 forks source link

[Feature] Alerts on New Reported CVEs #17

Closed jspeed-meyers closed 1 year ago

jspeed-meyers commented 1 year ago

cc @jdolitsky, @imjasonh

jspeed-meyers commented 1 year ago

Maybe this would result in opening a GitHub issue?

jspeed-meyers commented 1 year ago

Helpful information from @afeddersen:

Just an idea, but BigQuery has an ERROR function that can be thrown if the query returns data that doesn’t match your condition. https://cloud.google.com/bigquery/docs/reference/standard-sql/debugging_functions So maybe if there was a column for CVE count that was > 0 it would throw an error. If the error is thrown your scheduled query will fail and it will automatically email you or a list.

jspeed-meyers commented 1 year ago

Another helpful link from Anthony: https://towardsdatascience.com/slack-alerts-from-a-sql-query-on-bigquery-f626b767304c