2017-01-20 05:14 AM
I am working on few reports for storage, switches and hosts and customer requirement is to show the last reported time. I can find that as "lastAcquiredTime" in database for storage and switches, but that is missing in host table.
However in OCI server, I can see the the "Last Report Time" in hosts view, but same is not reflecting in host table of DWH MySQL. I am not condering VM in that as VMs are discovered by ESX and I expect ESX should be part of physical host table.
Solved! SEE THE SOLUTION
2017-01-20 07:21 AM
Most hosts are discovered through a combination of switch and storage data sources, so a "last acquired time" for a host might be a bit ill-defined. dwh_inventory might have enough data source information to get you back to the (switch) data source associated with a host, and get the last acquired time for the corresponding switch. Or work your way back to the switch through FC connectivity information for the same thing.