Update Microsoft field names and automate EV checkbox filling based on Microsoft Policy OIDs
This case updates CCADB’s Microsoft-specific fields and related automation logic. The work was triggered by a need to align CCADB field names and EV checkbox behavior with Microsoft Policy OIDs and a provided spreadsheet. In sandbox, Poonam Bhargava updated Microsoft fields (e.g., mapping “Microsoft EV Policy OID(s)” to “EVPolicyList” and “Microsoft EKU” to “EKUList”) and added trigger logic to auto-fill EV Code Signing and EV TLS checkboxes based on the Microsoft EKUs and EV Policy OID(s). The triggers also update Microsoft EKUs based on “Microsoft Not Before EKU List,” set Microsoft Status based on RootStatus values, and add new fields including “Microsoft Not Before EKU List” and “Microsoft Not Before Date.” Kathleen Wilson requested a meeting to review and test the sandbox changes. CCADB production was later updated on August 5, and the CCADB release notes were updated to reflect the renamed fields, added fields, and updated processes/reports (including ALV input and derived trust-bit logic). The bug is resolved as FIXED.
- CCADB work initiated to update Microsoft-specific fields and EV checkbox automation logic.
- Sandbox changes completed, including field mappings and trigger logic for EV checkbox auto-filling.
- Request made to schedule a meeting with Karina to review/test sandbox changes.
- CCADB production updated with renamed Microsoft fields, added Not Before fields, and updated processes/reports.
- Community commenter — Provided detailed instructions for renaming Microsoft fields, mapping spreadsheet columns to CCADB fields, and adding trigger logic to auto-fill EV checkboxes and update Microsoft Status based on Microsoft Policy OIDs.
- Community commenter — Reported sandbox completion, including spreadsheet-based updates, trigger logic for EV Code Signing/EV SSL checkboxes, and renaming/adding Microsoft fields and related case-field prefill logic.
- Community commenter — Asked to schedule a meeting with Karina to review/test the sandbox changes.
- Community commenter — Confirmed CCADB production was updated on August 5 and noted release notes updates, including renamed/deprecated field handling and updated CCADB processes and reports.