[en] DB changes due to Data Update Job modifications

[en] 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.

[en] Object type

[en] Name

[en] Replaced by object in SnowLicenseManager DB

[en] Table

[en] inv.TransferComputers

[en] inv.tblComputer* (multiple tables)

Note

[en] The asterisk character— * —denotes wild card.

[en] Table

[en]

[en] inv.tblSoftware

[en] Table

[en]

[en] Replaced by new column IsExcluded in table dbo.tblSoftwareApplicationMap

[en] Table

[en]

[en] inv.tblUser/inv.tblUserInfo

[en] Object type

[en] Name

[en] Replaced by object in SnowLicenseManager DB

[en] Table

[en]

[en] Replaced with table dbo.tblComputerPrinter (singular form)

[en] Table

[en]

[en] Replaced with table dbo.tblComputerVirtualPackage (singular form)

[en] Table

[en]

[en] (obsolete)

[en] Table

[en]

[en] Replaced by table dbo.tblMobileDeviceProperty (singular form)

[en] Table

[en] dbo.tblSoftwareSearch

[en] (obsolete)

[en] Table

[en] dbo.tblSoftwareStage

[en] (obsolete)

[en] Table

[en] dbo.tblUserSourceMap

[en] Replaced by new mapping table inv.tblUserInvSlmMap

[en] Stored Procedure

[en] dbo.JobExecute

[en] (obsolete)

[en] Stored Procedure

[en] dbo.JobInventoryActiveDirectoryUpdate

[en] (obsolete)

[en] Stored Procedure

[en] dbo.JobExecute

[en] (obsolete)

[en] Stored Procedure

[en] dbo.JobInventoryComputerListUpdate

[en] (obsolete)

[en] Stored Procedure

[en] dbo.JobInventoryComputersUpdate

[en] (obsolete)

[en] Stored Procedure

[en] dbo.JobInventoryMapSoftwareApplications

[en] (obsolete)

[en] Stored Procedure

[en] dbo.JobInventorySoftwareUpdate

[en] (obsolete)

[en] Stored Procedure

[en] dbo.JobInventoryUserListUpdate

[en] (obsolete)

[en] Stored Procedure

[en] dbo.JobInventoryUsersUpdate

[en] (obsolete)

[en] Stored Procedure

[en] dbo.JobRebuildIndexes

[en] (obsolete)

[en] Stored Procedure

[en] dbo.JobShrinkDB

[en] (obsolete)

[en] Stored Procedure

[en] dbo.SoftwareSearchRefresh

[en] (obsolete)

[en] Stored Procedure

[en] dbo.UserQuarantineDelete

[en] Replaced with new procedure dbo.QuarantineDeleteUser

[en] View

[en] dbo.viewReportComputersComplete

[en] (obsolete)

[en] View

[en] dbo.vMultiVersionCoverage

[en] (obsolete)

[en] View

[en] dbo.tblInventoryMetering

[en] (obsolete)

[en] Stored Procedure

[en] dbo.AddIndexToMetering

[en] (obsolete)

[en] Object type

[en] Name

[en] Description

[en] Schema

[en]

[en] Contains all Data Update Job-related objects

[en] Table

[en]

[en] History table for storing data already transferred to SnowLicenseManager DB

[en] Table

[en]

[en] History table for storing data already transferred to SnowLicenseManager DB

[en] Table

[en]

[en] Map Client to Site by Id, references table inv.tblSite in SnowLicenseManager DB

[en] Table

[en]

[en] Stores DatabaseId (references table inv.tblInventoryDatabase in SnowLicenseManager DB) and current SequenceNumber and RowVersion information. Used for incremental load from INV to SLM.

[en] Table

[en]

[en] Simple mapping table containing strings to be replaced with <empty string>, such as unknown, none, and so on

[en] Procedure

[en]

[en] Move transferred Metering data from inv.DataMetering to *_History table.

[en] Procedure

[en]

[en] Move transferred MeteringConcurrency data from inv.DataMeteringConcurrency to *_History table.

[en] Procedure

[en]

[en] Load incremental data from table inv.DiscoveryMetadata

[en] Procedure

[en]

[en] Load incremental data from table inv.DiscoveryUserActiveDirectory

[en] Procedure

[en]

[en] Load incremental data from table inv.APIKey

[en] Procedure

[en]

[en] Load incremental data from table inv.DataMeteringConcurrency/-History

[en] Procedure

[en]

[en] Load incremental data from table inv.DataClient

[en] Procedure

[en]

[en] Load incremental data from table inv.DataDisplayAdapter

[en] Procedure

[en]

[en] Load incremental data from table inv.DataEnvironmentVariable

[en] Procedure

[en]

[en] Load incremental data from table inv.DataLogicalDisk

[en] Procedure

[en]

[en] Load incremental data from table inv.DataMemory

[en] Procedure

[en]

[en] Load incremental data from table inv.DataMemoryModule

[en] Procedure

[en]

[en] Load incremental data from table inv.DataMonitor

[en] Procedure

[en]

[en] Load incremental data from table inv.DataNetworkAdapter

[en] Procedure

[en]

[en] Load incremental data from table inv.DataOperatingSystem

[en] Procedure

[en]

[en] Load incremental data from table inv.DataPhysicalDisk

[en] Procedure

[en]

