The Orion Platform

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

State Not Answered
Locked Locked
Replies 9 replies
Subscribers 11 subscribers
Views 2324 views
Users 0 members are here

Options

Related

This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

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

joel.regado over 7 years ago

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?

Top Replies

orioncrack over 7 years ago +1

Someone recently posted something very similar that I use but now I can't find it here...
It was named Server+Report.xml I believe.

Parents

0 ladames over 7 years ago

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'
Cancel
Up 0 Down

Cancel

Reply

0 ladames over 7 years ago

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'
Cancel
Up 0 Down

Cancel

Children

No Data

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