DB changes due to Data Update Job modifications

This section is a reference of SnowInventory and SnowLicenseManager database object additions, deletions, and changes that are a direct result of Data Update Job modifications between Snow License Manager versions 8 and 9.

Deleted SnowInventory DB objects

Object type	Name	Replaced by object in SnowLicenseManager DB
Table	inv.TransferComputers	inv.tblComputer* (multiple tables) Note: The asterisk character— * —denotes wild card.
Table	inv.TransferSoftware	inv.tblSoftware
Table	inv.TransferSoftwareExclusion	Replaced by new column IsExcluded in table dbo.tblSoftwareApplicationMap
Table	inv.TransferUsers	inv.tblUser/inv.tblUserInfo

Deleted SnowLicenseManager DB objects

Object type	Name	Replaced by object in SnowLicenseManager DB
Table	dbo.tblComputerPrinters	Replaced with table dbo.tblComputerPrinter (singular form)
Table	dbo.tblComputerVirtualPackages	Replaced with table dbo.tblComputerVirtualPackage (singular form)
Table	dbo.tblComputerWork	(obsolete)
Table	dbo.tblMobileDeviceProperties	Replaced by table dbo.tblMobileDeviceProperty (singular form)
Table	dbo.tblSoftwareSearch	(obsolete)
Table	dbo.tblSoftwareStage	(obsolete)
Table	dbo.tblUserSourceMap	Replaced by new mapping table inv.tblUserInvSlmMap
Stored Procedure	dbo.JobExecute	(obsolete)
Stored Procedure	dbo.JobInventoryActiveDirectoryUpdate	(obsolete)
Stored Procedure	dbo.JobExecute	(obsolete)
Stored Procedure	dbo.JobInventoryComputerListUpdate	(obsolete)
Stored Procedure	dbo.JobInventoryComputersUpdate	(obsolete)
Stored Procedure	dbo.JobInventoryMapSoftwareApplications	(obsolete)
Stored Procedure	dbo.JobInventorySoftwareUpdate	(obsolete)
Stored Procedure	dbo.JobInventoryUserListUpdate	(obsolete)
Stored Procedure	dbo.JobInventoryUsersUpdate	(obsolete)
Stored Procedure	dbo.JobRebuildIndexes	(obsolete)
Stored Procedure	dbo.JobShrinkDB	(obsolete)
Stored Procedure	dbo.SoftwareSearchRefresh	(obsolete)
Stored Procedure	dbo.UserQuarantineDelete	Replaced with new procedure dbo.QuarantineDeleteUser
View	dbo.viewReportComputersComplete	(obsolete)
View	dbo.vMultiVersionCoverage	(obsolete)
View	dbo.tblInventoryMetering	(obsolete)
Stored Procedure	dbo.AddIndexToMetering	(obsolete)

Added SnowInventory DB objects