[en] Load incremental data from table inv.DataPrinter

[en] Procedure

[en]

[en] Load incremental data from table inv.DataProcessor

[en] Procedure

[en]

[en] Load incremental data from table inv.DataCustomRegKey

[en] Procedure

[en] slm.GetComputerSoftwareProductSlm

Note

[en] 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.

[en] Load incremental data from table inv.DataSoftwareProduct

[en] Procedure

[en] slm.GetComputerSoftwareSlm

Note

[en] 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.

[en] Load incremental data from table inv.DataSoftware

[en] Procedure

[en]

[en] Load incremental data from table inv.DataVirtualSoftwarePackages

[en] Procedure

[en]

[en] Identifying through application pathnames (inv.DataSoftware + inv.DataGeneratedSoftware) if the operating system for a computer is 32 or 64-bit.

[en] Procedure

[en]

[en] Load incremental data from table inv.DataDataCenter

[en] Procedure

[en]

[en] Load incremental data from table inv.DataDataCenterFeature

[en] Procedure

[en]

[en] Load incremental data from table inv.DataVirtualMachine

[en] Procedure

[en]

[en] Update table inv.tblInventoryDatabase with latest values for SequenceNumberand RowVersion.

[en] Procedure

[en]

[en] Load latest user logon information from an aggregate of tables inv.DataLoginUser (Date), inv.DataClient (LastUpdate) and inv.DataMetering (LastUsed)

[en] Procedure

[en]

[en] Load incremental data from table inv.DataMetering/-_History

[en] Procedure

[en]

[en] Load incremental data from table inv.CloudMeteringIntervalHits

[en] Procedure

[en]

[en] Load incremental data from table inv.DataMobileDeviceProperties

[en] Procedure

[en]

[en] Load incremental data from table inv.DataOracleDatabase

[en] Procedure

[en]

[en] Load incremental data from table inv.DataOracleDatabaseFeatureUsageStats

[en] Procedure

[en]

[en] Load incremental data from table inv.DataOracleDatabaseInstance

[en] Procedure

[en]

[en] Load incremental data from table inv.DataOracleDatabaseMgmtPacks

[en] Procedure

[en]

[en] Load incremental data from table inv.DataOracleDatabaseMgmtPacksSummary

[en] Procedure

[en]

[en] Load incremental data from table inv.DataOracleDatabaseOptions

[en] Procedure

[en]

[en] Load incremental data from table inv.DataOracleDatabaseSessions

[en] Procedure

[en]

[en] Load incremental data from table inv.DataOracleDatabaseUsers

[en] Procedure

[en]

[en] Load incremental data from table inv.ServerAddress

[en] Procedure

[en]

[en] Load possible new SiteNames from inv.DataClient

[en] Truncate and load INV table slm.ClientSiteDBMap

[en] Procedure

[en]

[en] Load incremental data from tables inv.DataApplication and inv.DataWebApplication

[en] Procedure

[en]

[en] Load incremental data from table inv.DataUserAccount

[en] Procedure

[en]

[en] Load incremental data from table inv.DataWebAppMetering

[en] Procedure

[en] slm.PutInventorySequenceNumber

[en] Updates table slm.tblInventoryDatabase with data from SnowLicenseManager dbo.tblInventoryDatabase. Activates script inv.MigrateToSLM9 if not run before and initial run is detected.

[en] Synonym

[en] slm.dbo_tblInventoryDatabase

[en] Synonym for table dbo.tblInventoryDatabase

Note

[en] All of these synonyms are for the corresponding object in the SnowLicenseManager database.

[en] Synonym

[en] slm.inv_MeteringIndexesDrop

[en] Synonym for procedure inv.MeteringIndexesDrop

[en] Synonym

[en] slm.inv_tblADComputerDiscovery

[en] Synonym for table inv.tblADComputerDiscovery

[en] Synonym

[en] slm.inv_tblADUserDiscovery

[en] Synonym for table inv.tblADUserDiscovery

[en] Synonym

[en] slm.inv_tblAPIKey

[en] Synonym for table inv.tblAPIKey

[en] Synonym

[en] slm.inv_tblApplicationConcurrency

[en] Synonym for table inv.tblApplicationConcurrency

[en] Synonym

[en] slm.inv_tblComputerClient

[en] Synonym for table inv.tblComputerClient

[en] Synonym

[en] slm.inv_tblComputerDisplayAdapter

[en] Synonym for table inv.tblComputerDisplayAdapter

[en] Synonym

[en] slm.inv_tblComputerEnvironment

[en] Synonym for table inv.tblComputerEnvironment

[en] Synonym

[en] slm.inv_tblComputerLogicalDisk

[en] Synonym for table inv.tblComputerLogicalDisk

[en] Synonym

[en] slm.inv_tblComputerMemoryModule

[en] Synonym for table inv.tblComputerMemoryModule

[en] Synonym

[en] slm.inv_tblComputerMemory

[en] Synonym for table inv.tblComputerMemory

[en] Synonym

[en] slm.inv_tblComputerMonitor

[en] Synonym for table inv.tblComputerMonitor

[en] Synonym

[en] slm.inv_tblComputerNetworkAdapter

[en] Synonym for table inv.tblComputerNetworkAdapter

[en] Synonym

[en] slm.inv_tblComputerOperatingSystem

[en] Synonym for table inv.tblComputerOperatingSystem

