Error when trying to chart UPS data (Power Control Unit)

shuth

I am trying to chart the data that SolarWinds can now natively pull from certain UPS devices but no matter what I try I can't get the data to show. Has anyone been able to do this and if so, how?

Here is an example device. It is pulling out various metrics including output load, battery capacity, temperature, and runtime remaining.

These UPS's have a custom Node Details view and I want to be able to display charts with the above metrics. 

Attempt 1 - Custom Chart

• Add a Custom Chart resource and choose the "Use current object as Data Source".
• Change the object to the UPS metrics and pick a metric, e.g. temperature
• No matter what Time Period or interval I select, the chart shows the following error:  "There was an error while loading data for this resource. error"

Attempt #2 - Custom Chart with a custom query datasource

• Add a Custom Chart resource and choose a new datasource with a SWQL query. I brought out a whole bunch of different metrics in the query but none worked.
• When adding the data series to the axis, no matter which metric I tried to display, same error.
• No matter what Time Period or interval I select, the chart shows the following error:  "There was an error while loading data for this resource. error"

SELECT m.PowerControlUnit.Node.NodeId, ElementId, AvgBatteryCapacity, MinBatteryCapacity, MaxBatteryCapacity, AvgBatteryTemperature, MinBatteryTemperature, MaxBatteryTemperature, AvgTimeOnBattery, MinTimeOnBattery, MaxTimeOnBattery,  AvgOutputPercentLoad, MinOutputPercentLoad, MaxOutputPercentLoad, AvgRunTimeRemaining, MinRunTimeRemaining, MaxRunTimeRemaining, ObservationTimestamp
FROM Cortex.Orion.PowerControlUnit.Metrics m
WHERE m.PowerControlUnit.Node.NodeId = ${NodeID}
ORDER BY ObservationTimeStamp ASC

 

Any suggestions?

wesleykparker

Was looking for some related data and saw your question.  I've run into this before.  Here is how I work around it.

Use your option 2 with the custom SWQL as the datasource.  Add another column to your query to use as the Legend.  I would use something like "'on UPS' as Legend"

SELECT m.PowerControlUnit.Node.NodeId, ElementId, AvgBatteryCapacity, MinBatteryCapacity, MaxBatteryCapacity, AvgBatteryTemperature, MinBatteryTemperature, MaxBatteryTemperature, AvgTimeOnBattery, MinTimeOnBattery, MaxTimeOnBattery,  AvgOutputPercentLoad, MinOutputPercentLoad, MaxOutputPercentLoad, AvgRunTimeRemaining, MinRunTimeRemaining, MaxRunTimeRemaining, ObservationTimestamp,  'on UPS' as Legend
FROM Cortex.Orion.PowerControlUnit.Metrics m

WHERE m.PowerControlUnit.Node.NodeId = ${NodeID}
ORDER BY ObservationTimeStamp ASC

Now you should be able to select which columns you want to chart (including using the "more" button to add ObservationTimestamp column as the time series for each field you want to chart. 

Lastly, in the "Data Grouping" section:

Use the NodeID field as the "Group Chart Data By:"

Use the Legend field as the "Legend shows:"