How to add location field to generate Summary by Location report?

For example, following (ESXi) Hosts -Summary by Version widget has no geo information.

I need to generate Hosts- Summary by Locations (Data Centers).
Looks like I will need a DB table record hostname/IP address to location relationship.

My hope is that I can successfully integrated my phpipam instance (which has location code) into miq as network provider.

How are you guys doing this ?