Report - Imaging host report

[ITCC]

trying to run the imaging report but get an error
http://SERVER/fog/management/index.php?node=report&sub=file&f=aW1hZ2luZyBsb2c=

This page isn’t working
fog-server is currently unable to handle this request.
HTTP ERROR 500

I have updated in the last 10 mins to git “working” to try and fix it.

Please advise

[Tom Elliott]

@itcc most likely it’s related to memory overlimit. The imaging log is never really cleaned up, and as such it can become very large over time.

[ITCC]

can I have an SQL command to clean the tables required so i can start it from now?

[ITCC]

Even better would be one what deletes all records older than 3 months or the last 200 imaging logs

[ITCC]

If anyone else needs this:

I cheated but it worked for my needs
My personal notes =

Imagelog cleanup
Downloaded MySQL Workbench to complete tasks

See records to be deleted.
SELECT * FROM fog.imagingLog where ilImageName NOT LIKE ‘%<latest image name>%’;

Delete Records (Rerun command until effected rows =0) - due to safety feature in Workbench
DELETE FROM fog.imagingLog where ilImageName NOT LIKE ‘<latest image name>’ LIMIT 1000;