Reporting on a Group of Servers

I'm pretty new to this and finding it difficult to report on a group of servers. I've been tasked on creating a dashboard that can show server uptime, CPU, RAM and disk space.

I've been able to group the servers in Node and Group management --> Manage groups. This does create a dashboard of a kind however I need to add more to it.

Can anyone help advise?

Find more posts tagged with

orion

how-to

solarwinds_npm

Comments

ChrystalT

If you're using the groups functionality, there's a built-in group details page which may get you some of the way to what you're looking for. You also have the option of creating a new modern dashboard, classic view, or report to get the information that you need. I'd suggest familiarizing yourself with the functionality to build what you're looking for. There's classes in the Academy to help with learning that functionality, or you're welcome to review the admin guide.

NVSteven

You can create a modern dashboard to display the information. Here is something to get you started. Please mark answered if applicable.

SELECT 



n.Description, n.LastBoot,n.Status,n.StatusIcon,n.StatusDescription, n.StatusIconHint,n.StatusLed, 
n.NodeName,n.DNS, n.MachineType, n.Category,n.PercentMemoryUsed, n.CPUload,n.IPAddress, n.DetailsUrl,n.Agent.AgentStatus AS Agent_AgentStatus,n.Agent.AgentVersion AS Agent_AgentVer,n.Agent.ConnectionStatus AS Agent_ConnectionStatus,n.Agent.DNSName AS Agent_DNSName,n.Agent.OSType AS Agent_OSType,n.Agent.OSVersion AS Agent_OSVersion,n.Agent.AgentStatusTimestamp AS Agent_AgentStatusTimestamp,n.Agent.PollingEngineId AS Agent_PollingEngineId, n.Agent.RegisteredOn AS Agent_RegisterOn, n.AssetInventory.LogicalDrive.Sizeb, n.AssetInventory.LogicalDrive.SpaceAvailableB AS Node_DrvSpcAvl,n.AssetInventory.LogicalDrive.FreeSpaceB,n.AssetInventory.LogicalDrive.VolumeName,n.AssetInventory.LogicalDrive.DeviceID as VolumeID,n.AssetInventory.ServerInformation.VirtualMemoryB AS Virtual_Mem,
round((n.AssetInventory.ServerInformation.VirtualMemoryB / 1073741824.0),2) as Virtual_Mem_GB,
round((n.AssetInventory.LogicalDrive.FreeSpaceB / 1073741824.0),2) as FreeSpace_GB,
round((n.AssetInventory.LogicalDrive.sizeB / 1073741824.0),2) as VolumeSize_GB,
round(((n.AssetInventory.LogicalDrive.sizeB - n.AssetInventory.LogicalDrive.FreeSpaceB)  / 1073741824.0),2) as VolumeSpaceUse_GB

,CONCAT ( n.AssetInventory.LogicalDrive.DeviceID, n.AssetInventory.LogicalDrive.VolumeName,' size is ',(round(ToString(n.AssetInventory.LogicalDrive.sizeB / 1073741824.0),2) ),' gb' ) AS [Volume Info]

,CONCAT (
                  DayDiff(N.LastBoot, GetDate())
                  , ' days'
                  ) AS [Days Up]

FROM Orion.Nodes n

bobmarley

Try downloading one of the modern dashboards from the Content Exchange. If you find one you like edit the SWQL queries withing the modern dashboard to show just the group you are interested in.

DanSieb

Thanks for all the advice. Really appreciate it. @NVSteven Maybe a basic question however how do you insert this code? I can see you can create a modern dashboard and then add widgets. Is there a particular widget that I should be using?

DanSieb

Actually I've figured it out and it works. Thank you so much for the code. The only thing I need now is focus it down onto a group of servers. All the servers start off with the same kind of name so I figured something like this would work at the end but it doesn't. FROM Orion.Nodes WHERE n.Node.Name = 'UK-IT-PIM11'

Any ideas where I'm going wrong?

DanSieb

I have found a search option that kind of does the job.

NVSteven

n.Node.Name like '%UK-IT-PIM11%'