It was noticed that duplicate devices are present in the Search For Computers Page only, Within the All Computers Report - there is only one entry. This did not effect licensing compliance.

NOTE: When attempting to select one instance of the duplicate it also auto-selects both instances. Please see examples below:

Duplication in Search For Computers:

No Duplication In All Computers Report:

Snow License Manager 9.x

Running the query below populates the Search For Computers Page. Please note: In some cases the RsComputerSearch view may differ (ie. RsComputerSearch2)

exec sp_executesql N'SELECT TOP (100000)
[Project2].[CID] AS [CID],
[Project2].[ComputerID] AS [ComputerID],
[Project2].[Archive Computer] AS [Archive Computer],
[Project2].[HostName] AS [HostName],
[Project2].[Architecture] AS [Architecture],
[Project2].[BiosDate] AS [BiosDate],
[Project2].[BiosSerialNumber] AS [BiosSerialNumber], 
[Project2].[BiosVersion] AS [BiosVersion],
[Project2].[ClientConfigurationName] AS [ClientConfigurationName],
[Project2].[ClientInstallDate] AS [ClientInstallDate],
[Project2].[ClientVersion] AS [ClientVersion],
[Project2].[ComputerStatus] AS [ComputerStatus],
[Project2].[Domain] AS [Domain],
[Project2].[HypervisorName] AS [HypervisorName],
[Project2].[InvoiceReference] AS [InvoiceReference],
[Project2].[IpAddress] AS [IpAddress],
[Project2].[IsPortable] AS [IsPortable],
[Project2].[IsServer] AS [IsServer],
[Project2].[IsVdi] AS [IsVdi],
[Project2].[IsVirtual] AS [IsVirtual],
[Project2].[MostFrequentUser] AS [MostFrequentUser], 
[Project2].[LastLoggedOnUser] AS [LastLoggedOnUser],
[Project2].[LastScannedDate] AS [LastScannedDate],
[Project2].[OperatingSystem] AS [OperatingSystem],
[Project2].[Manufacturer] AS [Manufacturer],
[Project2].[Model] AS [Model],
[Project2].[Organization] AS [Organization],
[Project2].[OrgChecksum] AS [OrgChecksum],
[Project2].[PhysicalMemory] AS [PhysicalMemory],
[Project2].[ProcessorCount] AS [ProcessorCount],
[Project2].[ProcessorSpeed] AS [ProcessorSpeed],
[Project2].[ProcessorType] AS [ProcessorType],
[Project2].[CoreCount] AS [CoreCount],
[Project2].[CoresPerProcessor] AS [CoresPerProcessor],
[Project2].[PurchaseCurrency] AS [PurchaseCurrency],
[Project2].[PurchaseDate] AS [PurchaseDate],
[Project2].[PurchaseValue] AS [PurchaseValue],
[Project2].[SecurityCode] AS [SecurityCode],
[Project2].[Vendor] AS [Vendor],
[Project2].[HostComputerName] AS [HostComputerName],
[Project2].[DccName] AS [DccName],
[Project2].[Pvu] AS [Pvu],
[Project2].[AgreementList] AS [AgreementList],
[Project2].[OsVersionIndex] AS [OsVersionIndex],
[Project2].[OsEditionIndex] AS [OsEditionIndex],
[Project2].[SystemUserId] AS [SystemUserId],
[Project2].[IncludeWsRequirement] AS [IncludeWsRequirement],
[Project2].[IsArchived] AS [IsArchived]
FROM ( SELECT
[Extent1].[CID] AS [CID],
[Extent1].[ComputerID] AS [ComputerID],
[Extent1].[Archive Computer] AS [Archive Computer],
[Extent1].[HostName] AS [HostName],
[Extent1].[Architecture] AS [Architecture],
[Extent1].[BiosDate] AS [BiosDate],
[Extent1].[BiosSerialNumber] AS [BiosSerialNumber],
[Extent1].[BiosVersion] AS [BiosVersion],
[Extent1].[ClientConfigurationName] AS [ClientConfigurationName],
[Extent1].[ClientInstallDate] AS [ClientInstallDate],
[Extent1].[ClientVersion] AS [ClientVersion],
[Extent1].[ComputerStatus] AS [ComputerStatus],
[Extent1].[Domain] AS [Domain],
[Extent1].[HypervisorName] AS [HypervisorName],
[Extent1].[InvoiceReference] AS [InvoiceReference],
[Extent1].[IpAddress] AS [IpAddress],
[Extent1].[IsPortable] AS [IsPortable],
[Extent1].[IsServer] AS [IsServer],
[Extent1].[IsVdi] AS [IsVdi],
[Extent1].[IsVirtual] AS [IsVirtual],
[Extent1].[MostFrequentUser] AS [MostFrequentUser],
[Extent1].[LastLoggedOnUser] AS [LastLoggedOnUser],
[Extent1].[LastScannedDate] AS [LastScannedDate],
[Extent1].[OperatingSystem] AS [OperatingSystem],
[Extent1].[Manufacturer] AS [Manufacturer],
[Extent1].[Model] AS [Model],
[Extent1].[Organization] AS [Organization],
[Extent1].[OrgChecksum] AS [OrgChecksum],
[Extent1].[PhysicalMemory] AS [PhysicalMemory], 
[Extent1].[ProcessorCount] AS [ProcessorCount],
[Extent1].[ProcessorSpeed] AS [ProcessorSpeed],
[Extent1].[ProcessorType] AS [ProcessorType],
[Extent1].[CoreCount] AS [CoreCount],
[Extent1].[CoresPerProcessor] AS [CoresPerProcessor],
[Extent1].[PurchaseCurrency] AS [PurchaseCurrency],
[Extent1].[PurchaseDate] AS [PurchaseDate],
[Extent1].[PurchaseValue] AS [PurchaseValue],
[Extent1].[SecurityCode] AS [SecurityCode],
[Extent1].[Vendor] AS [Vendor],
[Extent1].[HostComputerName] AS [HostComputerName],
[Extent1].[DccName] AS [DccName],
[Extent1].[Pvu] AS [Pvu],
[Extent1].[AgreementList] AS [AgreementList],
[Extent1].[OsVersionIndex] AS [OsVersionIndex],
[Extent1].[OsEditionIndex] AS [OsEditionIndex],
[Extent1].[SystemUserId] AS [SystemUserId],
[Extent1].[IncludeWsRequirement] AS [IncludeWsRequirement],
[Extent1].[IsArchived] AS [IsArchived]
FROM [dbo].[RsComputerSearch1] AS [Extent1]
WHERE ([Extent1].[CID] = @p__linq__0) AND ([Extent1].[SystemUserId] = @p__linq__1) AND ( EXISTS (SELECT
1 AS [C1]
FROM [dbo].[tblSystemUserOrgDefinition] AS [Extent2]
WHERE ([Extent2].[CID] = @p__linq__2) AND ([Extent2].[UserID] = @p__linq__3) AND ([Extent2].[OrgChecksum] = [Extent1].[OrgChecksum])
)) AND ([Extent1].[IsArchived] = @p__linq__4) AND (LOWER([Extent1].[HostName]) LIKE N''%%'')
) AS [Project2]
ORDER BY [Project2].[HostName] ASC, [Project2].[ComputerID] ASC, [Project2].[CID] ASC',N'@p__linq__0 int,@p__linq__1 int,@p__linq__2 int,@p__linq__3 int,@p__linq__4 bit',@p__linq__0=1,@p__linq__1=1,@p__linq__2=1,@p__linq__3=1,@p__linq__4=0

After executing the above; it was found that the only column that differed was the DCCName column; please see below:

Then searching the host - ESX computer ID - running the following:

Select * FROM tblComputer

Where hostname like '%inmumprdesxi01%'

Then searching the DCCMembers table (which holds the Virtual Machines & their corresponding Data Centers) with the computer ID from above;

SELECT * FROM tblDCCMembers

Where ComputerID = 7782

it was found that the Computer ID belonged to two Data Centers (DCCID 20 + DCCID 30) ; thus causing the duplication

After reviewing the table tblDCC it was evident that a number of Data Centers no longer existed however their VMs were still present in the DCCMembers table.

After reviewing the tblDCCMembers a script was created to remove the unwanted entries.  Please speak to your regional support team for assistance with creating a script.

Orphaned Virtual Machines were still present in the DCCMembers table; when the data center was removed from Snow License Manager - these devices were not fully deleted thus showing in the Search For Computers.