SWQL to return counters from Solarwinds services

robert777

Hi All.

I'm looking to build a widget (and possibly report) showing resource usage for the Solarwinds services on each polling server.

I think data source would most likely be a SWQL query.

Query will return the name of each polling server, with a list of Solarwinds services under that, and for each service basic counters like Percent CPU, Physical/Virtual memory used, IO reads/writes/total.

I welcome any input from the community on the best way to write such a query / build such a widget. Thanks much.

christopher.t.jones123

@robert777, something like below is a great starting point for this. Just ensure you modify the custom property being referenced in the where statement. 

SELECT 
CS.Component.Application.Node.Caption
,CS.Component.Application.Name, CS.ComponentName
, CS.ComponentPercentCPU
, CS.ComponentPercentMemory
, CS.ComponentMemoryUsed
, CS.ComponentPercentVirtualMemory
, CS.ComponentVirtualMemoryUsed
, CS.ComponentIOReadOperationsPerSec
, CS.ComponentIOWriteOperationsPerSec
, CS.ComponentIOTotalOperationsPerSec
FROM Orion.APM.CurrentStatistics CS
where CS.Component.Application.Node.CustomProperties.SupportedApp like '%SolarWinds%'

then it makes it easy to do something like this