Not all imported Hosts and VMs displayed about icingaweb2-module-vspheredb

[Thomas-Gelf]

@Ththu: that's strange. Any errors shown in the log?

There are no errors showing up in the logs (apache, php).

What I found was, that on vspheredb.object table just one vcenter_uuid is available. The one for the system that gets displayed. It seems that data from the systems excluded doesn't make it into object table.

If I run the following query: SELECT vcs.host AS name FROM object AS o INNER JOIN vcenter_server AS vcs ON vcs.vcenter_id GROUP BY o.vcenter_uuid; I get one line with the host I already know...

If I run it without grouping, I get also references to the missing hosts.

It's also strange that event history from the missing hosts is displayed. I see e.g. events like VM poweredOFF, VM reconfigured.

[Thomas-Gelf]

As you have noticed, uuids are stored binary. You can use HEX(uuid) and similar to get a readable output. "Without grouping" might be a good hint, are you able to show me query/result with and without your phantom VM? Let me know if you need help with the queries!

[Thomas-Gelf]

ping