Combined capacity report of all server in one page

Hi All,

I want a create a customize capacity report, where I can get report of all node in one format where I can get like - DISK (Name, Uses, free space
etc), CPU (Count, Load, etc.), MEMORY (total memory, Peak Average),

Kindly any one can help us to get the such type of report

Parents
  • This should work for the Procs. Check it and let me know

    select

    --VM.Name,

    --VM.PowerState as PowerState,

    node.Caption,

    node.MachineType,

    Hardware.AgentVersion,

    hardware.Manufacturer,

    hardware.Model,

    procs.NumberOfCores,

    --procs.NumberOfThreads,

    procs.Manufacturer,

    procs.Name,

    procs.Stepping,

    procs.Caption,

    procs.SpeedMHz,

    procs.NumberOfCores,

    node.DeviceRole as devicerole

    from VIM_VirtualMachines as VM

    full outer join dbo.Nodes as node on vm.NodeID = node.NodeID

    full outer join dbo.APM_HardwareInfo as Hardware on Hardware.NodeID = node.NodeID

    full outer join dbo.AssetInventory_Processor as procs on procs.NodeID = node.NodeID

Reply
  • This should work for the Procs. Check it and let me know

    select

    --VM.Name,

    --VM.PowerState as PowerState,

    node.Caption,

    node.MachineType,

    Hardware.AgentVersion,

    hardware.Manufacturer,

    hardware.Model,

    procs.NumberOfCores,

    --procs.NumberOfThreads,

    procs.Manufacturer,

    procs.Name,

    procs.Stepping,

    procs.Caption,

    procs.SpeedMHz,

    procs.NumberOfCores,

    node.DeviceRole as devicerole

    from VIM_VirtualMachines as VM

    full outer join dbo.Nodes as node on vm.NodeID = node.NodeID

    full outer join dbo.APM_HardwareInfo as Hardware on Hardware.NodeID = node.NodeID

    full outer join dbo.AssetInventory_Processor as procs on procs.NodeID = node.NodeID

Children
No Data