Client Management Suite

I look in the report "Computers With duplicate Name" - the description says

"This report displays any two or more computers with the same name....."

I have only 1 PC showing in there. I went to the PC and ran the /resetguid command. Should this resolve the issue?

Is it saying there is a duplicate PC using the altiris computer ID or the OS GUID ?

Joe,

It is showing machines with the same DOMAIN\COMPUTERNAME.

So resseting the GUID will do nothing. You should check the two computer names that have the same name and merge them if they are the same.

Where do I find the "2" computer names. Its only showing the one computer ? where do I merge ?

Joe.

If you search under all Computers you should be able to see them both. The merge can be done from the report.

Hi, did that - it still only comes up with the one PC. Just to clarify - I am going to Manage -> computers. I am selecting the default organisation view and doing the search there. Just the one computer. I'm puzzled (not for the first time with this SW)

Joe.

You are using 7.0?

Then use the search box in the top right corner.

Most of the time you can merge the machines with no consequences.

sorry if I gave the impression that I dont know how to use search (-;
Believe me - there is only 1 PC listed with the hostname that its saying there is a duplicate of.
Its getting to the point I cannot be bothered raising calls with symantec anymore with this software.

Joe.

Then take a look in the vComputer view within the SQL database. See if there are 2 entries for the machine name.

Hi, thainks fro that - I had alook and its only listed once. Theres also 3 guid entries with no other details! will these be taking up licenses ?

I have the same issue.  I run the "Computers with duplicate name" report, and get about 9 machines in the list and they're only listed once. Not too sure what to do with them. BTW, using SMC Version 7.0.8641 

Then it seems the report is broken. I'm currently not behind a NS.
Could someone clone the report and copy the raw SQL query in the thread?

DECLARE @v1_TrusteeScope nvarchar(max)
   SET @v1_TrusteeScope = '%TrusteeScope%'

IF '%N%' = 'ALL'
BEGIN
SELECT     vComputer.Guid AS '_ItemGuid', [Name], Domain, [OS Name], [Guid] AS [Machine Guid], [Server]
FROM         vComputer INNER JOIN [fnGetTrusteeScopedResources](@v1_TrusteeScope) AS [fnGTSR_3]
         ON [vComputer].[Guid] = [fnGTSR_3].[ResourceGuid]
WHERE     (Domain LIKE '%Domain%') AND ([OS Name] LIKE '%OSName%') AND ([Name] LIKE '%Name%') AND ([Guid] IN
                          (SELECT     _ResourceGuid
                            FROM          Inv_AeX_AC_Identification AS i1
                            WHERE      ((SELECT     COUNT(*) FROM Inv_AeX_AC_Identification AS i2
                                                      WHERE     ([Name] = i1.Name) AND (Domain = i1.Domain)) > 1)))
END
ELSE
BEGIN
SELECT  %N%   vComputer.Guid AS '_ItemGuid', [Name], Domain, [OS Name], [Guid] AS [Machine Guid], [Server]
FROM         vComputer INNER JOIN [fnGetTrusteeScopedResources](@v1_TrusteeScope) AS [fnGTSR_3]
         ON [vComputer].[Guid] = [fnGTSR_3].[ResourceGuid]
WHERE     (Domain LIKE '%Domain%') AND ([OS Name] LIKE '%OSName%') AND ([Name] LIKE '%Name%') AND ([Guid] IN
                          (SELECT     _ResourceGuid
                            FROM          Inv_AeX_AC_Identification AS i1
                            WHERE      ((SELECT     COUNT(*) FROM Inv_AeX_AC_Identification AS i2
                                                      WHERE     ([Name] = i1.Name) AND (Domain = i1.Domain)) > 1)))
END