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.
Related Articles
Duplicate computers appear on the Search Computer page but not the All Computers report 72Number of Views 'Search for Computers' Vs 'All computers Report' reports reporting a different number of devices 46Number of Views How to delete or archive bulk Computers from Snow License Manager? 121Number of Views Snow License Manager: How to look for duplicates 183Number of Views Snow License Manager: "Forbidden" and "You do not have permission to view this directory or page" error 29Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago