Prisma Cloud Remediation - Azure SQL Misconfiguration v2

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

Prisma Cloud by Palo Alto Networks · 12 tasks · 2 inputs · 0 outputs

Inputs

  • policyId — Grab the Prisma Cloud policy ID.
  • AutoRemediateAzureSQL — Execute Azure SQL remediation automatically?

Commands used

closeInvestigation prisma-cloud-alert-dismiss

Flowchart

yes yes yes Yes database yes Start Start Is Azure SQL Management integration enabled? - IsIntegrationAvailable Is Azure SQL Management i... IsIntegrationAvailable Done Done Is there a policy to remediate? Is there a policy to reme... Update SQL automatically? Update SQL automatically? Auto remediate? Auto remediate? Execute playbook Execute playbook Manually update SQL Manually update SQL Close investigation - closeInvestigation Close investigation closeInvestigation Is Prisma Cloud v2 integration enabled? Is Prisma Cloud v2 integr... Dismiss Prisma Cloud alert - prisma-cloud-alert-dismiss Dismiss Prisma Cloud alert prisma-cloud-alert-dismiss Prisma Cloud Remediation - Azure SQL Database Misconfiguration - Prisma Cloud Remediation - Azure SQL Database Misconfiguration Prisma Cloud Remediation ... Prisma Cloud Remediation - Az...