• State Verified Answer
  • Locked Locked
  • Replies 16 replies
  • Subscribers 15 subscribers
  • Views 1845 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Combined capacity report of all server in one page

krishnamishra0786

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
  • 0

    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
  • 0

    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

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.