Urgent Requirement/HELP in SAM

nags.vijayakumar

we have different independent Venue where we have ESX host in our environment (we have around 115 different venues across the globe).

1. I am creating a capcity report, in which I require every servers hosted in esx environment's disk space utilized in percentage, every venue is not centrally administered. all are different entity.

how do I get all these info in a single dashboard. I want to put a bar chart as well.

zackm

Assuming you have all of the ESX hosts being monitored via the VMware API through vCenter or the ESX CLI, you can look at the data pulled back into the database for this:

SELECT  Name 'VM Name'  ,GuestName 'Operating System'  ,IPAddress 'IP Address'  ,vDisksCount 'Virtual Disks'  ,TotalStorageSize/1024/1024/1024 'Total Storage GB'  ,TotalStorageSizeUsed/1024/1024/1024 'Total Storage Used GB'  ,VolumeSummaryCapacity/1024/1024/1024 'Total Volume GB'  ,(VolumeSummaryCapacity/1024/1024/1024) - (VolumeSummaryFreeSpace/1024/1024/1024) 'Total Volume Used GB'FROM VIM_VirtualMachineNodesWHERE GuestState = 'running'AND Heartbeat IS NOT NULL

If you want a report of the vmdk, that would be the Storage metrics. For the volumes presented to the individual VM guest OS's, that would be the associated Volume metrics

That being said, if you want more granular volume metrics, it would be much easier to just add all of your VMs as nodes into SolarWinds and report on them that way...

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

• LinkedIN: Loop1 Systems
• Facebook: Loop1 Systems
• Loop1 Twitter: @Loop1Systems
• ZackM Twitter: @ZackM