[en] Synonym

[en] slm.inv_tblComputerPhysicalDisk

[en] Synonym for table inv.tblComputerPhysicalDisk

[en] Synonym

[en] slm.inv_tblComputerPrinter

[en] Synonym for table inv.tblComputerPrinter

[en] Synonym

[en] slm.inv_tblComputerProcessor

[en] Synonym for table inv.tblComputerProcessor

[en] Synonym

[en] slm.inv_tblComputerRegistry

[en] Synonym for table inv.tblComputerRegistry

[en] Synonym

[en] slm.inv_tblComputerSoftwareProduct

[en] Synonym for table inv.tblComputerSoftwareProduct

[en] Synonym

[en] slm.inv_tblComputerSoftware

[en] Synonym for table inv.tblComputerSoftware

[en] Synonym

[en] slm.inv_tblComputerVirtualPackage

[en] Synonym for table inv.tblComputerVirtualPackage

[en] Synonym

[en] slm.inv_tblComputerWith64BitSoftware

[en] Synonym for table inv.tblComputerWith64BitSoftware

[en] Synonym

[en] slm.inv_tblDataCenterClient

[en] Synonym for table inv.tblDataCenterClient

[en] Synonym

[en] slm.inv_tblDataCenterFeature

[en] Synonym for table inv.tblDataCenterFeature

[en] Synonym

[en] slm.inv_tblDataCenterVirtualMachine

[en] Synonym for table inv.tblDataCenterVirtualMachine

[en] Synonym

[en] slm.inv_tblInventoryDatabase

[en] Synonym for table inv.tblInventoryDatabase

[en] Synonym

[en] slm.inv_tblLoginUserClient

[en] Synonym for table inv.tblLoginUserClient

[en] Synonym

[en] slm.inv_tblMetering

[en] Synonym for table inv.tblMetering

[en] Synonym

[en] slm.inv_tblMeteringCloud

[en] Synonym for table inv.tblMeteringCloud

[en] Synonym

[en] slm.inv_tblMobileDeviceProperty

[en] Synonym for table inv.tblMobileDeviceProperty

[en] Synonym

[en] slm.inv_tblOracleDatabase

[en] Synonym for table inv.tblOracleDatabase

[en] Synonym

[en] slm.inv_tblOracleDatabaseFeatureUsageStats

[en] Synonym for table inv.tblOracleDatabaseFeatureUsageStats

[en] Synonym

[en] slm.inv_tblOracleDatabaseInstances

[en] Synonym for table inv.tblOracleDatabaseInstances

[en] Synonym

[en] slm.inv_tblOracleDatabaseManagementPacks

[en] Synonym for table inv.tblOracleDatabaseManagementPacks

[en] Synonym

[en] slm.inv_tblOracleDatabaseManagementPacksSummary

[en] Synonym for table inv.tblOracleDatabaseManagementPacksSummary

[en] Synonym

[en] slm.inv_tblOracleDatabaseOptions

[en] Synonym for table inv.tblOracleDatabaseOptions

[en] Synonym

[en] slm.inv_tblOracleDatabaseSessions

[en] Synonym for table inv.tblOracleDatabaseSessions

[en] Synonym

[en] slm.inv_tblOracleDatabaseUsers

[en] Synonym for table inv.tblOracleDatabaseUsers

[en] Synonym

[en] slm.inv_tblServerAddress

[en] Synonym for table inv.tblServerAddress

[en] Synonym

[en] slm.inv_tblSite

[en] Synonym for table inv.tblSite

[en] Synonym

[en] slm.inv_tblSoftware

[en] Synonym for table inv.tblSoftware

[en] Synonym

[en] slm.inv_tblUser

[en] Synonym for table inv.tblUser

[en] Synonym

[en] slm.inv_tblWebMetering

[en] Synonym for table inv.tblWebMetering

[en] Synonym

[en] slm.slm_tblComputer

[en] Synonym for table dbo.tblComputer

[en] Synonym

[en] slm.slm_tblJobCID

[en] Synonym for table dbo.tblJobCID

[en] Synonym

[en] slm.slm_tblJobStatus

[en] Synonym for table dbo.tblJobStatus

[en] Synonym

[en] slm.slm_tblSoftware

[en] Synonym for table dbo.tblSoftware

[en] Synonym

[en] slm.slm_vSystemSettings

[en] Synonym for view dbo.vSystemSettings

[en] Object type

[en] Name

[en] Description

[en] Schema

[en]

[en] Contains all Data Update Job-related objects

[en] Table

[en]

[en] Staging table for delta data loaded from tables inv.DiscoveryMetadata and inv.DiscoveryActiveDirectory using procedure slm.GetADComputerDiscovery

[en] Table

[en]

[en] Staging table for delta data loaded from tables inv.DiscoveryUserActiveDirectory and inv.DiscoveryUserActiveDirectoryEmail using procedure slm.GetADUserDiscovery

[en] Table

[en]

[en] Staging table for API Key information for SnowInventory DB Delete API calls

[en] Table

[en]

[en] Final store for API Key information for SnowInventory DB Delete API calls

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataMeteringConcurrency using procedure slm.GetApplicationConcurrency

[en] Table

[en]

[en] Final store for Computer data

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataClient using procedure slm.GetComputerClient

[en] Table

