All, I am looking for some SWQL/SQL code that can pull out the following information from the database. Columns Include: * Server Name * IP Address * CPUs * RAM amount * C:\ Percentage Used * E:\ Percentage Used * and all other volumes on the server

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Volumes Status

CourtesyIT

All, I am looking for some SWQL/SQL code that can pull out the following information from the database.

Columns Include:

Server Name
IP Address
CPUs
RAM amount
C:\ Percentage Used
E:\ Percentage Used
and all other volumes on the server

Find more posts tagged with

volumes

Accepted answers

All comments

KMSigma.SWI

You can't have "all other volumes" in a field. You can have a report that's "grouped" by the Server Name, IP, etc. and then lists out the volumes under it.

If you just want the raw data, then it's a call to Orion.Nodes and a connection to Orion.Volumes via the Navigational Property.

SELECT [Nodes].SysName
     , [Nodes].IPAddress
     , [Nodes].CPUCount
     , [Nodes].TotalMemory
     , [Nodes].Volumes.DeviceID
     , [Nodes].Volumes.VolumePercentUsed
FROM Orion.Nodes AS [Nodes]
WHERE IsNull([Nodes].Volumes.DeviceID, '') <> ''
AND [Nodes].Volumes.VolumeType LIKE 'Fixed%'

CourtesyIT

this is a good starting point. I was hoping to list the devices down the left hand side with the CPU, Memory, and Drives listed across the top. Can we concatenate the memory down to 8GM, 16GB, etc...

KMSigma.SWI

SQL and SWQL don't natively work that way if you are using it raw. The reporting engine doesn't work that way either, but will situationally convert bits and bytes to storage sizes.

The only way to accomplish what you are trying to do is to use a third-part reporting engine over top of the extracted data. Each of those would have their own configuration processes.

CourtesyIT

Ok,

Thanks,