Video Screencast Help

Delete computers off agent install consul

Created: 12 Sep 2013 | 8 comments

I can't delete these computers, they are mac's and why are they on the windows side. Windows computers delete like usually, please help thanks.



Operating Systems:

Comments 8 CommentsJump to latest comment

AltirisJunkie's picture

Just run this SQL command to purge the data.

truncate table AgentPushData

If you still continue to have issues deleting future installed computers form the Consoel Agent Install page, I would get with support.



Thomas Baird's picture

Turns out there is a table in SQL called "AgentPushData" you can manually delete these records from.  These records should ONLY come in from when added manually, and no other process should populate this table, so you can delete directly from this table with no harm.  They should not "come back".  The only way I can think of for them to come back is if you added an IP Address at some point, and from DNS or something we "resolved" to a MAC.  But that's still manually added, just not "on purpose" if that makes any sense.

Anyway, we have seen this before and you can safely delete directly from that table.

Thomas Baird
Enthusiast for making things better!

Thomas Baird's picture


Thomas Baird
Enthusiast for making things better!

tfreeman's picture

Thanks everyone for your help that cleared all the date, so I think I'm good.

tfreeman's picture

Nope sorry spoke to soon. they came back as soon as I discovered a windows computer and tried to push it out all the mac's showed back up so it didn't fix it.


PeeGee's picture

Do you have Asset Management installed?

If yes, go to > Manage > Assets  > Manage Configuration Items > Computers and Peripherals > Computer

If you have computers there is "empty" name, mark them all and delete them.

If you don't have asset mgmt, you can try to go to > Manage > All Resources and try to see if you have lots of empty named devices there.

Deleting them might resolve your issue here.