Skip to main content

Prisma Cloud Remediation - Azure SQL Misconfiguration

This playbook remediates Prisma Cloud Azure SQL alerts. It calls sub-playbooks that perform the actual remediation steps.

Remediation:

  • Azure SQL database auditing is disabled
  • Azure SQL Database with Auditing Retention less than 90 days
  • Azure Threat Detection on SQL databases is set to Off
  • Azure SQL Database with Threat Retention less than or equals to 90 days

Dependencies#

This playbook uses the following sub-playbooks, integrations, and scripts.

Sub-playbooks#

  • Prisma Cloud Remediation - Azure SQL Database Misconfiguration

Integrations#

  • RedLock

Scripts#

  • IsIntegrationAvailable

Commands#

  • redlock-dismiss-alerts
  • closeInvestigation

Playbook Inputs#


NameDescriptionDefault ValueRequired
AutoRemediateAzureSQLExecute Azure SQL remediation automatically?noOptional
policyIdGrab the Prisma Cloud policy Id.incident.labels.policyOptional

Playbook Outputs#


There are no outputs for this playbook.

Playbook Image#


Prisma Cloud Remediation - Azure SQL Misconfiguration