Computer resources show Name is the same as the IP Address

Products

• Client Management Suite
• IT Management Suite

Issue/Introduction

A few managed machines where there is no inventory show the Name is the IP Address.  How to identify where these are coming from?

Environment

ITMS 8.5 RU3

Resolution

The following query shows these machines and provides the Product Name to indicate how they might be coming into the database.  This query is as-is can be modified as needed:

select

       --vi.Guid AS [Computer Guid],

       vc.Name AS [Computer Name],

       vc.[IP Address],

       vc.CreatedDate,

       --vc.IsManaged,

       --vi.ClassGuid,   --'539626D8-A35A-47EB-8B4A-64D3DA110D01' --Computer Resource

       --vi.ProductGuid,

       vi1.Name AS [Product Name]

from vcomputer vc

join vitem vi on vi.guid = vc.guid

join product pr on pr.ProductGuid = vi.ProductGuid

join vitem vi1 on vi1.guid = pr.ProductGuid

where vi.ClassGuid = '539626D8-A35A-47EB-8B4A-64D3DA110D01'

--where vc.Name = vc.[IP Address]

order by 1 asc