Zabbix PDF, Excel & SLA Report Generator [Multiversion]

[kronicklez]

Hi @AxelDelCanto,

On "Detailed Host Inventory" i can see the data when generate to excel. But On "Generak Host List" and "Peak Report" i cannot see any data when generate to excel. Btw when i try do filter by "Host group" it throw error.




Thanks

[AxelDelCanto]

Can you give me more details? I can generate the data without any problems.

[kronicklez]

Hi @AxelDelCanto,

Below is snapshot. Not sure whether i'm mis-interpretation of "Peak Report".

[AxelDelCanto]

I understand the problem now. It's not finding the key for the CPU and Mem item. Let me check if I can add it manually and upload the fix.

[AxelDelCanto]

Updated. download generate_excel.php and replace.

[kronicklez]

Hi @AxelDelCanto,

Now i can see data on excel after replace file generate_excel.php as per your advised. By the way the output data on "General Host List & Peak Report" not in organize in the column excel like "Detailed Host inventory". Below is snapshot. Can u check on that. Thanks

[kronicklez]

Hi @AxelDelCanto,

I'm try add one by one filter and it throw error when i try add CR-STWNGS01. In your "latest_data.php" i try change value limit to 50000 but still throw error. Is it the maximum just 5k only?

[kronicklez]

Hi AxelDelCanto ,

I have replace the latest_data.php from your Github but in my case it still throw error. After replace i'm restart apache services.

Thanks

[AxelDelCanto]

Hi kronicklez,
I want to be transparent about something important regarding how the tool is designed to be used.
The Latest Data page is not intended to load all items from multiple large groups simultaneously without any filter. Selecting 7 groups that result in 5000+ items is essentially asking the tool to download your entire Zabbix database at once even Zabbix's own native "Latest Data" page struggles or times out under those conditions.
The correct workflow for large environments is:

Select your host groups
Type a keyword in "Filter loaded items..." (e.g. "CPU", "Memory", "Interface", "ping")
Then click Apply the query will only fetch items matching that keyword, which is fast and manageable

This is how the tool is designed to work. The item name filter is there precisely for this reason.
That said, I take responsibility for not making this clear enough in the interface. The next update will include a warning message when the selected groups are likely to return a very large number of items, guiding you to add a keyword filter first.
Thanks for your patience and for pushing the tool to its limits your feedback genuinely helps improve it for everyone.

[kronicklez]

HI AxelDelCanto ,

Noted. It's ok no issue. Thanks for your explanation. Btw can u take a look excel issue that i mention previously?

Thanks

[kronicklez]

Hi @AxelDelCanto,

Can u check on excel generate site. Seems it like previous early pdf issue cannot display many device as per below snapshot. Also can i suggest u add arrow to end of pages. Thanks and appreciate your help




Add error to end of pages.

[AxelDelCanto]

Hi kronicklez
I'm pushing a final update that addresses the "Error loading data" issue in the Detailed Host Inventory page, along with a quality-of-life improvement for both that page and the main Latest Data view.
What's fixed:
The Detailed Host Inventory was making a single massive API call to fetch items for all hosts at once the same root cause as the timeout issue in Latest Data. It now fetches items in batches of 20 hosts, which prevents the timeout even with large environments (1000+ items across multiple groups).
What's new Large Selection Warning:
Both Latest Data and Detailed Host Inventory will now show a warning banner when you select 3 or more groups (or 50+ hosts) without typing a keyword in the item filter. The banner reads:
"Large selection detected Loading many groups without a keyword filter may be slow. For best results, type a keyword in Filter loaded items... before clicking Apply (e.g. CPU, memory, ping)."
This is the intended workflow for large environments filter by keyword first, then Apply. The tool is not designed to load an entire Zabbix database at once, and neither is Zabbix's own native Latest Data page under those conditions.
Files to replace:

latest_data.php -> project root
data-preview/index.php -> data-preview folder
data-preview/get_items_preview.php -> data-preview folder

This will be the last update I'll be actively supporting. The project remains available on GitHub for the community. Thanks to everyone who tested and reported issues, your feedback made the tool significantly more robust.
Best regards,
Axel Del Canto