Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

How to auto remove/purge old computers from Console?

Created: 21 Jan 2010 • Updated: 08 Oct 2010 | 2 comments

Is there a setting somewhere that you're able to have the console auto remove/purge/delete computers that haven't logged into the server in certain number of days?

Comments 2 CommentsJump to latest comment

RFredette's picture

I built a query against the Express database to find info about computers including their last Inventory.  Since our server is set to query inventory on a periodic basis this is a fairly good field to use.  Below is the query - you will need to use MS Query or another SQL tool:

SELECT computer.name, computer.prod_name, computer.serial_num, hardware.ram_total, computer.last_inventory, computer_group.name
FROM eXpress.dbo.computer computer, eXpress.dbo.computer_group computer_group, eXpress.dbo.hardware hardware
WHERE computer.group_id = computer_group.group_id AND computer.computer_id = hardware.computer_id
ORDER BY computer.name