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.

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

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)

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>, 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

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.DataPrinterusing 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 ComputerIDs 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 UserIDs and SnowLicenseManager UserIDs. 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

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.LicenseManagerUser

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