We using Client Management Suite 7.5
When We pulled out Computer summary report in that we found around 40 computers duplicate hostname, but when we open report available under Reports -- All Reports -- Notification Server Management -- Agent -- Computers with duplicate name it showing blank
Seems that report is configured to display duplicates in case of special conditions.
You can use this query to display computers with duplicate names:
Select Guid,Name, Domain
where Name in ( select Name
from vComputer group by Name
having count (*) > 1
Ok.... The given query is fine but you saying report is configured to display duplicates in case of special conditions what will be the special conditions any idea?????
Accoring to the report query it looks like:
Query shows duplicates of computer's HostName and DomainName from inventory table and mapping this information with active computers from RM_ResourceComputer.
Perhaps your computers don't have duplicate domain name, or Inventory hostnames differ with RM_ResourceComputers, etc.
SELECT COUNT (*) FROM vComputer
SELECT DISTINCT Name FROM vComputer
If the result sets match, then you dont have any duplicate names.
If the first result set is larger than the second one, then you do have duplicate names.