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.

Comprehensive Server Report (CPU, Memory, Disk and Availability)

Hi,

Is there a way to create a report for server utilization based on last 30 days or Last Month? The columns should be

NodeID      NodeName     CPU     Memory     Disk          Availability

1                 Server A          80%     99%          C: 70%          99%

                                                                         E: 65%

Can this be done via query?

Parents
  • select

    nodez.NodeID as id,

    Nodez.Caption as Servername,

    HDD.CapacityB as HDDsize,

    hdd.Model,

    hdd2.VolumeName,

    hdd2.CapacityB,

    Nodez.DeviceRole as DeviceRole,

    IPAddr.IPAddress as 'IP Addresses'

    FROM dbo.Nodes AS Nodez

    join dbo.NodeIPAddresses as IPAddr on Nodez.NodeID = IPAddr.NodeID

    join dbo.AssetInventory_HardDrive as HDD on Nodez.NodeID = HDD.NodeID

    join dbo.AssetInventory_LogicalDrive as HDD2 on Nodez.NodeID = HDD2.NodeID

    where DeviceRole = 'server'

Reply
  • select

    nodez.NodeID as id,

    Nodez.Caption as Servername,

    HDD.CapacityB as HDDsize,

    hdd.Model,

    hdd2.VolumeName,

    hdd2.CapacityB,

    Nodez.DeviceRole as DeviceRole,

    IPAddr.IPAddress as 'IP Addresses'

    FROM dbo.Nodes AS Nodez

    join dbo.NodeIPAddresses as IPAddr on Nodez.NodeID = IPAddr.NodeID

    join dbo.AssetInventory_HardDrive as HDD on Nodez.NodeID = HDD.NodeID

    join dbo.AssetInventory_LogicalDrive as HDD2 on Nodez.NodeID = HDD2.NodeID

    where DeviceRole = 'server'

Children
No Data