Software list in double

[Asoumpholphakdy]

Hello everybody,

I have a question, hope you have an answer.
When I filter my software, I have the same software with same version in two differents lines.
Is that because one line is for 32 bits and the other one for 64 bits ?
In this example with Chrome, but it happens with several software too.

Thank you.

[rom]

not sure what the reason is - it kinda depends on different things.

you could try running this query to see:

SELECT TOP (1000) [SoftwareID]
      ,[AssetID]
      ,tblsoftware.[softID]
	  ,tblSoftwareUni.softwareName
	  ,tblSoftwareUni.SoftwarePublisher
      ,[softwareVersion]
      ,[Installdate]
      ,[Lastchanged]
      ,[CurrentUser]
      ,[MSI]
  FROM [lansweeperdb].[dbo].[tblSoftware]
 left join tblSoftwareUni on tblsoftware.softid = tblSoftwareUni.softid
  where softwareVersion = '98.0.4758.81'

[Asoumpholphakdy]

Thanks Rom, it helped me, the difference is from the MSI.

Rom wrote:
not sure what the reason is - it kinda depends on different things.

you could try running this query to see:

SELECT TOP (1000) [SoftwareID]
      ,[AssetID]
      ,tblsoftware.[softID]
	  ,tblSoftwareUni.softwareName
	  ,tblSoftwareUni.SoftwarePublisher
      ,[softwareVersion]
      ,[Installdate]
      ,[Lastchanged]
      ,[CurrentUser]
      ,[MSI]
  FROM [lansweeperdb].[dbo].[tblSoftware]
 left join tblSoftwareUni on tblsoftware.softid = tblSoftwareUni.softid
  where softwareVersion = '98.0.4758.81'