
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-07-2009 01:12 AM
I have several machines that do not communicate for more than 30 days, how do I remove them automatically?
Labels:
- Labels:
-
Archive
6 REPLIES 6

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-10-2009 10:55 PM
SQL

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-09-2009 09:59 PM
delete from tblcomputers where lastseen < getdate()-30
How do I execute this? from the scripts window or as a custom action?
How do I execute this? from the scripts window or as a custom action?

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-11-2009 03:53 PM
jmarmo wrote:
delete from tblcomputers where lastseen < getdate()-30
How do I execute this? from the scripts window or as a custom action?
In the configuration program you can run it as an sql script

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-07-2009 10:44 PM
you can try (not checked for syntax errors)
delete from tblcomputers where lastseen < getdate()-30

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-07-2009 10:19 PM
Thanks for the information, but how do I identify and remove machines with more than 30 days without communication in the current version?

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-07-2009 08:53 PM
The current version does not support automatic removal, you need to do this manually from the configuration utility.
The next version will support this.
The next version will support this.
