Seeing a few computer resources that the Name is the same as the IP Address

book

Article ID: 197076

calendar_today

Updated On:

Products

Client Management Suite

Issue/Introduction

Seeing a few machines where there is no inventory and the name is the IP Address.  How to identify where these are coming from?

Environment

Release : 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 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