v1.5.4

What's Changed

• Skip files in translation workflow when processing deleted files by @sdolgin in #1013
• Add punctuation to trigger translation workflow on a changed JSON file by @sdolgin in #1014
• Automatic translation of checklists/ai_lz_checklist.en.json by @sdolgin in #998
• updates to versioning cell by @igorjnzl in #1017
• Update alz_checklist.en.json by @hgotar1 in #1012
• Add single query to question B03.02 by @lcarli in #1019
• Alisakina99 addlangs by @alisakina99 in #1032
• Remove Reference to Web App in ReadMe by @alisakina99 in #1011
• ALZ Workbook Generator + Queries by @lcarli in #1026
• Adding DNS check based on field feedback by @igorjnzl in #1035
• Update severity level and text in ALZ checklist by @igorjnzl in #1041
• Fix JSON import issue for undefined check results in compliance column by @sdolgin in #1031

New Contributors

• @lcarli made their first contribution in #1019

Full Changelog: v1.5.3...v1.5.4

v1.5.3

What's Changed

• fixing typo in WAF category name by @infosatheesh2020 in #816
• Automatic translation of checklists/aoai_checklist.en.json by @sdolgin in #817
• Azure Billing & Entra ID Training Links by @alisakina99 in #818
• Latest version of the WAF service guides retrieved by @sdolgin in #822
• Identitytraininglinks by @alisakina99 in #824
• Update alz_checklist.en.json (Network Topology Training Links) by @alisakina99 in #826
• Latest version of the WAF service guides retrieved by @sdolgin in #832
• Automatic translation of checklists-ext/appservicewebapps_sg_checklist.en.json checklists-ext/azureapplicationgateway_sg_checklist.en.json checklists-ext/azureblobstorage_sg_checklist.en.json checklists-ext/azureexpressroute_sg_checklist.en.json checklists-ext/azurefiles_sg_checklist.en.json checklists-ext/azurefirewall_sg_checklist.en.json checklists-ext/azurefrontdoor_sg_checklist.en.json checklists-ext/azurekubernetesservice_sg_checklist.en.json checklists-ext/azuremachinelearning_sg_checklist.en.json checklists-ext/azureopenai_sg_checklist.en.json checklists-ext/virtualmachines_sg_checklist.en.json checklists-ext/wafsg_checklist.en.json by @sdolgin in #833
• Update network_appdelivery_checklist.en.json by @asukumar22 in #835
• Update network_appdelivery_checklist.en.json by @asukumar22 in #837
• Update network_appdelivery_checklist.en.json by @asukumar22 in #836
• Create PULL_REQUEST_TEMPLATE.md by @sdolgin in #820
• Add Issue Templates for Feature Requests, Bug Reports, and Documentation Improvements by @sdolgin in #819
• Automatic translation of checklists/network_appdelivery_checklist.en.json by @sdolgin in #839
• Update alz_checklist.en.json (DevOps Training Links) by @alisakina99 in #830
• Update alz_checklist.en.json (Management Training Links) by @alisakina99 in #829
• PR Template Update - Adding ARG Query Requirements by @sdolgin in #846
• Update alz_checklist.en.json (security training links) by @alisakina99 in #827
• Update alz_checklist.en.json (Resource Organization Training Links) by @alisakina99 in #825
• Linting and updating contribution guidance by @brsteph in #843
• updated storage checklist by @cshea-msft in #845
• Automatic translation of checklists/azure_storage_checklist.en.json by @sdolgin in #847
• Update network_appdelivery_checklist.en.json by @asukumar22 in #834
• Latest version of the WAF service guides retrieved by @sdolgin in #849
• Update README.md by @codebytes in #844
• Automatic translation of checklists-ext/appservicewebapps_sg_checklist.en.json checklists-ext/azureapplicationgateway_sg_checklist.en.json checklists-ext/azureblobstorage_sg_checklist.en.json checklists-ext/azureexpressroute_sg_checklist.en.json checklists-ext/azurefiles_sg_checklist.en.json checklists-ext/azurefirewall_sg_checklist.en.json checklists-ext/azurefrontdoor_sg_checklist.en.json checklists-ext/azurekubernetesservice_sg_checklist.en.json checklists-ext/azuremachinelearning_sg_checklist.en.json checklists-ext/azureopenai_sg_checklist.en.json checklists-ext/virtualmachines_sg_checklist.en.json checklists-ext/wafsg_checklist.en.json by @sdolgin in #850
• New recommendation for SIEM solution by @inbalsilis in #838
• Automatic translation of checklists/alz_checklist.en.json by @sdolgin in #852
• Update alz_checklist.en.json AMA by @hgotar1 in #851
• Automatic translation of checklists/alz_checklist.en.json by @sdolgin in #853
• Latest version of the WAF service guides retrieved by @sdolgin in #857
• Automatic translation of checklists-ext/appservicewebapps_sg_checklist.en.json checklists-ext/azureapplicationgateway_sg_checklist.en.json checklists-ext/azureblobstorage_sg_checklist.en.json checklists-ext/azureexpressroute_sg_checklist.en.json checklists-ext/azurefiles_sg_checklist.en.json checklists-ext/azurefirewall_sg_checklist.en.json checklists-ext/azurefrontdoor_sg_checklist.en.json checklists-ext/azurekubernetesservice_sg_checklist.en.json checklists-ext/azuremachinelearning_sg_checklist.en.json checklists-ext/azureopenai_sg_checklist.en.json checklists-ext/virtualmachines_sg_checklist.en.json checklists-ext/wafsg_checklist.en.json by @sdolgin in #858
• Latest version of the WAF service guides retrieved by @sdolgin in #863
• Automatic translation of checklists-ext/appservicewebapps_sg_checklist.en.json checklists-ext/azureapplicationgateway_sg_checklist.en.json checklists-ext/azureblobstorage_sg_checklist.en.json checklists-ext/azureexpressroute_sg_checklist.en.json checklists-ext/azurefiles_sg_checklist.en.json checklists-ext/azurefirewall_sg_checklist.en.json checklists-ext/azurefrontdoor_sg_checklist.en.json checklists-ext/azurekubernetesservice_sg_checklist.en.json checklists-ext/azuremachinelearning_sg_checklist.en.json checklists-ext/azureopenai_sg_checklist.en.json checklists-ext/virtualmachines_sg_checklist.en.json checklists-ext/wafsg_checklist.en.json by @sdolgin in #864
• Latest version of the WAF service guides retrieved by @sdolgin in #868
• Standalone list for Azure Front Door by @andredewes in #861
• Automatic translation of checklists-ext/appservicewebapps_sg_checklist.en.json checklists-ext/azureapplicationgateway_sg_checklist.en.json checklists-ext/azureblobstorage_sg_checklist.en.json checklists-ext/azureexpressroute_sg_checklist.en.json checklists-ext/azurefiles_sg_checklist.en.json checklists-ext/azurefirewall_sg_checklist.en.json checklists-ext/azurefrontdoor_sg_checklist.en.json checklists-ext/azurekubernetesservice_sg_checklist.en.json checklists-ext/azuremachinelearning_sg_checklist.en.json checklists-ext/azureopenai_sg_checklist.en.json checklists-ext/virtualmachines_sg_checklist.en.json checklists-ext/wafsg_checklist.en.json by @sdolgin in #869
• Automatic translation of checklists/afd_checklist.en.json by @sdolgin in #870
• Adding resiliency checks for alz services by @igorjnzl in #859
• Update alz_checklist.en.json (Governance Training Links) by @alisakina99 in #828
• Latest version of the WAF service guides retrieved by @sdolgin in #874
• Updated AOAI checklist syncing with WAF service guide by @infosatheesh2020 in #860
• Automatic translation of checklists/servicebus_checklist.en.json by @sdolgin in #875
• Update CONTRIBUTING.md by @tofusgh in #891
• Added ARG query for D10.06 in alz_checklist.en.json by @tofusgh in #877
• Added ARG query for D10.07 in alz_checklist.en.json by @tofusgh in #878
• Automatic translation of checklists/alz_checklist.en.json by @sdolgin in #894
• Updates to support multi region guidance by @igorjnzl in #901
• Update alz_checklist.en.json by @hgotar1 in #871
• Latest version of the WAF service guides retrieved by @sdolgin in #916
• added kv recommendation and arg query 05.01 by @cshea-msft in #913
• Automatic translation of checklists/keyvault_checklist.en.json by @sdolgin in #917
• Add ARG query for D09.04/D09.06 in alz_checklist.en.json by @yasukunim in #912
• Added ARG query for C02.05/D01.02/D01.03/D01.04 in avs_checklist.en.json by @tsubasaxZZZ in #911
• Update container_apps_checklist.en.json 01.01.01 , 01.01.02 by @sonalika-roy in #910
• Update azfun_checklist.en.json - A01.02 & A01.05 by @sonalika-roy in #909
• Added Storage ARG queries by @cshea-msft in #906
• Added servicefabric_checklist.en.json - Item ID: C01.01, C01.02, C01.03, C01.04, C...

