search cancel

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

book

Article ID: 162893

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

Computers with no name and very little inventory data show in the console.  Often if these are deleted, they get recreated.

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.  

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

Attachments

delete_null_computers.sql get_app