SQL script to cleanup database
does anyone have a cleanup query to cleanup hosts in the database that haven’t reported back in a specified amount of time?
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?