How to export full inventory?
-
I just need to export all inventory to a .xls or pdf.
-
Fog-srv is currently unable to handle this request.
HTTP Erro 500
-
@John-L-Clark Which version of FOG do you use? Can you please post a screenshot of the error page?
-
@sebastian-roth We are on 1.5.9 I am able to select AD_creditiels and then each model and get the report for that but we are needing all inventory.
-
-
I also get the same thing when I try to export all hosts.
-
@John-L-Clark Need to ask further questions as I am not able to replicate the issue. Do you have any of the plugins enabled?
Please check the Apache and PHP-FPM logs and post those here (see my signature on where to find those on your FOG server).
I am able to select AD_creditiels and then each model and get the report for that but we are needing all inventory.
What do you mean by select AD credentials? Are we actually talking about the “Report Management” page in the FOG web UI?
-
@sebastian-roth error.log I have attached the error log . Thank you
-
@John-L-Clark The error log did not get uploaded/posted. Please try again or upload to a file sharing platform and post a link here.
-
-
@sebastian-roth Here is a clip of the PHP log. Not sure what it means.
-
@John-L-Clark While there are a lot of warnings in the error.log I don’t think any of those is related to what you describe here. The log is being rotated every day by what it looks like so you might need to request the inventory report in the FOG web UI once more (best if you query the report twice to easier find this in the logs) and copy the error.log file just after that.
Without knowing more about this I could imagine a database maintenance might help here: https://wiki.fogproject.org/wiki/index.php/Troubleshoot_MySQL#Database_Maintenance_Commands (Stop imaging/multicasting before you run those commands and be aware that if you run all of those SQL queries that it will clear your history and userTracking table as well.)
-
@John-L-Clark Hmm, did see your post on PHP-FPM log just now. Looks like your setup is not handling the many requests you seem to get. How many machines with fog-client installed do you roughly have in your network?
You might need to adjust the PHP-FPM settings to your needs. Edit
/etc/php/7.4/fpm/pool.d/www.conf
and adjust values, then restart PHP-FPM (sudo systemctl restart php7.4-fpm
).There is a lot of information on the web on what settings might suite your setup (depending on server resources and so on):
-
@sebastian-roth I went through the entire database clean-up that you sent and I am still unable to run a full report of all inventory. Is there any way I can just get an Export of all hosts?
-
-
Looks like @John-L-Clark has a huge setup with many hosts. Talked in chat and figured that increasing the value of
php_admin_value[memory_limit]
in/etc/php/7.4/fpm/pool.d/www.conf
fixed the issue.Possibly moving to InnoDB could help here as well. Though this is not supported in an official release yet. Take a look at those topics:
https://forums.fogproject.org/topic/15162/the-list-all-hosts-tab-takes-a-long-time
https://forums.fogproject.org/topic/14254/high-cpu-usage
https://forums.fogproject.org/topic/14689/high-cpu-usage-on-fog-server/9