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

  • I think no have solution for this request emoticons_happy.png

  • I didnt see this. I should be able to do a little something later today or tomorrow.

  • Thanks. Looking forward to any kind of inventory report that works for Linux/Windows inventory on one report.

    The other recent inventory report thread doesn't have disk info or Linux details.

  • 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

  • This should be everything you need,

    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,

    Hdd.Model,

    HDD.SerialNumber,

    HDD2.VolumeName,

    Hdd2.FileSystem,

    hdd2.CapacityB,

    Hdd2.FreeSpaceB,

    Hdd2.VolumeName,

    Ram.Model,

    ram.CapacityMB,

    ram.SpeedNSec,

    ram.Slot,

    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

    full outer join dbo.AssetInventory_HardDrive as HDD on HDD.NodeID = node.NodeID

    full outer join dbo.AssetInventory_LogicalDrive as HDD2 on HDD2.NodeID = node.NodeID

    full outer join dbo.AssetInventory_MemoryModuleView as Ram on Ram.NodeID = node.NodeID

    full outer join dbo.AssetInventory_MemoryModule as Ram2 on Ram.NodeID = node.NodeID

  • I copy and paste the code and its invalid in the query window.

    Can someone reveal the secret to copying and pasting code from HTML posts to SW?

  • Opps I dont think you DeviceRole try this also are you using SQL Studio?

    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,

    Hdd.Model,

    HDD.SerialNumber,

    HDD2.VolumeName,

    Hdd2.FileSystem,

    hdd2.CapacityB,

    Hdd2.FreeSpaceB,

    Hdd2.VolumeName,

    Ram.Model,

    ram.CapacityMB,

    ram.SpeedNSec,

    ram.Slot

    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

    full outer join dbo.AssetInventory_HardDrive as HDD on HDD.NodeID = node.NodeID

    full outer join dbo.AssetInventory_LogicalDrive as HDD2 on HDD2.NodeID = node.NodeID

    full outer join dbo.AssetInventory_MemoryModuleView as Ram on Ram.NodeID = node.NodeID

    full outer join dbo.AssetInventory_MemoryModule as Ram2 on Ram.NodeID = node.NodeID

  • Hi,

    I appreciate the help on a report that should have been made available 15 years ago. emoticons_happy.png

    I am copying your code into a new report window/SQL code as I have done before with other code. It breaks with either type option. I'm sure the formatting isn't right copying from here....thanks

    6-22-2016 8-45-23 AM.jpg

  • I just want to also define the problem we're trying to solve so anyone else can chime in if needed. It seems myself and the OP are the only people on the planet that need a very basic server inventory report from SolarWinds.

    Most companies have PMs/DBAs/Admins/Janitors that want server reports that target a specific group of servers. With SolarWinds it is impossible to do that out of the box.

    PMs and other interested parties simply want to see:

    1. Server name

    2. Processor count

    3. Memory count

    4. Disk volumes (logical, cluster, mount) count

    5. OS type

    Thats it.

    With SCOM I have a simple report that does this for me. Yes, they still have Microsoft misspelled in the 2008 MP, lol...:)

    This one I cooked up doesn't have disk size though. Something funky with this client's servers, so I left it out. You get the idea of what we're looking for though.

    scom-servers.jpg