[en]

[en] Final store for display adapter data

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataDisplayAdapter using procedure slm.GetComputerDisplayAdapter

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataEnvironmentVariable using procedure slm.GetComputerEnvironment

[en] Table

[en] inv.tblComputerInvSlmMap

[en] Mapping table [InventoryDBID + ClientId] vs. [CID + ComputerId]

[en] Table

[en]

[en] Final store for logical disk data

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataLogicalDisk and inv.DataOperatingSystem using procedure slm.GetComputerLogicalDisk

[en] Table

[en]

[en] Final store for computer memory data

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataMemory using procedure slm.GetComputerMemory

[en] Table

[en]

[en] Final store for computer memory module data

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataMemoryModule using procedure slm.GetComputerMemoryModule

[en] Table

[en]

[en] Final store for computer monitor data

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataMonitor using procedure slm.GetComputerMonitor

[en] Table

[en]

[en] Final store for computer network adapter data

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataNetworkAdapter using procedure slm.GetComputerNetworkAdapter

[en] Table

[en]

[en] Final store for computer operating system data

[en] Table

[en]

[en] Staging table for delta data loaded from tables inv.DataOperatingSystem and inv.DataApplication using procedure slm.GetComputerOperatingSystem

[en] Table

[en]

[en] Final store for computer physical disk data

[en] Table

[en]

[en] Staging table for delta data loaded from tables inv.DataPhysicalDisk using procedure slm.GetComputerPhysicalDisk

[en] Table

[en]

[en] Final store for computer printer driver data

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataPrinterusing procedure slm.GetComputerPrinter

[en] Table

[en]

[en] Final store for computer processor data

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataProcessor using procedure slm.GetComputerProcessor

[en] Table

[en] dbo.tblComputerRegistry

[en] Final store for computer registry data

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataCustomRegKey using procedure slm.GetComputerRegistry

[en] Table

[en]

[en] Final store for software installed per computer, including InstallDate

[en] Table

[en]

[en] Staging table for delta data loaded from tables inv.DataSoftware, inv.DataGeneratedSoftware and inv.DataApplication using procedure slm.GetComputerSoftwareSlm

[en] Table

[en]

[en] Final store for computer software product data

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataSoftwareProduct using procedure slm.GetComputerSoftwareProductSlm

[en] Table

[en]

[en] Final store for computer virtual software package data

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.VirtualSoftwarePackages using procedure slm.GetComputerVirtualPackage

[en] Table

[en]

[en] Final store for computer virtual software package data.

[en] Table

[en]

[en] Staging table for delta data loaded from tables inv.DataSoftware, inv.DataGeneratedSoftware, and inv.DataApplication using procedure slm.GetComputerWith64BitSoftware

[en] Table

[en]

[en] Final store for computer identified as Data Center clients

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataDataCenter using procedure slm.GetDataCenterClient

[en] Table

[en]

[en] Final store for identified Data Center features

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataDataCenterFeature using procedure slm.GetDataCenterFeature

[en] Table

[en]

[en] Final store for identified Data Center virtual machines

[en] Table

[en]

[en] Staging table for delta data loaded from table inv.DataVirtualMachine using procedure slm.GetDataCenterVirtualMachine

[en] Table

[en]

[en] System table for storing all dataflows belonging to Data Update Job

[en] Table

[en]

[en] System table for storing dependencies (run order) between dataflows

[en] Table

[en]

[en] Data Stream name table (Name + Id)

[en] Table

[en]

[en] Table containing all deleted devices. Used for filtering incoming SnowInventory DB device data.

[en] Table

[en]

[en] Storage for hidden software

[en] Table

[en] dbo.tblInventoryDatabase

[en] System table for storing SnowInventory database configuration and current setting for RowVersion and SequenceNumber, including possible reset requests due to error in previous run

[en] Table

[en]

[en] System table for storing SnowInventory database configuration and current setting for RowVersion and SequenceNumber

[en] Table

[en] inv.tblInventoryDatabaseLog

[en] Logging table storing the RowVersion and SequenceNumber settings for each Data Update Job run

[en] Table

[en]

[en] System internal table for handling job step sequencing during the Data Update Job run process

[en] Table

[en]

[en] Final store for user-computer login info

[en] Table

[en]

[en] Staging table for user-computer login info (last logon, logon count)

[en] Table

[en]

[en] Final store for by-day aggregated metering data

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database table inv.DataMetering using procedure slm.GetMetering

[en] Table

[en]

[en] Final store for by-day aggregated web application metering data

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database table inv.DataWebAppMetering using procedure slm.GetWebMetering

[en] Table

[en]

[en] Final table for mobile device properties

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database table inv.DataMobileDeviceProperties using procedure slm.GetMobileDeviceProperty

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowIventory database table inv.DataOracleDatabase using procedure slm.GetOracleDatabase

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database tables inv.DataOracleDatabaseFeatureUsageStats using procedure slm.GetOracleDatabaseFeatureUsageStats

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database table inv.DataOracleDatabaseInstance using procedure slm.GetOracleDatabaseInstances

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database table inv.DataOracleDatabaseMgmtPacks using procedure slm.GetOracleDatabaseManagementPacks

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database table inv.DataOracleDatabaseMgmtPacksSummary using procedure slm.GetOracleDatabaseManagementPacksSummary

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database tables inv.DataOracleDatabaseOptions using procedure slm.GetOracleDatabaseOptions

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database table inv.DataOracleDatabaseSessions using procedure slm.GetOracleDatabaseSessions

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database table inv.DataOracleDatabaseUsers using procedure slm.GetOracleDatabaseUsers

