Computers with no name

(imported topic written by MattBoyd)

I’m creating a custom report that returns a list of computers from a specific group that have not reported in for xx hours. For some reason, there is a computer listed with no name that has not checked in for 62 days and is not listed in the BigFix console. What’s the best way to get rid of this computer record?

(imported comment written by BenKus)

Hey boyd,

That sounds weird… try this:

Find the ID of it (id of bes computer whose (not exists name of it)) and then open the COMPUTERS table in the database and change the IsDeleted column to 1. You might need to clear your console/web reports cache after you update this table manually.

Ben

(imported comment written by MattBoyd)

Thanks Ben,

That eliminated that computer record. However, I ran that query and found about 60 computers without a name. Is this normal?

Is there a command in the Bes Computer Removal tool that will eliminate these?