AnsweredAssumed Answered

Duplicates in Snow Website

Question asked by GMSS on Sep 12, 2019
Latest reply on Sep 13, 2019 by Oliver.Berger

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?

 

ClientIdSequenceNumberHostNameType
194761633163W061357P86624SNOW_INVENTORY_DB
194761651177W061357P86624SNOW_INVENTORY_DB
194761652711W061357P86624SNOW_INVENTORY_DB
194761652711W061357P86624SNOW_LICENSEMANAGER_DB
194771646026W046303P84068SNOW_INVENTORY_DB
194781640293W062199P83620SNOW_INVENTORY_DB
194781651020W062199P83620SNOW_INVENTORY_DB
194781651020W062199P83620SNOW_LICENSEMANAGER_DB
194791645120W026059P92042SNOW_INVENTORY_DB
194801640993W063134P84070SNOW_INVENTORY_DB
194801651453W063134P84070SNOW_INVENTORY_DB
194801651453W063134P84070SNOW_LICENSEMANAGER_DB
194811634706WGMACCDTWIFISNOW_INVENTORY_DB
194811650237WGMACCDTWIFISNOW_INVENTORY_DB
194811650237WGMACCDTWIFISNOW_LICENSEMANAGER_DB
194821642987W032691P92023SNOW_INVENTORY_DB
194821654474W032691P92023SNOW_INVENTORY_DB
194831643500W072025P88005SNOW_INVENTORY_DB
194841643211L059894OLMSNOW_INVENTORY_DB
194851627065W072937P84071SNOW_INVENTORY_DB
194851649301W072937P84071SNOW_INVENTORY_DB
194851652597W072937P84071SNOW_INVENTORY_DB
194851652597W072937P84071SNOW_LICENSEMANAGER_DB
194861639579W045478P84035SNOW_INVENTORY_DB
194871641570W043541P82613SNOW_INVENTORY_DB
194871651027W043541P82613SNOW_INVENTORY_DB
194871651027W043541P82613SNOW_LICENSEMANAGER_DB
194881643531W068577P84023SNOW_INVENTORY_DB
194881653325W068577P84023SNOW_INVENTORY_DB
194881653325W068577P84023SNOW_LICENSEMANAGER_DB
194891646151STSVMRESDB05SNOW_INVENTORY_DB
194891652444STSVMRESDB05SNOW_INVENTORY_DB
194891652444STSVMRESDB05SNOW_LICENSEMANAGER_DB

Outcomes