Remove old Machines

[gutodb]

I have several machines that do not communicate for more than 30 days, how do I remove them automatically?

[mrmcfu]

SQL

[jmarmo]

delete from tblcomputers where lastseen < getdate()-30

How do I execute this? from the scripts window or as a custom action?

[Hemoco]

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

[Hemoco]

you can try (not checked for syntax errors)

delete from tblcomputers where lastseen < getdate()-30

[gutodb]

Thanks for the information, but how do I identify and remove machines with more than 30 days without communication in the current version?

[Hemoco]

The current version does not support automatic removal, you need to do this manually from the configuration utility.
The next version will support this.