// blog
Blog / Articles
Technical deep-dives into licensing automation and ITAM engineering.
Building an Exchange Server CAL Inventory Connector for Snow License Manager
How I built a multi-stage ETL pipeline to extract Exchange CAL compliance data from a four-server DAG cluster — and why it took four script versions to get the collection right.
Building a QRadar Compliance Connector for Snow License Manager
How I built an ETL pipeline to bring IBM QRadar's EPS-based licensing into Snow License Manager — and the first data pull immediately revealed the client was out of compliance.
Building a Custom Fields Bulk Updater for Snow License Manager
How a 'simple' bulk update tool for a software development company turned into a three-version rabbit hole of dual-team classification merging, wildcard matching edge cases, and SQL optimization.
Encoding Java Compliance — A Version-Aware Rules Engine and Continuous Monitoring
How I encoded Oracle Java licensing rules into a SQL recognition engine and version-aware classification pipeline — cutting RED installations by 44% and turning periodic manual audits into ongoing monitoring.
Building an IT System Owner Notification System on Top of Snow License Manager
How I turned Snow License Manager's unused contract management into an automated expiration alerting system — delivering personalized notifications to IT system owners before contracts lapse.
Oracle Java Compliance — Multi-Source Discovery and a RED/YELLOW/GREEN Framework
How I combined Flexera FNMS extraction with collection scripts and a RED/YELLOW/GREEN framework to give thousands of machines a defensible Oracle Java compliance position — before any conversation with Oracle.
Building a ChatGPT Enterprise Usage Compliance Connector for Snow License Manager
How I built a Python connector bridging OpenAI's Compliance API with Snow License Manager — and diagnosed false license revocations caused by transient API data gaps.
Building a Three-Module Fidelis Connector for Snow License Manager
Three security modules, three different data sources, one compliance dashboard — how I built an automated Fidelis connector for Snow License Manager.
Building a Server HW Monitoring System for Snow License Manager
How I built an automated alerting system for hardware changes and stale inventory across thousands of servers — from v1 prototype to v2 with 65% alert reduction.