🧠 Azure SQL Database is underutilized - prod.logic.yaml🟢
- Contextual name: 🧠 prod.logic.yaml🟢
- ID:
/ce/ca/azure/sql-database/database-underutilized/prod.logic.yaml - Tags:
Uses
Test Results 🟢
Generated at: 2026-02-10T22:33:36.037434101Z Open
| Result | Id | Condition Index | Condition Text | Runtime Error |
|---|---|---|---|---|
| 🟢 | test1 | ✔️ 99 | ✔️ isDisappeared(CA10__disappearanceTime__c) | ✔️ null |
| 🟢 | test2 | ✔️ 399 | ✔️ extract('CA10__kind__c').contains('system') | ✔️ null |
| 🟢 | test3 | ✔️ 499 | ✔️ extract('CA10__satus__c') != 'Online' | ✔️ null |
| 🟢 | test4 | ✔️ 599 | ✔️ extract('CA10__creationDate__c').withinLastDays(30) | ✔️ null |
| 🟢 | test5 | ✔️ 699 | ✔️ extract('CA10__pausedDate__c').withinLastDays(30) | ✔️ null |
| 🟢 | test6 | ✔️ 799 | ✔️ extract('CA10__monitorCpuPercentAvg30Day__c').isEmpty() || extract('CA10__monitorStoragePercentMax30Day__c').isEmpty() | ✔️ null |
| 🟢 | test7 | ✔️ 899 | ✔️ extract('CA10__monitorDtuConsumptionPercentAvg30Day__c').isNotEmpty() && extract('CA10__monitorDtuConsumptionPercentAvg30Day__c') < number(20.0) && extract('CA10__monitorStoragePercentMax30Day__c') < number(10.0) | ✔️ null |
| 🟢 | test8 | ✔️ 999 | ✔️ extract('CA10__monitorAppMemoryPercentAvg30Day__c').isNotEmpty() && extract('CA10__monitorAppMemoryPercentAvg30Day__c') < number(40.0) && extract('CA10__monitorCpuPercentAvg30Day__c') < number(20.0) && extract('CA10__monitorStoragePercentMax30Day__c') < number(10.0) | ✔️ null |
| 🟢 | test9 | ✔️ 1099 | ✔️ extract('CA10__monitorDtuConsumptionPercentAvg30Day__c').isEmpty() && extract('CA10__monitorAppMemoryPercentAvg30Day__c').isEmpty() && extract('CA10__monitorCpuPercentAvg30Day__c') < number(20.0) && extract('CA10__monitorStoragePercentMax30Day__c') < number(10.0) | ✔️ null |
| 🟢 | test10 | ✔️ 1100 | ✔️ otherwise | ✔️ null |
| 🟢 | test11 | ✔️ 199 | ✔️ extract('CA10__skuName__c') == 'ElasticPool' | ✔️ null |
| 🟢 | test12 | ✔️ 299 | ✔️ extract('CA10__kind__c').contains('serverless') | ✔️ null |
Generation Bundle
| File | MD5 | |
|---|---|---|
| Open | /ce/ca/azure/sql-database/database-underutilized/policy.yaml | AD6EF10170A2787639FBEEACD5AAF6E7 |
| Open | /ce/ca/azure/sql-database/database-underutilized/prod.logic.yaml | 3B2368B65A6A4EDD23150348B99D3C29 |
| Open | /ce/ca/azure/sql-database/database-underutilized/test-data.json | 19E59C702707EB7545A9108E8119FE1F |
| Open | /types/CA10__CaAzureSqlDatabase__c/object.extracts.yaml | B4BDC0B62AEF4B03FB276D037CE05688 |
Available Commands
repo-manager policies generate FULL /ce/ca/azure/sql-database/database-underutilized/prod.logic.yaml
repo-manager policies generate DEBUG /ce/ca/azure/sql-database/database-underutilized/prod.logic.yaml
repo-manager policies generate CAPTURE_TEST_DATA /ce/ca/azure/sql-database/database-underutilized/prod.logic.yaml
repo-manager policies generate TESTS /ce/ca/azure/sql-database/database-underutilized/prod.logic.yaml
# Execute tests
repo-manager policies test /ce/ca/azure/sql-database/database-underutilized/prod.logic.yaml
Content
---
inputType: "CA10__CaAzureSqlDatabase__c"
importExtracts:
- file: "/types/CA10__CaAzureSqlDatabase__c/object.extracts.yaml"
testData:
- file: 'test-data.json'
conditions:
- status: "INAPPLICABLE"
currentStateMessage: "This database belongs to an Elastic Pool."
check:
IS_EQUAL:
left:
EXTRACT: "CA10__skuName__c"
right:
TEXT: "ElasticPool"
- status: "INAPPLICABLE"
currentStateMessage: "This is a serverless database."
check:
CONTAINS:
arg:
EXTRACT: "CA10__kind__c"
search:
TEXT: "serverless"
- status: "INAPPLICABLE"
currentStateMessage: "This is a master database."
check:
CONTAINS:
arg:
EXTRACT: "CA10__kind__c"
search:
TEXT: "system"
- status: "INAPPLICABLE"
currentStateMessage: "The database is not online."
check:
NOT_EQUAL:
left:
EXTRACT: "CA10__satus__c"
right:
TEXT: "Online"
- status: "INAPPLICABLE"
currentStateMessage: "The database was created in the last 30 days."
check:
IS_WITHIN_LAST_DAYS:
offsetDays: 30
arg:
EXTRACT: "CA10__creationDate__c"
- status: "INAPPLICABLE"
currentStateMessage: "The database was paused in the last 30 days."
check:
IS_WITHIN_LAST_DAYS:
offsetDays: 30
arg:
EXTRACT: "CA10__pausedDate__c"
- status: "UNDETERMINED"
currentStateMessage: "There is not enough data in the CMDB to determine whether the database is underutilized."
check:
OR:
args:
- IS_EMPTY:
arg:
EXTRACT: "CA10__monitorCpuPercentAvg30Day__c"
- IS_EMPTY:
arg:
EXTRACT: "CA10__monitorStoragePercentMax30Day__c"
- status: "INCOMPLIANT"
currentStateMessage: "The database DTU consumption is less than 20%, and storage utilization is less than 10%."
remediationMessage: "Rightsize the database."
check:
AND:
args:
- NOT_EMPTY:
arg:
EXTRACT: "CA10__monitorDtuConsumptionPercentAvg30Day__c"
- LESS_THAN:
left:
EXTRACT: "CA10__monitorDtuConsumptionPercentAvg30Day__c"
right:
NUMBER: 20.0
- LESS_THAN:
left:
EXTRACT: "CA10__monitorStoragePercentMax30Day__c"
right:
NUMBER: 10.0
- status: "INCOMPLIANT"
currentStateMessage: "The database CPU utilization is less than 20%, app memory utilization is less than 40%, and storage utilization is less than 10%."
remediationMessage: "Rightsize the database."
check:
AND:
args:
- NOT_EMPTY:
arg:
EXTRACT: "CA10__monitorAppMemoryPercentAvg30Day__c"
- LESS_THAN:
left:
EXTRACT: "CA10__monitorAppMemoryPercentAvg30Day__c"
right:
NUMBER: 40.0
- LESS_THAN:
left:
EXTRACT: "CA10__monitorCpuPercentAvg30Day__c"
right:
NUMBER: 20.0
- LESS_THAN:
left:
EXTRACT: "CA10__monitorStoragePercentMax30Day__c"
right:
NUMBER: 10.0
- status: "INCOMPLIANT"
currentStateMessage: "The database CPU is less than 20% and storage utilization is less than 10%."
remediationMessage: "Rightsize the database."
check:
AND:
args:
- IS_EMPTY:
arg:
EXTRACT: "CA10__monitorDtuConsumptionPercentAvg30Day__c"
- IS_EMPTY:
arg:
EXTRACT: "CA10__monitorAppMemoryPercentAvg30Day__c"
- LESS_THAN:
left:
EXTRACT: "CA10__monitorCpuPercentAvg30Day__c"
right:
NUMBER: 20.0
- LESS_THAN:
left:
EXTRACT: "CA10__monitorStoragePercentMax30Day__c"
right:
NUMBER: 10.0
otherwise:
status: "COMPLIANT"
currentStateMessage: "The database is not underutilized."