GMSS asked a question.
Duplicates in Snow Website
We have been experiencing issues with duplications and so I have manually cleared these down but should we be seeing the following output from this SQL command? select * FROM [SnowInventory].[inv].[DataClient] select * FROM [SnowLicenseManager].[inv].[tblComputerClient] This is an excel extract of both databases with duplicate valves conditional formatting applied. Surely each asset should only be listed twice, one in the SNOW_IVENTORY_DB and the other in SNOW_LICENSEMANAGER_DB. Please could the community share some thoughts on this? ClientId SequenceNumber HostName Type 19476 1633163 W061357P86624 SNOW_INVENTORY_DB 19476 1651177 W061357P86624 SNOW_INVENTORY_DB 19476 1652711 W061357P86624 SNOW_INVENTORY_DB 19476 1652711 W061357P86624 SNOW_LICENSEMANAGER_DB 19477 1646026 W046303P84068 SNOW_INVENTORY_DB 19478 1640293 W062199P83620 SNOW_INVENTORY_DB 19478 1651020 W062199P83620 SNOW_INVENTORY_DB 19478 1651020 W062199P83620 SNOW_LICENSEMANAGER_DB 19479 1645120 W026059P92042 SNOW_INVENTORY_DB 19480 1640993 W063134P84070 SNOW_INVENTORY_DB 19480 1651453 W063134P84070 SNOW_INVENTORY_DB 19480 1651453 W063134P84070 SNOW_LICENSEMANAGER_DB 19481 1634706 WGMACCDTWIFI SNOW_INVENTORY_DB 19481 1650237 WGMACCDTWIFI SNOW_INVENTORY_DB 19481 1650237 WGMACCDTWIFI SNOW_LICENSEMANAGER_DB 19482 1642987 W032691P92023 SNOW_INVENTORY_DB 19482 1654474 W032691P92023 SNOW_INVENTORY_DB 19483 1643500 W072025P88005 SNOW_INVENTORY_DB 19484 1643211 L059894OLM SNOW_INVENTORY_DB 19485 1627065 W072937P84071 SNOW_INVENTORY_DB 19485 1649301 W072937P84071 SNOW_INVENTORY_DB 19485 1652597 W072937P84071 SNOW_INVENTORY_DB 19485 1652597 W072937P84071 SNOW_LICENSEMANAGER_DB 19486 1639579 W045478P84035 SNOW_INVENTORY_DB 19487 1641570 W043541P82613 SNOW_INVENTORY_DB 19487 1651027 W043541P82613 SNOW_INVENTORY_DB 19487 1651027 W043541P82613 SNOW_LICENSEMANAGER_DB 19488 1643531 W068577P84023 SNOW_INVENTORY_DB 19488 1653325 W068577P84023 SNOW_INVENTORY_DB 19488 1653325 W068577P84023 SNOW_LICENSEMANAGER_DB 19489 1646151 STSVMRESDB05 SNOW_INVENTORY_DB 19489 1652444 STSVMRESDB05 SNOW_INVENTORY_DB 19489 1652444 STSVMRESDB05 SNOW_LICENSEMANAGER_DB
