Discovery and Inventory Group

 View Only
  • 1.  Computers with duplicate Hostname report showing blank

    Posted May 07, 2014 03:03 AM
      |   view attached

    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



  • 2.  RE: Computers with duplicate Hostname report showing blank

    Posted May 07, 2014 07:04 AM

    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
     )

     



  • 3.  RE: Computers with duplicate Hostname report showing blank

    Posted May 07, 2014 07:28 AM

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



  • 4.  RE: Computers with duplicate Hostname report showing blank

    Posted May 07, 2014 09:02 AM

    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.



  • 5.  RE: Computers with duplicate Hostname report showing blank

    Posted May 08, 2014 07:43 AM

    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.