DB changes not specific to Data Update Job
This section contains a reference of SnowInventory and SnowLicenseManager database object changes introduced in Snow License Manager 9.
Changes have been made to the SnowLicenseManager database schema. Therefore, if a customer upgrading to Snow License Manager 9 has implemented custom stored procedures and custom reports in version 8, these will need to be updated if they have been affected by any of the database changes below.
Added tables
| Table | Purpose |
|---|---|
| dbo.tblSystemUserCurrency | Optimizing calculation of Custom Fields |
| o365.ViewModelSubscriptionPlanCost | O365 improvements, pre-calculating costs of subscriptions to improve load times |
| sea.MigrationVersion | Migration Version table to the SEA namespace to handle upgrades |
| dbo.tblComputerWinServerInventory | Result table for Windows Server Assessment reports |
| dbo.tblComputerWinServerInventoryRisks | Potential risks in Windows Server Assessment Reports |
Removed table
| Table | Reason |
|---|---|
| dbo.tblEventStoreStreams | (obsolete) |
Added columns
| Table | Columns | Reason |
|---|---|---|
| dbo.tblComputerArchive | LastLoggedOnUser nvarchar(100) NULL IsVirtual bit NULL BiosSerialNumber nvarchar(100) NULL IsPortable bit NULL IsServer bit NULL ProcessorType nvarchar(100) NULL ProcessorCount int CoreCount int NULL MemorySlots int NULL MemorySlotsAvailable int NULL PhysicalMemory int NULL SystemDiskSpace bigint NULL SystemDiskSpaceAvailable bigint NULL TotalDiskSpace bigint NULL TotalDiskSpaceAvailable bigint NULL MacAddresses nvarchar(100) NULL DisplayAdapters nvarchar(200) NULL ScanIdentifier nvarchar(100) NULL ClientVersion nvarchar(256) NULL ClientInstallDate datetime NULL ClientSiteName nvarchar(100) NULL ClientConfigurationName nvarchar(100) NULL PurchaseDate datetime NULL Vendor nvarchar(100) NULL InvoiceReference nvarchar(50) NULL PurchasePrice numeric(18,2) NULL PurchaseCurrency nvarchar(10) NULL TotalCostOfInstalledApplications numeric(18,2) NULL TotalCostForThisComputer numeric(18,2) NULL | These new columns enable more detailed reporting on archived computers |
| dbo.tblLicenseUpgrades | UpgradedLegalLicenseCount | For cross-metric and quantity license upgrades |
| dbo.tblCustomField | GlobalCustomFieldID | Added a GUID to each custom field |
| dbo.tblDCC | HypervisorType HighAvailability VmwareDRS | These new columns allow users to specify if a cluster is set up as a high-availability cluster for all hyper-visors to enable the calculation of Windows Server Licensing |