Notify-SQLVulnerabilityReport sends an email for every database #704
writeconrad
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Looking to use Notify-SQLVulnerabilityReport and was getting a summarized email for each database rather than the Azure SQL server in my test.
I found that the resource graph query in the Get SQL Servers action was returning a summarized row for each database in the server. I resolved it by using the tolower() function on the extend columns resourceId, resourceName and type.
There may be a better solution....
Beta Was this translation helpful? Give feedback.
All reactions