// 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.
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.
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.
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.