[en] Table

[en]

[en] 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)}

[en] Table

[en]

[en] Table storing quarantined devices with ActionCode in {ReActivated, Quarantined, QuarantinedDelete, No Op, Quarantine Off} and StatusCode in {0 (Active), 1 (Quarantined), 2 (Delete)}

[en] Table

[en]

[en] Table storing quarantined users with ActionCode in {ReActivated, Quarantined, QuarantinedDelete, No Op, QUARANTINEOFF} and StatusCode in {0 (Active), 1 (Quarantined)}

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database table inv.ServerAddress using procedure slm.GetServerAddress

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database table inv.ServerAddress using procedure slm.GetServerAddress

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database tables inv.DataClient and inv.DiscoveryUserMetadata using procedure slm.GetSite

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database tables inv.DataOperatingSystem, inv.DataSoftware, inv.DataWebApplication, and inv.DataGeneratedSoftware using procedure slm.GetSoftwareSlm

[en] Table

[en]

[en] SnowInventory database synonym mapping table, containing synonym name and SnowLicenseManager database table name to which the synonym maps

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database tables inv.DataUserAccount and inv.DataMetering using procedure slm.GetUser

[en] Table

[en]

[en] 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

[en] Table

[en]

[en] 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

[en] Table

[en]

[en] Receiving staging table for delta data loaded from SnowInventory database table inv.DataWebAppMetering using procedure slm.GetWebMetering

[en] View

[en]

[en] Simple view to hold Root and DefaultOrgChecksum values per SourceId.

[en] View

[en]

[en] 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

[en] Stored Procedure

[en]

[en] 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.

[en] Stored Procedure

[en]

[en] Procedure adding updated data from inv.tblWebMetering to tables dbo.tblApplication, dbo.tblApplicationRule, and dbo.tblApplicationInfo

[en] Stored Procedure

[en]

[en] Procedure to add error information in all relevant tables (inv.tblJobParallelStep, dbo.tblJobLog, and dbo.tblJobStatus) if an error occurs

[en] Stored Procedure

[en] inv.MeteringIndexesCreate

[en] 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)

[en] Stored Procedure

[en] inv.MeteringIndexesDrop

[en] 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)

[en] Stored Procedure

[en]

[en] Procedure to delete computers from all correlated tables that have been quarantined and then reach status Quarantine Delete

[en] Stored Procedure

[en]

[en] Procedure to delete devices from all correlated tables that have been quarantined and then reach status Quarantine Delete

[en] Stored Procedure

[en]

[en] Procedure to delete users from all correlated tables that have been quarantined and then reach status Quarantine Delete

[en] Stored Procedure

[en] inv.UpdateADComputerDiscovery

[en] Procedure to update table dbo.tblComputerDiscovery with new data from staging table inv.tblADComputerDiscovery

[en] Stored Procedure

[en] inv.UpdateADUserDiscovery

[en] 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.

[en] Stored Procedure

[en]

[en] Replaces the information in dbo.tblAPIKey with newly imported data from inv.tblAPIKey

[en] Stored Procedure

[en]

[en] 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.

[en] Stored Procedure

[en]

[en] 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).

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerDisplayAdapter with new data from staging table inv.tblComputerDisplayAdapter

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerEnvironment with new data from staging table inv.tblComputerEnvironment

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerLogicalDisk with new data from staging table inv.tblComputerLogicalDisk

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerMemory with new data from staging table inv.tblComputerMemory

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerMemoryModule with new data from staging table inv.tblComputerMemoryModule

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerMonitor with new data from staging table inv.tblComputerMonitor

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerNetworkAdapter with new data from staging table inv.tblComputerNetworkAdapter

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerOperatingSystem with new data from staging table inv.tblComputerOperatingSystem

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerPhysicalDisk with new data from staging table inv.tblComputerPhysicalDisk

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerPrinter with new data from staging table inv.tblComputerPrinter

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerProcessor with new data from staging table inv.tblComputerProcessor

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerRegistry with new data from staging table inv.tblComputerRegistry

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerSoftwareInstalled with new data from staging table inv.tblComputerSoftwareInstalled

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerSoftwareProduct with new data from staging table inv.tblComputerSoftwareProduct

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerVirtualPackage with new data from staging table inv.tblComputerVirtualPackage

[en] Stored Procedure

[en]

[en] Updates table dbo.tblComputerWith64BitSoftware with new data from staging table inv.tblComputerWith64BitSoftware

[en] Stored Procedure

[en]

[en] Updates table dbo.tblDataCenterClient with new data from staging table inv.tblDataCenterClient

[en] Stored Procedure

[en]

[en] Updates table dbo.tblDataCenterFeature with new data from staging table inv.tblDataCenterFeature

[en] Stored Procedure

[en]

[en] Updates table dbo.tblDataCenterVirtualMachine with new data from staging table inv.tblDataCenterVirtualMachine

[en] Stored Procedure

[en] inv.UpdateInventoryDatabase

[en] 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.

[en] Stored Procedure

