dtcSN and SQLNow are built and released together — every change to either, reconstructed from the project's commit history.
For icon support in SQLNow grids.
ASP.NET web app (dhtmlx) for SQL Server inventory and master-data management. Read-only grids with alternating row colors and Font Awesome icons. New "Stammdaten" (master data) section with CRUD forms for 8 tables (Customer, CustomerDomain, ExcludeDB, CompType, DatabaseType, SQLEntityType, SQLVersion, Support), each with its own handler.
In the loading screen.
New tables (AlertHistory, deduplicated by AlertGuid, 90-day retention; MaintenanceHistory, 365-day retention) with performance indexes. New import steps wired into the SQL Agent job, plus views under the same names as the former OperationsManagerDW views so SQLNow's handlers need no code changes.
T-SQL and MySQL/IONOS PHP demo variants, covering all 11 dtcSN tables, idempotent. Fixed afterward: an FK delete-order violation and a datetime conversion error on German-locale SQL Server.
Hardcoded filename paths replaced with dynamic SERVERPROPERTY lookups, THROW; corrected to ;THROW; (T-SQL parser requirement), and a hardcoded sa owner login replaced with a configurable variable.
T-SQL reporting layer over SCOM OperationsManagerDW: SQL Server, computer, and database inventory with customer assignment.