Disable the email if there are no failing checks

[RichardNorton]

Is it possible to have the email not sent if there are no failing checks as we only care if there are failed checks.

---

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

• ID: 9b890467-2154-bff9-05e1-816013515030
• Version Independent ID: 2195ebb4-3ac8-5112-c331-528bd9b91e9e
• Content: SQL vulnerability assessment - Azure SQL Database & SQL Managed Instance & Azure Synapse Analytics
• Content Source: azure-sql/database/sql-vulnerability-assessment.md
• Service: sql-db-mi
• Sub-service: security
• GitHub Login: @CESANU
• Microsoft Alias: cesanu

[GeethaThatipatri-MSFT]

@RichardNorton Thank you for reaching out. We will look into it and update you as appropriate.

[CESANU]

Hi @RichardNorton, Thanks for reaching out.

The built-in email mechanism available in VA with classic configuration does not allow this type of configuration and there are currently no plans to add this ability. What you could do is customize your own email notifications with custom logic using LogicApps.

Here's an example template: https://github.com/Azure/Microsoft-Defender-for-Cloud/tree/main/Workflow%20automation/Notify-SQLVulnerabilityReport

You could add a condition that'll send an email only if there are unhealthy findings.

Hope this helps.

Regards, Catalin

[MashaMSFT]

Hi @RichardNorton , thanks for contacting Microsoft! Looks like Catalin was able to address your question so I'll go ahead and close out this Git Issue but please feel free to comment should you need anything further.

Thanks again for reaching out and I hope you have a wonderful rest of your day! Masha from the SQL Docs team

please-close