SQL script to cleanup database

[Greg Plamondon]

does anyone have a cleanup query to cleanup hosts in the database that haven’t reported back in a specified amount of time?

[Tom Elliott]

We don’t keep track of when hosts check in. I guess the closest you could use would be the hostSecTime in the hosts table as it should be regularly cycled. So anything with a last synced time from or earlier than said date could work?

[Greg Plamondon]

@tom-elliott
Thanks Tom