Object type	Name	Description
Schema	slm	Contains all Data Update Job-related objects
Table	inv.DataMetering_History	History table for storing data already transferred to SnowLicenseManager DB
Table	inv.DataMeteringConcurrency_History	History table for storing data already transferred to SnowLicenseManager DB
Table	slm.ClientSiteDBMap	Map Client to Site by Id, references table inv.tblSite in SnowLicenseManager DB
Table	slm.tblInventoryDatabase	Stores DatabaseId (references table inv.tblInventoryDatabase in SnowLicenseManager DB) and current SequenceNumber and RowVersion information. Used for incremental load from INV to SLM.
Table	slm.tblReplaceWithEmpty	Simple mapping table containing strings to be replaced with <empty string&gt;, such as unknown, none, and so on
Procedure	slm.ArchiveMetering	Move transferred Metering data from inv.DataMetering to *_History table.
Procedure	slm.ArchiveMeteringConcurrency	Move transferred MeteringConcurrency data from inv.DataMeteringConcurrency to *_History table.
Procedure	slm.GetADComputerDiscovery	Load incremental data from table inv.DiscoveryMetadata
Procedure	slm.GetADUserDiscovery	Load incremental data from table inv.DiscoveryUserActiveDirectory
Procedure	slm.GetAPIKey	Load incremental data from table inv.APIKey
Procedure	slm.GetApplicationConcurrency	Load incremental data from table inv.DataMeteringConcurrency/-History
Procedure	slm.GetComputerClient	Load incremental data from table inv.DataClient
Procedure	slm.GetComputerDisplayAdapter	Load incremental data from table inv.DataDisplayAdapter
Procedure	slm.GetComputerEnvironment	Load incremental data from table inv.DataEnvironmentVariable
Procedure	slm.GetComputerLogicalDisk	Load incremental data from table inv.DataLogicalDisk
Procedure	slm.GetComputerMemory	Load incremental data from table inv.DataMemory
Procedure	slm.GetComputerMemoryModule	Load incremental data from table inv.DataMemoryModule
Procedure	slm.GetComputerMonitor	Load incremental data from table inv.DataMonitor
Procedure	slm.GetComputerNetworkAdapter	Load incremental data from table inv.DataNetworkAdapter
Procedure	slm.GetComputerOperatingSystem	Load incremental data from table inv.DataOperatingSystem
Procedure	slm.GetComputerPhysicalDisk	Load incremental data from table inv.DataPhysicalDisk
Procedure	slm.GetComputerPrinter	Load incremental data from table inv.DataPrinter
Procedure	slm.GetComputerProcessor	Load incremental data from table inv.DataProcessor
Procedure	slm.GetComputerRegistry	Load incremental data from table inv.DataCustomRegKey
Procedure	slm.GetComputerSoftwareProductSlm Note: The Slm suffix is necessary because the SnowInventory DB cannot identify the slm schema, and an object called inv.GetComputerSoftwareProduct already exists in the database.	Load incremental data from table inv.DataSoftwareProduct
Procedure	slm.GetComputerSoftwareSlm Note: The Slm suffix is necessary because the SnowInventory DB cannot identify the slm schema, and an object called inv.GetComputerSoftware already exists in the database.	Load incremental data from table inv.DataSoftware
Procedure	slm.GetComputerVirtualPackage	Load incremental data from table inv.DataVirtualSoftwarePackages
Procedure	slm.GetComputerWith64BitSoftware	Identifying through application pathnames (inv.DataSoftware + inv.DataGeneratedSoftware) if the operating system for a computer is 32 or 64-bit.
Procedure	slm.GetDataCenterClient	Load incremental data from table inv.DataDataCenter
Procedure	slm.GetDataCenterFeature	Load incremental data from table inv.DataDataCenterFeature
Procedure	slm.GetDataCenterVirtualMachine	Load incremental data from table inv.DataVirtualMachine
Procedure	slm.GetInventorySequenceNumber	Update table inv.tblInventoryDatabase with latest values for SequenceNumberand RowVersion.
Procedure	slm.GetLoginUserClient	Load latest user logon information from an aggregate of tables inv.DataLoginUser (Date), inv.DataClient (LastUpdate) and inv.DataMetering (LastUsed)
Procedure	slm.GetMetering	Load incremental data from table inv.DataMetering/-_History
Procedure	slm.GetMeteringCloud	Load incremental data from table inv.CloudMeteringIntervalHits
Procedure	slm.GetMobileDeviceProperty	Load incremental data from table inv.DataMobileDeviceProperties
Procedure	slm.GetOracleDatabase	Load incremental data from table inv.DataOracleDatabase
Procedure	slm.GetOracleDatabaseFeatureUsageStats	Load incremental data from table inv.DataOracleDatabaseFeatureUsageStats
Procedure	slm.GetOracleDatabaseInstances	Load incremental data from table inv.DataOracleDatabaseInstance
Procedure	slm.GetOracleDatabaseManagementPacks	Load incremental data from table inv.DataOracleDatabaseMgmtPacks
Procedure	slm.GetOracleDatabaseManagementPacksSummary	Load incremental data from table inv.DataOracleDatabaseMgmtPacksSummary
Procedure	slm.GetOracleDatabaseOptions	Load incremental data from table inv.DataOracleDatabaseOptions
Procedure	slm.GetOracleDatabaseSessions	Load incremental data from table inv.DataOracleDatabaseSessions
Procedure	slm.GetOracleDatabaseUsers	Load incremental data from table inv.DataOracleDatabaseUsers
Procedure	slm.GetServerAddress	Load incremental data from table inv.ServerAddress
Procedure	slm.GetSite	Load possible new SiteNames from inv.DataClient Truncate and load INV table slm.ClientSiteDBMap
Procedure	slm.GetSoftwareSlm	Load incremental data from tables inv.DataApplication and inv.DataWebApplication
Procedure	slm.GetUser	Load incremental data from table inv.DataUserAccount
Procedure	slm.GetWebMetering	Load incremental data from table inv.DataWebAppMetering
Procedure	slm.PutInventorySequenceNumber	Updates table slm.tblInventoryDatabase with data from SnowLicenseManager dbo.tblInventoryDatabase. Activates script inv.MigrateToSLM9 if not run before and initial run is detected.
Synonym	slm.dbo_tblInventoryDatabase	Synonym for table dbo.tblInventoryDatabase Note: All of these synonyms are for the corresponding object in the SnowLicenseManager database.
Synonym	slm.inv_MeteringIndexesDrop	Synonym for procedure inv.MeteringIndexesDrop
Synonym	slm.inv_tblADComputerDiscovery	Synonym for table inv.tblADComputerDiscovery
Synonym	slm.inv_tblADUserDiscovery	Synonym for table inv.tblADUserDiscovery
Synonym	slm.inv_tblAPIKey	Synonym for table inv.tblAPIKey
Synonym	slm.inv_tblApplicationConcurrency	Synonym for table inv.tblApplicationConcurrency
Synonym	slm.inv_tblComputerClient	Synonym for table inv.tblComputerClient
Synonym	slm.inv_tblComputerDisplayAdapter	Synonym for table inv.tblComputerDisplayAdapter
Synonym	slm.inv_tblComputerEnvironment	Synonym for table inv.tblComputerEnvironment
Synonym	slm.inv_tblComputerLogicalDisk	Synonym for table inv.tblComputerLogicalDisk
Synonym	slm.inv_tblComputerMemoryModule	Synonym for table inv.tblComputerMemoryModule
Synonym	slm.inv_tblComputerMemory	Synonym for table inv.tblComputerMemory
Synonym	slm.inv_tblComputerMonitor	Synonym for table inv.tblComputerMonitor
Synonym	slm.inv_tblComputerNetworkAdapter	Synonym for table inv.tblComputerNetworkAdapter
Synonym	slm.inv_tblComputerOperatingSystem	Synonym for table inv.tblComputerOperatingSystem
Synonym	slm.inv_tblComputerPhysicalDisk	Synonym for table inv.tblComputerPhysicalDisk
Synonym	slm.inv_tblComputerPrinter	Synonym for table inv.tblComputerPrinter
Synonym	slm.inv_tblComputerProcessor	Synonym for table inv.tblComputerProcessor
Synonym	slm.inv_tblComputerRegistry	Synonym for table inv.tblComputerRegistry
Synonym	slm.inv_tblComputerSoftwareProduct	Synonym for table inv.tblComputerSoftwareProduct
Synonym	slm.inv_tblComputerSoftware	Synonym for table inv.tblComputerSoftware
Synonym	slm.inv_tblComputerVirtualPackage	Synonym for table inv.tblComputerVirtualPackage
Synonym	slm.inv_tblComputerWith64BitSoftware	Synonym for table inv.tblComputerWith64BitSoftware
Synonym	slm.inv_tblDataCenterClient	Synonym for table inv.tblDataCenterClient
Synonym	slm.inv_tblDataCenterFeature	Synonym for table inv.tblDataCenterFeature
Synonym	slm.inv_tblDataCenterVirtualMachine	Synonym for table inv.tblDataCenterVirtualMachine
Synonym	slm.inv_tblInventoryDatabase	Synonym for table inv.tblInventoryDatabase
Synonym	slm.inv_tblLoginUserClient	Synonym for table inv.tblLoginUserClient
Synonym	slm.inv_tblMetering	Synonym for table inv.tblMetering
Synonym	slm.inv_tblMeteringCloud	Synonym for table inv.tblMeteringCloud
Synonym	slm.inv_tblMobileDeviceProperty	Synonym for table inv.tblMobileDeviceProperty
Synonym	slm.inv_tblOracleDatabase	Synonym for table inv.tblOracleDatabase
Synonym	slm.inv_tblOracleDatabaseFeatureUsageStats	Synonym for table inv.tblOracleDatabaseFeatureUsageStats
Synonym	slm.inv_tblOracleDatabaseInstances	Synonym for table inv.tblOracleDatabaseInstances
Synonym	slm.inv_tblOracleDatabaseManagementPacks	Synonym for table inv.tblOracleDatabaseManagementPacks
Synonym	slm.inv_tblOracleDatabaseManagementPacksSummary	Synonym for table inv.tblOracleDatabaseManagementPacksSummary
Synonym	slm.inv_tblOracleDatabaseOptions	Synonym for table inv.tblOracleDatabaseOptions
Synonym	slm.inv_tblOracleDatabaseSessions	Synonym for table inv.tblOracleDatabaseSessions
Synonym	slm.inv_tblOracleDatabaseUsers	Synonym for table inv.tblOracleDatabaseUsers
Synonym	slm.inv_tblServerAddress	Synonym for table inv.tblServerAddress
Synonym	slm.inv_tblSite	Synonym for table inv.tblSite
Synonym	slm.inv_tblSoftware	Synonym for table inv.tblSoftware
Synonym	slm.inv_tblUser	Synonym for table inv.tblUser
Synonym	slm.inv_tblWebMetering	Synonym for table inv.tblWebMetering
Synonym	slm.slm_tblComputer	Synonym for table dbo.tblComputer
Synonym	slm.slm_tblJobCID	Synonym for table dbo.tblJobCID
Synonym	slm.slm_tblJobStatus	Synonym for table dbo.tblJobStatus
Synonym	slm.slm_tblSoftware	Synonym for table dbo.tblSoftware
Synonym	slm.slm_vSystemSettings	Synonym for view dbo.vSystemSettings

