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?
Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.
Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)
Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG
-
@tom-elliott
Thanks Tom