v1.5.2

• Minor bug fix on the spreadsheet charts page

v1.5.1

Checklist changes:

• WAF checklist is now a 1st-class citizen
• SAP checklist GA
• Security checklist deprecated. Security checks will be integrated in all the other checklists.

Minor enhancements to the spreadsheet:

• WAF checklist in the menu.
• Security checklist removed (WAF to be used instead), as requested by security engineers.
• WAF checklist shows from which checklist each item is coming from.
• Removed AMMP column.

v1.5.0

New features:

• Macro-enabled spreadsheet:
  • Telemetry
  • Run Graph queries directly from spreadsheet
  • Ability to load multiple checklists (WAF)
  • Service column
  • Auto show/hide columns depending on the checklist
  • Check of spreadsheet version on startup
  • Link to provide feedback over a new Github issue
• Web UI
  • Telemetry
• Other
  • Network App Delivery automated workbook

v1.4.1

• New checklists:
  • Azure Spring Apps
  • Azure DevOps
  • SQL Migration
• New language: Chinese Traditional

v1.4.0

New features:

• CSU items merged into the ALZ checklist
• Check ID (format "A00.00"), which is automatically added by the spreadsheet to exported JSON if the column is empty
• AMMP field to shorten ALZ reviews carried out in the Azure Migration and Modernization Program
• WAF pillar field (Well-Architected Framework), so that reviews centered on a specific pillar are easier to execute
• New checklists: ARO, cost optimization, hybrid
• Automatic generation of master checklists (both JSON and Excel)

