// 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.
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.
Automating SQL Server SPLA — Dual Licensing Models, Automatic Cost Optimization
Per-VM or Physical Host? Two licensing models, two cost scenarios per cluster — how I built automatic cost optimization for SQL Server SPLA across mixed Standard and Enterprise environments.
Automating Windows Server SPLA — From Manual Clusters to Automated Compliance
Datacenter or Standard? The 8-VM density threshold, failover cluster aggregation, and monthly true-ups — how I automated SPLA license count calculation across 80+ clusters.
Automating RHEL Licensing — From VM Thresholds to vCPU Tiers
Three infrastructure types, a 4-VM threshold that changes everything, orphaned VMs, and unclassified servers — how I automated Red Hat licensing across 1,200+ instances.
The Hidden Complexity of SUSE Licensing — And How I Automated It
Nine SKUs, six pricing tiers, and multiple licensing models — how I automated SUSE licensing through ToolsHub Business Intelligence across 1,000+ devices.
Building Compliance Dashboards in Power BI for Snow License Manager
How I built Windows Server and SQL Server compliance dashboards through 26 combined versions — and what I learned about Power BI's fragile data transformation layer the hard way.