[en]

[en] Updates table dbo.tblLoginUserClient with new data from staging table inv.tblLoginUserClient

[en] Stored Procedure

[en]

[en] Updates table dbo.tblMetering with new data from staging table inv.tblMetering. Also creates indexes, if necessary (such as after initial run).

[en] Stored Procedure

[en]

[en] Updates table dbo.tblMeteringCloud with new data from staging table inv.tblMeteringCloud

[en] Stored Procedure

[en]

[en] Updates table dbo.tblMobileDeviceProperty with new data from staging table inv.tblMobileDeviceProperty

[en] Stored Procedure

[en]

[en] 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.

[en] Stored Procedure

[en]

[en] Updates table dbo.tblOracleDatabaseFeatureUsageStats with new data from staging table inv.tblOracleDatabaseFeatureUsageStats

[en] Stored Procedure

[en]

[en] Updates table dbo.tblOracleDatabaseInstances with new data from staging table inv.tblOracleDatabaseInstances. Oracle capping validation is in effect.

[en] Stored Procedure

[en]

[en] Updates table dbo.tblOracleDatabaseManagementPacks with new data from staging table inv.tblOracleDatabaseManagementPacks

[en] Stored Procedure

[en]

[en] Updates table dbo.tblOracleDatabaseManagementPacksSummary with new data from staging table inv.tblOracleDatabaseManagementPacksSummary

[en] Stored Procedure

[en]

[en] Updates table dbo.tblOracleDatabaseOptions with new data from staging table inv.tblOracleDatabaseOptions

[en] Stored Procedure

[en]

[en] Updates table dbo.tblOracleDatabaseSessions with new data from staging table inv.tblOracleDatabaseSessions

[en] Stored Procedure

[en]

[en] Updates table dbo.tblOracleDatabaseUsers with new data from staging table inv.tblOracleDatabaseUsers

[en] Stored Procedure

[en]

[en] 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.

[en] Stored Procedure

[en]

[en] Main quarantine-handling procedure for devices. Updates columns QuarantineDate and StatusCode in dbo.tblDeviceInfo. Updates table dbo.tblQuarantineDeviceInfo. Calls procedure dbo.QuarantineDeleteDeviceInfo.

[en] Stored Procedure

[en]

[en] Main quarantine-handling procedure for users. Updates column QuarantineDate and StatusCode in dbo.tblUser. Updates table dbo.tblQuarantineUser. Calls procedure dbo.QuarantineDeleteUser.

[en] Stored Procedure

[en]

[en] Truncates and inserts into table dbo.tblServerAddress new data from staging table inv.tblServerAddress

[en] Stored Procedure

[en]

[en] 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.

[en] Stored Procedure

[en]

[en] 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.

[en] Stored Procedure

[en]

[en] 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.

[en] Stored Procedure

[en]

[en] Updates column Is64bit in table dbo.tblComputer, based on collective information from the three sources dbo.tblComputerWith64BitSoftware, dbo.tblComputerOperatingSystem, and dbo.tblComputerClient

[en] Stored Procedure

[en]

[en] Updates columns SystemDiskSpace, SystemDiskSpaceAvailable, TotalDiskSpace, and TotalDiskSpaceAvailable in table dbo.tblComputerHardware

[en] Stored Procedure

[en]

[en] Updates columns MemorySlots, MemorySlotsAvailable, and PhysicalMemory in table dbo.tblComputerHardware

[en] Stored Procedure

[en]

[en] Updates columns ProcessorCount, CoreCount, ProcessorType, ProcessorSpeed, SocketCountManualOverrideEnabled (=0), and ProcessorManufacturer in table dbo.tblComputerHardware from table dbo.tblComputerProcessor

[en] Stored Procedure

[en]

[en] 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.

[en] Stored Procedure

[en]

[en] Adds valid CID mappings from dbo.tblJobCID to inv.tblSite

[en] Stored Procedure

[en]

[en] Adds new software rows from table inv.tblSoftware to table dbo.tblSoftware

[en] Stored Procedure

[en]

[en] 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.

[en] Function

[en]

[en] SQL community standard function to create a column of split strings from a delimited string

[en] Object type

[en] Name

[en] Change

[en] Description

[en] Table

[en]

[en] DROP COLUMN

[en]

[en]

[en] Table

[en]

[en] ADD COLUMN

[en]

[en] Table

[en]

[en] ADD COLUMN

[en] ApiSourceID UNIQUEIDENTIFIER NULL

[en] Table

[en]

[en] DROP COLUMN

[en]

[en]

[en]

[en]

[en] Table

[en]

[en] ADD COLUMN

[en]

[en]

[en] Table

[en]

[en] DROP COLUMN

[en]

[en]

[en]

[en]

[en]

[en] Table

[en]

[en] DROP COLUMN

[en]

[en]

[en] Table

[en]

[en] DROP INDEX

[en] Primary Key (CID, RowID, SourceID, ComputerID)

[en] Table

[en]

[en] ADD COLUMN

[en] Updated BIT DEFAULT (1)

[en] Table

[en]

[en] ADD DEFAULT

[en]

[en]

[en]

[en] Table

[en]

[en] DROP COLUMN

[en]

[en]

[en]

[en]

[en]

[en] Table

[en]

[en] DROP COLUMN

[en]

[en]