Added SnowLicenseManager DB objects

Object type	Name	Description
Schema	inv	Contains all Data Update Job-related objects
Table	inv.tblADComputerDiscovery	Staging table for delta data loaded from tables inv.DiscoveryMetadata and inv.DiscoveryActiveDirectory using procedure slm.GetADComputerDiscovery
Table	inv.tblADUserDiscovery	Staging table for delta data loaded from tables inv.DiscoveryUserActiveDirectory and inv.DiscoveryUserActiveDirectoryEmail using procedure slm.GetADUserDiscovery
Table	inv.tblApiKey	Staging table for API Key information for SnowInventory DB Delete API calls
Table	dbo.tblApiKey	Final store for API Key information for SnowInventory DB Delete API calls
Table	inv.tblApplicationConcurrency	Staging table for delta data loaded from table inv.DataMeteringConcurrency using procedure slm.GetApplicationConcurrency
Table	dbo.tblComputerClient	Final store for Computer data
Table	inv.tblComputerClient	Staging table for delta data loaded from table inv.DataClient using procedure slm.GetComputerClient
Table	dbo.tblComputerDisplayAdapter	Final store for display adapter data
Table	inv.tblCominv.tblComputerProcessorputerDisplayAdapter	Staging table for delta data loaded from table inv.DataDisplayAdapter using procedure slm.GetComputerDisplayAdapter
Table	inv.tblComputerEnvironment	Staging table for delta data loaded from table inv.DataEnvironmentVariable using procedure slm.GetComputerEnvironment
Table	inv.tblComputerInvSlmMap	Mapping table [InventoryDBID + ClientId] vs. [CID + ComputerId]
Table	dbo.tblComputerLogicalDisk	Final store for logical disk data
Table	inv.tblComputerLogicalDisk	Staging table for delta data loaded from table inv.DataLogicalDisk and inv.DataOperatingSystem using procedure slm.GetComputerLogicalDisk
Table	dbo.tblComputerMemory	Final store for computer memory data
Table	inv.tblComputerMemory	Staging table for delta data loaded from table inv.DataMemory using procedure slm.GetComputerMemory
Table	dbo.tblComputerMemoryModule	Final store for computer memory module data
Table	inv.tblComputerMemoryModule	Staging table for delta data loaded from table inv.DataMemoryModule using procedure slm.GetComputerMemoryModule
Table	dbo.tblComputerMonitor	Final store for computer monitor data
Table	inv.tblComputerMonitor	Staging table for delta data loaded from table inv.DataMonitor using procedure slm.GetComputerMonitor
Table	dbo.tblComputerNetworkAdapter	Final store for computer network adapter data
Table	inv.tblComputerNetworkAdapter	Staging table for delta data loaded from table inv.DataNetworkAdapter using procedure slm.GetComputerNetworkAdapter
Table	dbo.tblComputerOperatingSystem	Final store for computer operating system data
Table	inv.tblComputerOperatingSystem	Staging table for delta data loaded from tables inv.DataOperatingSystem and inv.DataApplication using procedure slm.GetComputerOperatingSystem
Table	dbo.tblComputerPhysicalDisk	Final store for computer physical disk data
Table	inv.tblComputerPhysicalDisk	Staging table for delta data loaded from tables inv.DataPhysicalDisk using procedure slm.GetComputerPhysicalDisk
Table	dbo.tblComputerPrinter	Final store for computer printer driver data
Table	inv.tblComputerPrinter	Staging table for delta data loaded from table _inv.DataPrinter_using procedure slm.GetComputerPrinter
Table	dbo.tblComputerProcessor	Final store for computer processor data
Table	inv.tblComputerProcessor	Staging table for delta data loaded from table inv.DataProcessor using procedure slm.GetComputerProcessor
Table	dbo.tblComputerRegistry	Final store for computer registry data
Table	inv.tblComputerRegistry	Staging table for delta data loaded from table inv.DataCustomRegKey using procedure slm.GetComputerRegistry
Table	dbo.tblComputerSoftwareInstalled	Final store for software installed per computer, including InstallDate
Table	inv.tblComputerSoftwareInstalled	Staging table for delta data loaded from tables inv.DataSoftware, inv.DataGeneratedSoftware and inv.DataApplication using procedure slm.GetComputerSoftwareSlm
Table	dbo.tblComputerSoftwareProduct	Final store for computer software product data
Table	inv.tblComputerSoftwareProduct	Staging table for delta data loaded from table inv.DataSoftwareProduct using procedure slm.GetComputerSoftwareProductSlm
Table	dbo.tblComputerVirtualPackage	Final store for computer virtual software package data
Table	inv.tblComputerVirtualPackage	Staging table for delta data loaded from table inv.VirtualSoftwarePackages using procedure slm.GetComputerVirtualPackage
Table	dbo.tblComputerWith64BitSoftware	Final store for computer virtual software package data.
Table	inv.tblComputerWith64BitSoftware	Staging table for delta data loaded from tables inv.DataSoftware, inv.DataGeneratedSoftware, and inv.DataApplication using procedure slm.GetComputerWith64BitSoftware
Table	dbo.tblDataCenterClient	Final store for computer identified as Data Center clients
Table	inv.tblDataCenterClient	Staging table for delta data loaded from table inv.DataDataCenter using procedure slm.GetDataCenterClient
Table	dbo.tblDataCenterFeature	Final store for identified Data Center features
Table	inv.tblDataCenterFeature	Staging table for delta data loaded from table inv.DataDataCenterFeature using procedure slm.GetDataCenterFeature
Table	dbo.tblDataCenterVirtualMachine	Final store for identified Data Center virtual machines
Table	inv.tblDataCenterVirtualMachine	Staging table for delta data loaded from table inv.DataVirtualMachine using procedure slm.GetDataCenterVirtualMachine
Table	inv.tblDataFlow	System table for storing all dataflows belonging to Data Update Job
Table	inv.tblDataFlowDependency	System table for storing dependencies (run order) between dataflows
Table	inv.tblDataStream	Data Stream name table (Name + Id)
Table	inv.tblDeletedDevicesMap	Table containing all deleted devices. Used for filtering incoming SnowInventory DB device data.
Table	inv.tblHiddenSoftware	Storage for hidden software
Table	dbo.tblInventoryDatabase	System table for storing SnowInventory database configuration and current setting for RowVersion and SequenceNumber, including possible reset requests due to error in previous run
Table	inv.tblInventoryDatabase	System table for storing SnowInventory database configuration and current setting for RowVersion and SequenceNumber
Table	inv.tblInventoryDatabaseLog	Logging table storing the RowVersion and SequenceNumber settings for each Data Update Job run
Table	inv.tblJobParallelStep	System internal table for handling job step sequencing during the Data Update Job run process
Table	dbo.tblLoginUserClient	Final store for user-computer login info
Table	inv.tblLoginUserClient	Staging table for user-computer login info (last logon, logon count)
Table	dbo.tblMetering	Final store for by-day aggregated metering data
Table	inv.tblMetering	Receiving staging table for delta data loaded from SnowInventory database table inv.DataMetering using procedure slm.GetMetering
Table	dbo.tblMeteringCloud	Final store for by-day aggregated web application metering data
Table	inv.tblMeteringCloud	Receiving staging table for delta data loaded from SnowInventory database table inv.DataWebAppMetering using procedure slm.GetWebMetering
Table	dbo.tblMobileDeviceProperty	Final table for mobile device properties
Table	inv.tblMobileDeviceProperty	Receiving staging table for delta data loaded from SnowInventory database table inv.DataMobileDeviceProperties using procedure slm.GetMobileDeviceProperty
Table	inv.tblOracleDatabase	Receiving staging table for delta data loaded from SnowIventory database table inv.DataOracleDatabase using procedure slm.GetOracleDatabase
Table	inv.tblOracleDatabaseFeatureUsageStats	Receiving staging table for delta data loaded from SnowInventory database tables inv.DataOracleDatabaseFeatureUsageStats using procedure slm.GetOracleDatabaseFeatureUsageStats
Table	inv.tblOracleDatabaseInstances	Receiving staging table for delta data loaded from SnowInventory database table inv.DataOracleDatabaseInstance using procedure slm.GetOracleDatabaseInstances
Table	inv.tblOracleDatabaseManagementPacks	Receiving staging table for delta data loaded from SnowInventory database table inv.DataOracleDatabaseMgmtPacks using procedure slm.GetOracleDatabaseManagementPacks
Table	inv.tblOracleDatabaseManagementPacksSummary	Receiving staging table for delta data loaded from SnowInventory database table inv.DataOracleDatabaseMgmtPacksSummary using procedure slm.GetOracleDatabaseManagementPacksSummary
Table	inv.tblOracleDatabaseOptions	Receiving staging table for delta data loaded from SnowInventory database tables inv.DataOracleDatabaseOptions using procedure slm.GetOracleDatabaseOptions
Table	inv.tblOracleDatabaseSessions	Receiving staging table for delta data loaded from SnowInventory database table inv.DataOracleDatabaseSessions using procedure slm.GetOracleDatabaseSessions
Table	inv.tblOracleDatabaseUsers	Receiving staging table for delta data loaded from SnowInventory database table inv.DataOracleDatabaseUsers using procedure slm.GetOracleDatabaseUsers
Table	dbo.tblQuarantineComputer	Table storing quarantined computers with ActionCode in {ReActivated, Quarantined, Quarantine Set Inactive, Quarantine Delete, No Op, Quarantine Off} and StatusCode in {0 (Active), 1 (Quarantined), 2 (Delete)}
Table	dbo.tblQuarantineDeviceInfo	Table storing quarantined devices with ActionCode in {ReActivated, Quarantined, QuarantinedDelete, No Op, Quarantine Off} and StatusCode in {0 (Active), 1 (Quarantined), 2 (Delete)}
Table	dbo.tblQuarantineUser	Table storing quarantined users with ActionCode in {ReActivated, Quarantined, QuarantinedDelete, No Op, QUARANTINEOFF} and StatusCode in {0 (Active), 1 (Quarantined)}
Table	dbo.tblServerAddress	Receiving staging table for delta data loaded from SnowInventory database table inv.ServerAddress using procedure slm.GetServerAddress
Table	inv.tblServerAddress	Receiving staging table for delta data loaded from SnowInventory database table inv.ServerAddress using procedure slm.GetServerAddress
Table	inv.tblSite	Receiving staging table for delta data loaded from SnowInventory database tables inv.DataClient and inv.DiscoveryUserMetadata using procedure slm.GetSite
Table	inv.tblSoftware	Receiving staging table for delta data loaded from SnowInventory database tables inv.DataOperatingSystem, inv.DataSoftware, inv.DataWebApplication, and inv.DataGeneratedSoftware using procedure slm.GetSoftwareSlm
Table	inv.tblSynonym	SnowInventory database synonym mapping table, containing synonym name and SnowLicenseManager database table name to which the synonym maps
Table	inv.tblUser	Receiving staging table for delta data loaded from SnowInventory database tables inv.DataUserAccount and inv.DataMetering using procedure slm.GetUser
Table	inv.tblUserInvSlmMap	Mapping table for user mapping from SnowInventory UserID (INV_UserID) to SnowLicenseManager UserID (SLM_UserID). SLM_UserID = 0 means that user has been deleted and should also have a timestamp in column DeletedDate
Table	dbo.tblUsersDeleted	Table storing users that have been deleted in SnowLicenseManager database. Table is used by new delete API to forward deletes to SnowInventory database. When deletes have been pushed to API, the corresponding users are removed from this cache table
Table	inv.tblWebMetering	Receiving staging table for delta data loaded from SnowInventory database table inv.DataWebAppMetering using procedure slm.GetWebMetering
View	dbo.vSourceRootOrganization	Simple view to hold Root and DefaultOrgChecksum values per SourceId.
View	dbo.vSystemSettings	Simple view showing system settings from tables dbo.tblSystemSettings and dbo.tblSystemSettingsDefault in a manner that is easy to code in T-SQL by separating date values from bit and integer values
Stored Procedure	dbo.JobInventoryGetInventoryData	Main procedure for running Data Update Job. Needs @DataStreamName (MainStream or ConfigStream) parameter to run. Truncates all staging tables and executes sp_start_job for all available (non-dependent) DataFlows. Run order is controlled through table inv.tblJobParallelStep. After waiting @DelayLength, the process is reiterated until all dependent jobs have been run.
Stored Procedure	dbo.JobInventoryWebApplicationUpdate	Procedure adding updated data from inv.tblWebMetering to tables dbo.tblApplication, dbo.tblApplicationRule, and dbo.tblApplicationInfo
Stored Procedure	dbo.JobLogErrorState	Procedure to add error information in all relevant tables (inv.tblJobParallelStep, dbo.tblJobLog, and dbo.tblJobStatus) if an error occurs
Stored Procedure	inv.MeteringIndexesCreate	Procedure to re-create indexes in inv.tblMetering after initial load (it’s faster to drop and recreate indexes than to continuously update them in the huge initial load insert)
Stored Procedure	inv.MeteringIndexesDrop	Procedure to drop indexes in inv.tblMetering before initial load (it’s faster to drop and recreate indexes than to continuously update them in the huge initial load insert)
Stored Procedure	dbo.QuarantineDeleteComputer	Procedure to delete computers from all correlated tables that have been quarantined and then reach status Quarantine Delete
Stored Procedure	dbo.QuarantineDeleteDeviceInfo	Procedure to delete devices from all correlated tables that have been quarantined and then reach status Quarantine Delete
Stored Procedure	dbo.QuarantineDeleteUser	Procedure to delete users from all correlated tables that have been quarantined and then reach status Quarantine Delete
Stored Procedure	inv.UpdateADComputerDiscovery	Procedure to update table dbo.tblComputerDiscovery with new data from staging table inv.tblADComputerDiscovery
Stored Procedure	inv.UpdateADUserDiscovery	Procedure to update table dbo.tblUserDiscovery with new data from staging table inv.tblADUserDiscovery. In the second step, dbo.tblUser is updated with Email and ObjectId from dbo.tblUserDiscovery.
Stored Procedure	inv.UpdateAPIKey	Replaces the information in dbo.tblAPIKey with newly imported data from inv.tblAPIKey
Stored Procedure	inv.UpdateClientComputerMap	Updates table inv.tblComputerInvSlmMap with new data from table inv.tblComputerClient. The process applies unit capping depending on license type and only allows one mapping per SnowInventory database client.
Stored Procedure	inv.UpdateComputerClient	Updates dbo.tblComputerClient with new data from table inv.tblComputerClient. (Computers that have previously been deleted in Snow License Manager are not mapped again, even if the Delete API has not yet run).
Stored Procedure	inv.UpdateComputerDisplayAdapter	Updates table dbo.tblComputerDisplayAdapter with new data from staging table inv.tblComputerDisplayAdapter
Stored Procedure	inv.UpdateComputerEnvironment	Updates table dbo.tblComputerEnvironment with new data from staging table inv.tblComputerEnvironment
Stored Procedure	inv.UpdateComputerLogicalDisk	Updates table dbo.tblComputerLogicalDisk with new data from staging table inv.tblComputerLogicalDisk
Stored Procedure	inv.UpdateComputerMemory	Updates table dbo.tblComputerMemory with new data from staging table inv.tblComputerMemory
Stored Procedure	inv.UpdateComputerMemoryModule	Updates table dbo.tblComputerMemoryModule with new data from staging table inv.tblComputerMemoryModule
Stored Procedure	inv.UpdateComputerMonitor	Updates table dbo.tblComputerMonitor with new data from staging table inv.tblComputerMonitor
Stored Procedure	inv.UpdateComputerNetworkAdapter	Updates table dbo.tblComputerNetworkAdapter with new data from staging table inv.tblComputerNetworkAdapter
Stored Procedure	inv.UpdateComputerOperatingSystem	Updates table dbo.tblComputerOperatingSystem with new data from staging table inv.tblComputerOperatingSystem
Stored Procedure	inv.UpdateComputerPhysicalDisk	Updates table dbo.tblComputerPhysicalDisk with new data from staging table inv.tblComputerPhysicalDisk
Stored Procedure	inv.UpdateComputerPrinter	Updates table dbo.tblComputerPrinter with new data from staging table inv.tblComputerPrinter
Stored Procedure	inv.UpdateComputerProcessor	Updates table dbo.tblComputerProcessor with new data from staging table inv.tblComputerProcessor
Stored Procedure	inv.UpdateComputerRegistry	Updates table dbo.tblComputerRegistry with new data from staging table inv.tblComputerRegistry
Stored Procedure	inv.UpdateComputerSoftwareInstalled	Updates table dbo.tblComputerSoftwareInstalled with new data from staging table inv.tblComputerSoftwareInstalled
Stored Procedure	inv.UpdateComputerSoftwareProduct	Updates table dbo.tblComputerSoftwareProduct with new data from staging table inv.tblComputerSoftwareProduct
Stored Procedure	inv.UpdateComputerVirtualPackage	Updates table dbo.tblComputerVirtualPackage with new data from staging table inv.tblComputerVirtualPackage
Stored Procedure	inv.UpdateComputerWith64BitSoftware	Updates table dbo.tblComputerWith64BitSoftware with new data from staging table inv.tblComputerWith64BitSoftware
Stored Procedure	inv.UpdateDataCenterClient	Updates table dbo.tblDataCenterClient with new data from staging table inv.tblDataCenterClient
Stored Procedure	inv.UpdateDataCenterFeature	Updates table dbo.tblDataCenterFeature with new data from staging table inv.tblDataCenterFeature
Stored Procedure	inv.UpdateDataCenterVirtualMachine	Updates table dbo.tblDataCenterVirtualMachine with new data from staging table inv.tblDataCenterVirtualMachine
Stored Procedure	inv.UpdateInventoryDatabase	Updates table dbo.tblInventoryDatabase with new data from staging table inv.tblInventoryDatabase. Also handles reset of SequenceNumber and RowVersion in case of previous Data Update Job run error.
Stored Procedure	inv.UpdateLoginUserClient	Updates table dbo.tblLoginUserClient with new data from staging table inv.tblLoginUserClient
Stored Procedure	inv.UpdateMetering	Updates table dbo.tblMetering with new data from staging table inv.tblMetering. Also creates indexes, if necessary (such as after initial run).
Stored Procedure	inv.UpdateMeteringCloud	Updates table dbo.tblMeteringCloud with new data from staging table inv.tblMeteringCloud
Stored Procedure	inv.UpdateMobileDeviceProperty	Updates table dbo.tblMobileDeviceProperty with new data from staging table inv.tblMobileDeviceProperty
Stored Procedure	inv.UpdateOracleDatabase	Updates table dbo.tblOracleDatabase and dbo.tblOracleDatabaseServers with new data from staging table inv.tblOracleDatabase. Also deletes Oracle databases that excede the ORACLE_DELETE_THRESHOLD system setting and their corresponding data from the other Oracle* tables.
Stored Procedure	inv.UpdateOracleDatabaseFeatureUsageStats	Updates table dbo.tblOracleDatabaseFeatureUsageStats with new data from staging table inv.tblOracleDatabaseFeatureUsageStats
Stored Procedure	inv.UpdateOracleDatabaseInstances	Updates table dbo.tblOracleDatabaseInstances with new data from staging table inv.tblOracleDatabaseInstances. Oracle capping validation is in effect.
Stored Procedure	inv.UpdateOracleDatabaseManagementPacks	Updates table dbo.tblOracleDatabaseManagementPacks with new data from staging table inv.tblOracleDatabaseManagementPacks
Stored Procedure	inv.UpdateOracleDatabaseManagementPacksSummary	Updates table dbo.tblOracleDatabaseManagementPacksSummary with new data from staging table inv.tblOracleDatabaseManagementPacksSummary
Stored Procedure	inv.UpdateOracleDatabaseOptions	Updates table dbo.tblOracleDatabaseOptions with new data from staging table inv.tblOracleDatabaseOptions
Stored Procedure	inv.UpdateOracleDatabaseSessions	Updates table dbo.tblOracleDatabaseSessions with new data from staging table inv.tblOracleDatabaseSessions
Stored Procedure	inv.UpdateOracleDatabaseUsers	Updates table dbo.tblOracleDatabaseUsers with new data from staging table inv.tblOracleDatabaseUsers
Stored Procedure	inv.UpdateQuarantinetblComputer	Main quarantine-handling procedure for computers. Updates column QuarantineDate and StatusCode in dbo.tblComputer. Updates table dbo.tblQuarantineComputer. Sets StatusCode in dbo.tblComputerInfo. Calls procedure dbo.QuarantineDeleteComputer.
Stored Procedure	inv.UpdateQuarantinetblDeviceInfo	Main quarantine-handling procedure for devices. Updates columns QuarantineDate and StatusCode in dbo.tblDeviceInfo. Updates table dbo.tblQuarantineDeviceInfo. Calls procedure dbo.QuarantineDeleteDeviceInfo.
Stored Procedure	inv.UpdateQuarantinetblUser	Main quarantine-handling procedure for users. Updates column QuarantineDate and StatusCode in dbo.tblUser. Updates table dbo.tblQuarantineUser. Calls procedure dbo.QuarantineDeleteUser.
Stored Procedure	inv.UpdateServerAddress	Truncates and inserts into table dbo.tblServerAddress new data from staging table inv.tblServerAddress
Stored Procedure	inv.UpdatetblComputer_Client	Updates table dbo.tblComputer with new data from staging table inv.tblComputer. Sets new _ComputerID_s in table inv.tblComputerInvSlmMap. Updates HostComputerID column in table dbo.tblComputer. Prepares table dbo.tblComputerHardware with 0-filled columns for later update (see the three dbo.UpdatetblComputerHardware* procedures below). Updates table dbo.tblComputerHostHistory. Adds default settings to table dbo.tblCustomFieldValue.
Stored Procedure	inv.UpdatetblComputer_IPAddress	Updates column IPAddress in table dbo.tblComputer with a comma-separated list of IP addresses. Replaces possible NULL values with empty string ‘’ in columns IsServer, IPAddress, OSServicePack, and Domain.
Stored Procedure	inv.UpdatetblComputer_OperatingSystem	Updates columns Domain, OperatingSystem, OSServicePack, OSSerial, and IsServer in table dbo.tblComputer. Also replaces possible NULL values with empty string ‘’ in columns IsServer, IPAddress, OSServicePack, and Domain.
Stored Procedure	inv.UpdatetblComputer_With64BitSoftware	Updates column Is64bit in table dbo.tblComputer, based on collective information from the three sources dbo.tblComputerWith64BitSoftware, dbo.tblComputerOperatingSystem, and dbo.tblComputerClient
Stored Procedure	inv.UpdatetblComputerHardware_LogicalDisk	Updates columns SystemDiskSpace, SystemDiskSpaceAvailable, TotalDiskSpace, and TotalDiskSpaceAvailable in table dbo.tblComputerHardware
Stored Procedure	inv.UpdatetblComputerHardware_Memory	Updates columns MemorySlots, MemorySlotsAvailable, and PhysicalMemory in table dbo.tblComputerHardware
Stored Procedure	inv.UpdatetblComputerHardware_Processor	Updates columns ProcessorCount, CoreCount, ProcessorType, ProcessorSpeed, SocketCountManualOverrideEnabled (=0), and ProcessorManufacturer in table dbo.tblComputerHardware from table dbo.tblComputerProcessor
Stored Procedure	inv.UpdatetblComputerInfo	Updates column OrgChecksum in table dbo.tblComputerInfo. Inserts applicable data from dbo.tblComputerInBox and dbo.tblCIDActionLog to dbo.tblComputerInfo. Updates column SRComputerID in table dbo.tblComputer.
Stored Procedure	inv.UpdatetblSite	Adds valid CID mappings from dbo.tblJobCID to inv.tblSite
Stored Procedure	inv.UpdatetblSoftware	Adds new software rows from table inv.tblSoftware to table dbo.tblSoftware
Stored Procedure	inv.UpdatetblUser	Updates table inv.tblUserInvSlmMap with new mappings between SnowInventory _UserID_s and SnowLicenseManager _UserID_s. Also adds new users from inv.tblUser to dbo.tblUser. Updates column LastLogon (if applicable) from table inv.tblLoginUserClient.
Function	dbo.SplitString	SQL community standard function to create a column of split strings from a delimited string

