🔌 Azure SQL Database - object.extracts.yaml

• Contextual name: 🔌 object.extracts.yaml
• ID: /types/CA10__CaAzureSqlDatabase__c/object.extracts.yaml

Used In

Logic	Policy	Flags
🧠 prod.logic.yaml🟢	🛡️ Azure SQL Database is located in a less cost-effective region🟢	🟢 x3
🧠 prod.logic.yaml🟢	🛡️ Azure SQL Database is underutilized🟢	🟢 x3
🧠 prod.logic.yaml🟢	🛡️ Azure SQL Database Transparent Data Encryption is not enabled🟢	🟢 x3

Content

Open File

---
extracts:
# Not Nullable. Can't have no access, retrieved via Microsoft.Sql/servers/databases/read
  - name: "CA10__name__c"
    value: 
      FIELD:
        path: "CA10__name__c"
        undeterminedIf:
          isEmpty: "Corrupted Data. Database Name cannot be empty."
# Not Nullable. Can't have no access, retrieved via Microsoft.Sql/servers/databases/read
  - name: "CA10__kind__c"
    value: 
      FIELD:
        path: "CA10__kind__c"
        undeterminedIf:
          isEmpty: "Corrupted Data. Database Kind cannot be empty."
# Values: Enabled, Disabled. Not Nullable. 
  - name: "CA10__dataEncryption__c"
    value: 
      FIELD:
        path: "CA10__dataEncryption__c"
        undeterminedIf:
          noAccessDelegate:
            path: "CA10__dataEncryption__c"
            currentStateMessage: "Unable to determine Transparent Data Encryption. Possible permission issue with Microsoft.Sql/servers/databases/transparentDataEncryption/read."
          isEmpty: "SQL Database Transparent Data Encryption is not populated yet."
# Not nullable 
  - name: "CA10__satus__c"
    value: 
      FIELD:
        path: "CA10__satus__c"
# Nullable 
  - name: "CA10__monitorCpuPercentAvg30Day__c"
    value: 
      FIELD:
        path: "CA10__monitorCpuPercentAvg30Day__c"
# Nullable 
  - name: "CA10__monitorStoragePercentMax30Day__c"
    value: 
      FIELD:
        path: "CA10__monitorStoragePercentMax30Day__c"
# Nullable 
  - name: "CA10__monitorDtuConsumptionPercentAvg30Day__c"
    value: 
      FIELD:
        path: "CA10__monitorDtuConsumptionPercentAvg30Day__c"
# Nullable 
  - name: "CA10__monitorAppMemoryPercentAvg30Day__c"
    value: 
      FIELD:
        path: "CA10__monitorAppMemoryPercentAvg30Day__c"
# Not Nullable 
  - name: "CA10__creationDate__c"
    value: 
      FIELD:
        path: "CA10__creationDate__c"
# Nullable 
  - name: "CA10__pausedDate__c"
    value: 
      FIELD:
        path: "CA10__pausedDate__c"
# Not Nullable 
  - name: "CA10__skuName__c"
    value: 
      FIELD:
        path: "CA10__skuName__c"
# Text. Not Nullable 
  - name: "CA10__locationName__c"
    value: 
      FIELD:
        path: "CA10__locationName__c"