[en] Table

[en]

[en] ALTER COLUMN

[en]

[en]

[en] Table

[en]

[en] DROP INDEX

[en] Primary Key (CID, RowID, SourceID, ComputerID)

[en] Table

[en]

[en] CREATE INDEX

[en] Primary Key (ValueName, KeyName, ComputerID, CID)

[en] Table

[en]

[en] ADD COLUMN

[en] InventoryDBID INT NOT NULL

[en] Table

[en] dbo.tblDCC

[en] ADD COLUMN

[en] HypervisorType INT HighAvailability BIT DEFAULT (0) VmwareDRS BIT DEFAULT (0)

[en] Table

[en]

[en] DROP COLUMN

[en]

[en] Table

[en]

[en] ADD COLUMN

[en] ServerClientID INT NOT NULL

[en] InventoryDBID INT NOT NULL

[en] Table

[en] dbo.tblDevicesDeleted

[en] ALTER COLUMN

[en] DeviceName NVARCHAR(100) NULL

[en] Table

[en]

[en] ADD COLUMN

[en] SYSNAME

[en] Table

[en]

[en] DROP COLUMN

[en]

[en] Table

[en] dbo.tblOracleDatabaseFeatureUsageStats

[en] ALTER COLUMN

[en] Name NVARCHAR(100)

[en] Table

[en] dbo.tblOracleDatabaseUsers

[en] ALTER COLUMN

[en] UserName COLLATE SQL_Latin1_General_CP1_CS_AS

[en] Table

[en]

[en] ADD COLUMN

[en] IsTS BIT NOT NULL

[en] IsVT BIT NOT NULL

[en] Table

[en]

[en] ADD COLUMN

[en] IsExcluded BIT NOT NULL

[en] Table

[en] dbo.tblSoftwareCID

[en] DROP COLUMN

[en] PlatformID

[en] Table

[en] dbo.tblSystemCustomProcedures

[en] ADD COLUMN

[en] Status BIT

[en] View

[en]

[en] ALTER VIEW

[en]

[en]

[en]

[en]

[en] LogicalDisks (show value NULL)

[en] View

[en]

[en] DROP COLUMN

[en]

[en] View

[en]

[en] ALTER VIEW

[en]

[en]

[en]

[en]

[en] LogicalDisksTxt (all columns reference new database objects)

[en] View

[en]

[en] DROP COLUMN

[en]

[en] View

[en] dbo.RsApiMobileDeviceDetail

[en] ALTER VIEW

[en] Changed reference to table dbo.tblMobileDeviceProperty

[en] View

[en]

[en] ALTER VIEW

[en] Changed reference to dbo.tblMobileDeviceProperty

[en] View

[en]

[en] DROP COLUMN

[en]

[en]

[en]

[en]

[en]

[en] View

[en]

[en] DROP COLUMN

[en]

[en] View

[en]

[en] DROP COLUMN

[en]

[en]

[en]

[en]

[en] View

[en]

[en] ALTER VIEW

[en] (column removed from GROUP BY clause)

[en] View

[en]

[en] DROP COLUMN

[en]

[en]

[en]

[en] View

[en]

[en] ALTER VIEW

[en]

[en]

[en]

[en]

[en] LogicalDisks (columns listed show NULL values)

[en] View

[en]

[en] ALTER VIEW

[en]

[en]

[en]

[en]

[en] (listed columns have changed to show NULL, pending rewriting to reference new objects)

[en] View

[en]

[en] DROP COLUMN

[en]

[en] View

[en]

[en] DROP COLUMN / ALTER VIEW

[en]

[en] Stored Procedure

[en]

[en] DROP COLUMN

[en]

[en]

[en] Stored Procedure

[en]

[en] DML UPDATE

[en]

[en] Stored Procedure

[en]

[en] DML UPDATE

[en]

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Dropped variable @RuleAND (not used in SP)

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] New column inv.tblSoftware.HasRuleApplied

[en] Replaced table dbo.tblSoftwareStage with new table inv.tblSoftware

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Dropped variable @ClientID

[en] Removed CVDiscard update

[en] Stored Procedure

[en]

[en] DROP COLUMN

[en]

[en]

[en] Stored Procedure

[en]

[en] DML UPDATE

[en]

[en]

[en]

[en]

[en] (changed sources from dbo.tblComputerHardware table to new dbo.tblComputer* tables; changed to singular form for name-changed tables)

[en] Stored Procedure

[en]

[en] DROP COLUMN

[en]

[en] Stored Procedure

[en]

[en] DROP COLUMN

[en]

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed SET CVDiscard = NULL

[en] Stored Procedure

[en]

[en] DROP COLUMN

[en]

[en] Stored Procedure

[en]

[en] DROP COLUMN

[en]

[en]

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Changed reference to dbo.tblComputerPrinter

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed SET CVDiscard = NULL

[en] Removed SET CVDiscard = 1

[en] Removed SET CVDiscard = 0

[en] Stored Procedure

[en] dbo.DccList

[en] ADD COLUMN

[en] HypervisorType HighAvailability VmwareDRS

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Added columns ServerClientID and InventoryDBID to procedure

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Stores multiple deleted device information in dbo.tblDevicesDeleted and inv.tblDeletedDevicesMap to handle device deletion in SnowInventory

[en] Stored Procedure

