Running a Report to show Virtuals and their associated Physical Host (ESX and Solaris10)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-02-2012 08:33 PM
I have a requirement to run a report to show the virtual instance and the physical server on which it runs, for both Windows (ESX/VCenter) and Solaris 10. This information is easily found when one displays a particular instance of an ESX host, as the tab at the bottom of the CI record shows the Virtual Machine instances, and can also be found from Solaris 10 instances. However, because this data spans multiple tables, the report is not as straightforward to create, and requires (I believe) a view. However, I am not able to find the column to join on between, in the case of ESX (cmdb_ci_vm_instance) and the associated virtual machine instances (cmdb_ci_esx_server). So...how does one create a view like this? I'm sure I cannot be the only user that has a need like this...any assistance would be appreciated?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-02-2012 08:35 PM
Mistake in my post above...the sentence that starts: "I am not able to find the column to join on between, in the case of ESX..."
Should read:
I am not able to find the column to join on between, in the case of ESX (cmdb_ci_esx_server) and the associated virtual machine instances (cmdb_ci_vm_instance).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-03-2012 05:26 AM
The ESX server and VM instances are related through cmdb_rel_ci.
A view where the cmdb_rel_ci.child is your ESX server's sys_id and the cmdb_rel_ci.type is the Registered on::Has registered type's sys_id should do the trick.
