Computer records with no name or inventory data are displayed in the SMP Console

Products

• IT Management Suite

Issue/Introduction

Computers with no name and very little inventory data show in the SMP Console under Manage>Computers.  Often if these are deleted, they get recreated.

Environment

ITMS 7.x, 8.x

Cause

  This issue can be caused by a number of factors:

• an agent contained in an OS image,
• resource merging,
• invalid records being imported from active directory. 

Resolution

A simple solution to this issue is to stage a script to run nightly which will delete these empty records.  The script looks for computers with a null name and inserts them into Item to Delete.  

insert into ItemToDelete (Guid,DeleteDate)
select c.Guid, GETDATE()
from vRM_Computer_Item c
left join ItemToDelete d on d.Guid = c.Guid
where c.Name = ''
 and d.Guid is null

To stage the script, create a new task, "Run SQL Query on Server" and insert the above query.  Schedule to run nightly.