[en] dbo.GetComputerDetailsApplication

[en] DML UPDATE

[en] Added ISNULL(IsInstalled, 0) (fix for NULL values causing Computer details page to  crash)

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Minor changes, such as adding schema to tables

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Moved job steps into dataflow structure

[en] Added new reference for variable @Owner to use dbo.tblSystemInfo.LicenseManagerUser

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed column CVDiscard from WHERE clause

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed CURSOR from table dbo.tblLicense, column ApplicationID update

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed REBUILD_INDEXES_DAY System Setting

[en] Removed call to dbo.JobShrinkDB procedure

[en] Removed call to dbo.JobRebuildIndexes procedure

[en] Added DataStream dependency to reduce number of steps run in DataStream ConfigStream

[en] Stored Procedure

[en] dbo.JobExecuteCustomProcedures

[en] DML UPDATE

[en] 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)

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Dropped VDICoverage column update (dropped from table dbo.tblComputerApplications)

[en] Dropped CVDiscard column

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed CURSOR in loading dbo.tblApplicationConcurrencyWork table

[en] Removed CHECKPOINTs

[en] Stored Procedure

[en] dbo.JobInventoryComputerAppHistoryUpdate

[en] DML UPDATE

[en] Removed CURSOR in loading work table

[en] Stored Procedure

[en] dbo.JobInventoryComputerSoftwareBundlesUpdate

[en] DML UPDATE

[en] Changed reference of Updated from dbo.tblComputer to new table dbo.tblComputerClient

[en] Stored Procedure

[en] dbo.JobInventoryComputerSoftwareGroupsUpdate

[en] DML UPDATE

[en] Changed reference of Updated from dbo.tblComputer to new table dbo.tblComputerClient

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed CURSOR in loading work table

[en] Changed reference of Updated from dbo.tblComputer to new table dbo.tblComputerClient

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed CURSOR in loading work table

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed CURSOR in loading work table

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed CURSOR in loading work table

[en] Removed dynamic SQL handling

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] CVDiscard dropped from update

[en] Changed reference of Updated from dbo.tblComputer to new table dbo.tblComputerClient

[en] Stored Procedure

[en] dbo.JobInventoryDeviceApplicationGroupsUpdate

[en] DML UPDATE

[en] Changed reference of Updated from dbo.tblComputer to new table dbo.tblComputerClient

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed metering history handling (Inv 3 only)

[en] Removed Quarantine handling

[en] INSERT dbo.tblDeviceApplications rewritten

[en] Removed dynamic SQL

[en] Removed CURSOR

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed Checkpoint handling

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed Checkpoint handling

[en] Minor clean-up of code according to ANSI standards

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Table dbo.tblSoftwareStage replaced with inv.tblSoftware

[en] Removed rebuild index for table dbo.tblSoftware

[en] Removed Checkpoint handling

[en] Minor clean-up of code according to ANSI standards

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Dropped all Transfer* tables from SnowInventory

[en] Dropped table dbo.MeteringWork in SnowInventory

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed update of column ClientID in table dbo.tblComputer

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Added functionality for logging the finishing time from parallel running job steps

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed DBCC SHRINKDATABASE statement

[en] Removed rebuild indexes statements Added synonym creation statements

[en] Added deletion of old non-scheduled jobs

[en] Added creation of currently configured non-scheduled jobs

[en] Added check for existing number of active CIDs > 0

[en] Added version check for all connected SnowInventory databases

[en] Added logging of dbo.tblInventoryDatabase

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Dropped all Mode handling in procedure

[en] Dropped delta run functionality

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Dropped System Setting INVENTORY_TRANSFER_DATE_OFFSET (@DataOffset == 1)

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Changed job owner from sa to dbo.tblSystemInfo.LicenseManagerUser

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Switched reference to (singular) dbo.tblComputerPrinter

[en] Switched to use security allowed view sys.database_files for reading database size

[en] Use new dbo.tblComputerClient table for counting number of updated computers

[en] Stored Procedure

[en] dbo.MobileDetailsSearch

[en] DML UPDATE

[en] Changed table name to dbo.tblMobileDeviceProperty

[en] Stored Procedure

[en] dbo.MobileDeviceDetailsDataGet

[en] DML UPDATE

[en] Changed table name to dbo.tblMobileDeviceProperty

[en] Stored Procedure

[en] dbo.MobileDeviceList

[en] DML UPDATE

[en] ClientId

[en] Architecture

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Updated columns NetworkAdapterPhysicalAddressString and DisplayAdapters to use new tables

[en] Stored Procedure

[en] dbo.StockReportCustomFieldsPerMobileDevice

[en] DML UPDATE

[en] Changed table name to dbo.tblMobileDeviceProperty

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Updated column NetworkAdapters to use new table dbo.tblComputerNetworkAdapter

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Changed reference to (singular) table dbo.tblComputerPrinter

[en] Added schema to table references

[en] Stored Procedure

[en] dbo.StockReportVirtualAppPackagesPerComputer

[en] DML UPDATE

[en] Changed table name to dbo.tblComputerVirtualPackage

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Removed call to dbo.UserInventorySourceDelete procedure

[en] Added usage of dbo.tblUserDeleted table

[en] Stored Procedure

[en]

[en] DML UPDATE

[en] Added SchemaName column