duplicate computers

[ratiopharm]

I am seeing duplicate PC's in my reports and in my console

[Hemoco]

ratiopharm wrote:
Yes duplicates exists of that PC and others , the scan times are from the same day

CA-W-3540 NAM NAM adm-admin 24/08/2009 SAP GUI 7.10 7.10 Compilation 3
CA-W-3540 NAM NAM adm-admin 24/08/2009 SAP GUI 7.10 7.10 Compilation 3
CA-W-3540 NAM NAM adm-admin 24/08/2009 SAP GUI 7.10 7.10 Compilation 3
CA-W-3540 NAM NAM adm-admin 24/08/2009 SAP GUI 7.10 7.10 Compilation 3

When you look at the table, are the scans from the exact same time?

[Hemoco]

Could you check if you have multiple records for this computer in table "tbloperatingsystem"
Please also check the lastscanned time.

[ratiopharm]

SELECT
dbo.tblComputers.Computername,
dbo.tblComputers.Domain,
dbo.tblComputers.Userdomain,
dbo.tblComputers.Username,
dbo.tblOperatingsystem.Description,
dbo.tblSoftware.Lastchanged,
dbo.tblSoftware.softwareName,
dbo.tblSoftware.softwareversion
FROM
dbo.tblComputers
INNER JOIN dbo.tblOperatingsystem ON (dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername)
INNER JOIN dbo.tblSoftware ON (dbo.tblComputers.Computername = dbo.tblSoftware.ComputerName)
WHERE
dbo.tblSoftware.softwareName LIKE '%sap gui%' AND
dbo.tblSoftware.softwareversion LIKE '%7.10 compilation 3%'


I believe the code was modified from a canned report

[Hemoco]

Could you give the name (and maybe sql code) of one of these reports?
Were these reports build-in or did you create them?

[ratiopharm]

No I do not see it in tblComputers, most reports I run have at least one duplicate whether they are custom or default reports

[Hemoco]

Could you please take a look in table "tblcomputers" if the computer is there only once?
On which screen/report do you see this?