v1.3.0

New features:

• FTA Branding removed
• LZ name changed to ALZ
• topics field introduced in the schema (not yet in the checklists)
• Checklist state (GA/Preview) in checklist metadata
• Linting checklist correctness:
  • GUIDs are unique
• Azure Monitor workbooks
  • Automatic generation of workbook code and ARM templates for checklists containing graph queries
  • Possibility of generating category-specific workbooks (such as for networking)
• Specific PAT for creation of PRs with automatically created files (translated checklists, macro-free spreadsheets and Azure Monitor workbooks)
• WAF pillar is now included in the JSON and the spreadsheets, so that a review can be done focusing on one or more of the pillars

Checklists supported:

Checklist	Status	Description
LZ	GA	Landing Zone design review
AKS	GA	Azure Kubernetes Service design review
AVD	GA	Azure Virtual Desktop design review
Multitenancy	GA	Multitenancy design review
Security	Preview	Security review
AVS	Preview	Azure VMware Solution design review
SAP	Preview	SAP design review
APIM	Preview	API Management design review
Azure Arc	Preview	Azure Arc design review 🆕
Security	Preview	Security checklists for different products: Azure SQL, ACR, Blob storage

v1.2.0

This is not the latest release, please access the latest release here.

New features:

• English checklists sorted by github action (still some cosmetic issues to polish, such as the fact that the sorting generates another PR with automatic translations)
• Macro-free Excel spreadsheets generated automatically

Checklists supported:

Checklist	Status	Description
LZ	GA	Landing Zone design review
AKS	GA	Azure Kubernetes Service design review
AVD	GA	Azure Virtual Desktop design review
Multitenancy	GA	Multitenancy design review
Security	Preview	Security review
AVS	Preview	Azure VMware Solution design review
SAP	Preview	SAP design review
APIM	Preview	API Management design review
Security	Preview	Security checklists for different products: Azure SQL, ACR, Blob storage

Fixed issues:

• Not using an external Github action for translation, but a custom Python script, which gives us better control and will enable using custom translators in the future

New Work In Progress:

• Considering merging multiple checklists to generate area-focused lists (for example for security or resiliency). See script /scripts/compile_checklist.py

v1.1.0

This is not the latest release, please access the latest release here.

New features:

• Multitenancy checklist.
• Added legend for status values to the checklist.
• Added 'Not required' to the list of status, to document recommendations might be applicable, but not desired/needed.
• Graph query format simplified: only a single query is required instead of two.
• JSON schema added

Checklists supported:

Checklist	Status	Description
LZ	GA	Landing Zone design review
AKS	GA	Azure Kubernetes Service design review
AVD	GA	Azure Virtual Desktop design review
Multitenancy	GA	Multitenancy design review
Security	Preview	Security review
AVS	Preview	Azure VMware Solution design review

Fixed issues:

• Checklist load time optimized, now it takes under 10 seconds
• Simplified mechanism to onboard checklists to the spreadsheet (adding them to the Values worksheet is enough, no coding required)
• Translation action does not break the JSON structure any more

New Work In Progress:

• Web UI for self-consumption: https://aka.ms/ftaaas. See our sister repo https://github.com/Azure/fta-aas for more information and the source code.
• Python scripts (in scripts folder) using xlwings/openpyxl to create/update Excel spreadsheets with either Graph query results or the latest checklist. This would enable the following:
  • Macro-free Excel spreadsheets
  • Support for Mac OS X (through macro-free spreadsheets)