Changed SnowLicenseManager DB objects

Object type	Name	Change	Description
Table	dbo.tblApplicationConcurrencyWork	DROP COLUMN	H0 … H23
Table	dbo.tblApplicationConcurrencyWork	ADD COLUMN	ConcurrencyMask INT
Table	dbo.tblCIDDataSource	ADD COLUMN	ApiSourceID UNIQUEIDENTIFIER NULL
Table	dbo.tblComputer	DROP COLUMN	ClientId IsASL Is64bit Architecture
Table	dbo.tblComputer	ADD COLUMN	Is64bit BIT NOT NULL Architecture
Table	dbo.tblComputerApplications	DROP COLUMN	CVDiscard MultiVersionCoverage VDICoverage NamedComputerCoverage NamedUserCoverage
Table	dbo.tblComputerEnvironment	DROP COLUMN	SourceID RowID
Table	dbo.tblComputerEnvironment	DROP INDEX	Primary Key (CID, RowID, SourceID, ComputerID)
Table	dbo.tblComputerEnvironment	ADD COLUMN	Updated BIT DEFAULT (1)
Table	dbo.tblComputerHardware	ADD DEFAULT	MemorySlots MemorySlotsAvailable PhysicalMemory
Table	dbo.tblComputerHardware	DROP COLUMN	NetworkAdapters OpticalDrives DisplayAdapters Monitors LogicalDisks
Table	dbo.tblComputerRegistry	DROP COLUMN	SourceID RowID
Table	dbo.tblComputerRegistry	ALTER COLUMN	KeyName 400 -> 240 ValueName 2048 -> 200
Table	dbo.tblComputerRegistry	DROP INDEX	Primary Key (CID, RowID, SourceID, ComputerID)
Table	dbo.tblComputerRegistry	CREATE INDEX	Primary Key (ValueName, KeyName, ComputerID, CID)
Table	dbo.tblComputersDeleted	ADD COLUMN	InventoryDBID INT NOT NULL
Table	dbo.tblDCC	ADD COLUMN	HypervisorType INT HighAvailability BIT DEFAULT (0) VmwareDRS BIT DEFAULT (0)
Table	dbo.tblDeviceApplications	DROP COLUMN	CVDiscard
Table	dbo.tblDevicesDeleted	ADD COLUMN	ServerClientID INT NOT NULL InventoryDBID INT NOT NULL
Table	dbo.tblDevicesDeleted	ALTER COLUMN	DeviceName NVARCHAR(100) NULL
Table	dbo.tblIndex	ADD COLUMN	SchemaName SYSNAME
Table	dbo.tblOracleDatabase	DROP COLUMN	SourceID
Table	dbo.tblOracleDatabaseFeatureUsageStats	ALTER COLUMN	Name NVARCHAR(100)
Table	dbo.tblOracleDatabaseUsers	ALTER COLUMN	UserName COLLATE SQL_Latin1_General_CP1_CS_AS
Table	dbo.tblSoftware	ADD COLUMN	IsTS BIT NOT NULL IsVT BIT NOT NULL
Table	dbo.tblSoftwareApplicationMap	ADD COLUMN	IsExcluded BIT NOT NULL
Table	dbo.tblSoftwareCID	DROP COLUMN	PlatformID
Table	dbo.tblSystemCustomProcedures	ADD COLUMN	Status BIT
View	dbo.rptComputers	ALTER VIEW	NetworkAdapters OpticalDrives DisplayAdapters Monitors LogicalDisks (show value NULL)
View	dbo.RsApiComputerOsUsage	DROP COLUMN	CVDiscard
View	dbo.RsApiComputersHardware	ALTER VIEW	NetworkAdaptersTxt OpticalDrivesTxt DisplayAdaptersTxt MonitorsTxt LogicalDisksTxt (all columns reference new database objects)
View	dbo.RsApiComputerUsage	DROP COLUMN	CVDiscard
View	dbo.RsApiMobileDeviceDetail	ALTER VIEW	Changed reference to table dbo.tblMobileDeviceProperty
View	dbo.RsApiMobileDevices	ALTER VIEW	Changed reference to dbo.tblMobileDeviceProperty
View	dbo.RsWebApplicationComputers	DROP COLUMN	CVDiscard MultiVersionCoverage NamedComputerCoverage NamedUserCoverage IsVDI
View	dbo.RsWebApplicationDevices	DROP COLUMN	CVDiscard
View	dbo.RsWebApplicationOsComputers	DROP COLUMN	CVDiscard NamedComputerCoverage NamedUserCoverage IsVDI
View	dbo.RsWebApplicationUsers	ALTER VIEW	NamedUserCoverage (column removed from GROUP BY clause)
View	dbo.RsWebComputerApplications	DROP COLUMN	MultiVersionCoverage CVDiscard VDICoverage
View	dbo.RsWebComputerHardware	ALTER VIEW	NetworkAdapters OpticalDrives DisplayAdapters Monitors LogicalDisks (columns listed show NULL values)
View	dbo.rptComputers	ALTER VIEW	NetworkAdapters  OpticalDrives   DisplayAdapters   Monitors   LogicalDisks (listed columns have changed to show NULL, pending rewriting to reference new objects)
View	dbo.viewReportComputersComplete	DROP COLUMN	ClientID
View	dbo.viewSoftware_SoftwareCID	DROP COLUMN / ALTER VIEW	RowNumber
Stored Procedure	dbo.ApplicationGet	DROP COLUMN	IsVDI CVDiscard
Stored Procedure	dbo.ApplicationInfoAddUpdate	DML UPDATE	CVDiscard
Stored Procedure	dbo.ApplicationPeriodSummaryRefresh	DML UPDATE	CVDiscard
Stored Procedure	dbo.ApplicationRuleApply	DML UPDATE	Dropped variable @RuleAND (not used in SP)
Stored Procedure	dbo.ApplicationRuleApplyOnChanges	DML UPDATE	New column inv.tblSoftware.HasRuleApplied Replaced table dbo.tblSoftwareStage with new table inv.tblSoftware
Stored Procedure	dbo.ComputerDelete	DML UPDATE	Dropped variable @ClientID Removed CVDiscard update
Stored Procedure	dbo.ComputerDetailsDataGet	DROP COLUMN	ClientID CVDiscard
Stored Procedure	dbo.ComputerDetailsDataGet	DML UPDATE	NetworkAdapters OpticalDrives DisplayAdapters Monitors LogicalDisks (changed sources from dbo.tblComputerHardware table to new dbo.tblComputer* tables; changed to singular form for name-changed tables)
Stored Procedure	dbo.ComputerDetailsSearch	DROP COLUMN	ClientID
Stored Procedure	dbo.ComputerDetailsSummaryGet	DROP COLUMN	ClientID
Stored Procedure	dbo.ComputerInfoAddUpdate	DML UPDATE	Removed SET CVDiscard = NULL
Stored Procedure	dbo.ComputerList	DROP COLUMN	ClientID
Stored Procedure	dbo.ComputerManuallyAddUpdate	DROP COLUMN	ClientID IsASL
Stored Procedure	dbo.ComputerPrinterList	DML UPDATE	Changed reference to dbo.tblComputerPrinter
Stored Procedure	dbo.ComputerSecondaryUseRightsUpdate	DML UPDATE	Removed SET CVDiscard = NULL Removed SET CVDiscard = 1 Removed SET CVDiscard = 0
Stored Procedure	dbo.DccList	ADD COLUMN	HypervisorType HighAvailability VmwareDRS
Stored Procedure	dbo.DeviceInfoDelete	DML UPDATE	Added columns ServerClientID and InventoryDBID to procedure
Stored Procedure	dbo.DeviceInfoMultiDelete	DML UPDATE	Stores multiple deleted device information in dbo.tblDevicesDeleted and inv.tblDeletedDevicesMap to handle device deletion in SnowInventory
Stored Procedure	dbo.GetComputerDetailsApplication	DML UPDATE	Added ISNULL_(IsInstalled, 0)_ (fix for NULL values causing Computer details page to  crash)
Stored Procedure	dbo.JobActivateCIDs	DML UPDATE	Minor changes, such as adding schema to tables
Stored Procedure	dbo.JobAdd	DML UPDATE	Moved job steps into dataflow structure Added new reference for variable @Owner to use dbo.tblSystemInfo.LicenseManagerUser
Stored Procedure	dbo.JobApplicationUsageUpdate	DML UPDATE	Removed column CVDiscard from WHERE clause
Stored Procedure	dbo.JobApplicationValidation	DML UPDATE	Removed CURSOR from table dbo.tblLicense, column ApplicationID update
Stored Procedure	dbo.JobEnd	DML UPDATE	Removed REBUILD_INDEXES_DAY System Setting Removed call to dbo.JobShrinkDB procedure Removed call to dbo.JobRebuildIndexes procedure Added DataStream dependency to reduce number of steps run in DataStream ConfigStream
Stored Procedure	dbo.JobExecuteCustomProcedures	DML UPDATE	Added reference to new column Status in table dbo.tblSystemCustomProcedures (only run custom procedures that do not cause Data Update Job to crash; that is, Status = 0, whereas Status = 1 means custom procedure is disabled due to crash condition)
Stored Procedure	dbo.JobIdentifyVDIComputers	DML UPDATE	Dropped VDICoverage column update (dropped from table dbo.tblComputerApplications) Dropped CVDiscard column
Stored Procedure	dbo.JobInventoryApplicationConcurrencyUpdate	DML UPDATE	Removed CURSOR in loading dbo.tblApplicationConcurrencyWork table Removed CHECKPOINTs
Stored Procedure	dbo.JobInventoryComputerAppHistoryUpdate	DML UPDATE	Removed CURSOR in loading work table
Stored Procedure	dbo.JobInventoryComputerSoftwareBundlesUpdate	DML UPDATE	Changed reference of Updated from dbo.tblComputer to new table dbo.tblComputerClient
Stored Procedure	dbo.JobInventoryComputerSoftwareGroupsUpdate	DML UPDATE	Changed reference of Updated from dbo.tblComputer to new table dbo.tblComputerClient
Stored Procedure	dbo.JobInventoryComputerSoftwareProductUpdate	DML UPDATE	Removed CURSOR in loading work table Changed reference of Updated from dbo.tblComputer to new table dbo.tblComputerClient
Stored Procedure	dbo.JobInventoryComputerSoftwarePVUMetricsUpdate	DML UPDATE	Removed CURSOR in loading work table
Stored Procedure	dbo.JobInventoryComputerSoftwareUpdate	DML UPDATE	Removed CURSOR in loading work table
Stored Procedure	dbo.JobInventoryDCCUpdate	DML UPDATE	Removed CURSOR in loading work table Removed dynamic SQL handling
Stored Procedure	dbo.JobInventoryDeviceApplicationBundlesUpdate	DML UPDATE	CVDiscard dropped from update Changed reference of Updated from dbo.tblComputer to new table dbo.tblComputerClient
Stored Procedure	dbo.JobInventoryDeviceApplicationGroupsUpdate	DML UPDATE	Changed reference of Updated from dbo.tblComputer to new table dbo.tblComputerClient
Stored Procedure	dbo.JobInventoryDeviceApplicationsUpdate	DML UPDATE	Removed metering history handling (Inv 3 only) Removed Quarantine handling INSERT dbo.tblDeviceApplications rewritten Removed dynamic SQL Removed CURSOR
Stored Procedure	JobInventoryRemoveClients	DML UPDATE	Removed Checkpoint handling
Stored Procedure	dbo.JobInventorySoftwareApplyAllRules	DML UPDATE	Removed Checkpoint handling Minor clean-up of code according to ANSI standards
Stored Procedure	dbo.JobInventorySoftwareApplyRules	DML UPDATE	Table dbo.tblSoftwareStage replaced with inv.tblSoftware Removed rebuild index for table dbo.tblSoftware Removed Checkpoint handling Minor clean-up of code according to ANSI standards
Stored Procedure	dbo.JobInventoryStructureUpdate	DML UPDATE	Dropped all Transfer* tables from SnowInventory Dropped table dbo.MeteringWork in SnowInventory
Stored Procedure	dbo.JobInventoryUpdateMigratedDataSources	DML UPDATE	Removed update of column ClientID in table dbo.tblComputer
Stored Procedure	dbo.JobLogAddUpdate	DML UPDATE	Added functionality for logging the finishing time from parallel running job steps
Stored Procedure	dbo.JobMaintenance	DML UPDATE	Removed DBCC SHRINKDATABASE statement Removed rebuild indexes statements Added synonym creation statements Added deletion of old non-scheduled jobs Added creation of currently configured non-scheduled jobs Added check for existing number of active CIDs > 0 Added version check for all connected SnowInventory databases Added logging of dbo.tblInventoryDatabase
Stored Procedure	dbo.JobRun	DML UPDATE	Dropped all Mode handling in procedure Dropped delta run functionality
Stored Procedure	dbo.JobStart	DML UPDATE	Dropped System Setting INVENTORY_TRANSFER_DATE_OFFSET (@DataOffset == 1)
Stored Procedure	dbo.JobStatus	DML UPDATE	Changed job owner from sa to _dbo.tblSystemInfo.LicenseManagerUse_r
Stored Procedure	dbo.JobUpdateMetrics	DML UPDATE	Switched reference to (singular) dbo.tblComputerPrinter Switched to use security allowed view sys.database_files for reading database size Use new dbo.tblComputerClient table for counting number of updated computers
Stored Procedure	dbo.MobileDetailsSearch	DML UPDATE	Changed table name to dbo.tblMobileDeviceProperty
Stored Procedure	dbo.MobileDeviceDetailsDataGet	DML UPDATE	Changed table name to dbo.tblMobileDeviceProperty
Stored Procedure	dbo.MobileDeviceList	DML UPDATE	ClientId Architecture
Stored Procedure	dbo.StockReportComputerHardwareReport	DML UPDATE	Updated columns NetworkAdapterPhysicalAddressString and DisplayAdapters to use new tables
Stored Procedure	dbo.StockReportCustomFieldsPerMobileDevice	DML UPDATE	Changed table name to dbo.tblMobileDeviceProperty
Stored Procedure	dbo.StockReportMobileDeviceHardwareReport	DML UPDATE	Updated column NetworkAdapters to use new table dbo.tblComputerNetworkAdapter
Stored Procedure	dbo.StockReportPrintersPerComputer	DML UPDATE	Changed reference to (singular) table dbo.tblComputerPrinter Added schema to table references
Stored Procedure	dbo.StockReportVirtualAppPackagesPerComputer	DML UPDATE	Changed table name to dbo.tblComputerVirtualPackage
Stored Procedure	dbo.UserDelete	DML UPDATE	Removed call to dbo.UserInventorySourceDelete procedure Added usage of dbo.tblUserDeleted table
Stored Procedure	dbo.ValidateIndexProperties	DML UPDATE	Added SchemaName column