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