[en] DB changes not specific to Data Update Job
[en] This section contains a reference of SnowInventory and SnowLicenseManager database object changes introduced in Snow License Manager 9.
[en] 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.
[en] Added tables
[en] Table | [en] Purpose |
---|---|
[en] dbo.tblSystemUserCurrency | [en] Optimizing calculation of Custom Fields |
[en] o365.ViewModelSubscriptionPlanCost | [en] O365 improvements, pre-calculating costs of subscriptions to improve load times |
[en] sea.MigrationVersion | [en] Migration Version table to the SEA namespace to handle upgrades |
[en] dbo.tblComputerWinServerInventory | [en] Result table for Windows Server Assessment reports |
[en] dbo.tblComputerWinServerInventoryRisks | [en] Potential risks in Windows Server Assessment Reports |
[en] Removed table
[en] Table | [en] Reason |
---|---|
[en] | [en] (obsolete) |
[en] Added columns
[en] Table | [en] Columns | [en] Reason |
---|---|---|
[en] | [en] LastLoggedOnUser nvarchar(100) NULL [en] IsVirtual bit NULL [en] BiosSerialNumber nvarchar(100) NULL [en] IsPortable bit NULL [en] IsServer bit NULL [en] ProcessorType nvarchar(100) NULL [en] ProcessorCount int [en] CoreCount int NULL [en] MemorySlots int NULL [en] MemorySlotsAvailable int NULL [en] PhysicalMemory int NULL [en] SystemDiskSpace bigint NULL [en] SystemDiskSpaceAvailable bigint NULL [en] TotalDiskSpace bigint NULL [en] TotalDiskSpaceAvailable bigint NULL [en] MacAddresses nvarchar(100) NULL [en] DisplayAdapters nvarchar(200) NULL [en] ScanIdentifier nvarchar(100) NULL [en] ClientVersion nvarchar(256) NULL [en] ClientInstallDate datetime NULL [en] ClientSiteName nvarchar(100) NULL [en] ClientConfigurationName nvarchar(100) NULL [en] PurchaseDate datetime NULL [en] Vendor nvarchar(100) NULL [en] InvoiceReference nvarchar(50) NULL [en] PurchasePrice numeric(18,2) NULL [en] PurchaseCurrency nvarchar(10) NULL [en] TotalCostOfInstalledApplications numeric(18,2) NULL [en] TotalCostForThisComputer numeric(18,2) NULL | [en] These new columns enable more detailed reporting on archived computers |
[en] | [en] UpgradedLegalLicenseCount | [en] For cross-metric and quantity license upgrades |
[en] | [en] GlobalCustomFieldID | [en] Added a GUID to each custom field |
[en] | [en] HypervisorType [en] HighAvailability [en] VmwareDRS | [en] 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 |