Video Screencast Help

Computers with duplicate Hostname report showing blank

Created: 07 May 2014 | 4 comments

HI

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

Operating Systems:

Comments 4 CommentsJump to latest comment

Anton_Nejolov's picture

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
 from vComputer
 where Name in ( select Name
 from vComputer group by Name
 having count (*) > 1
 )

 

CBZ9104's picture

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?????

Anton_Nejolov's picture

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.

SK's picture

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.

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.