• 0

Reporting APC PDU power usage


Question

I have a client looking to monitor their colo rack power usage and have a monthly report showing consumed power.
Ultimately, they want to be sure they are being billed fairly by their hosting data center for the amount of power consumed.

the basic Idea is to use the snmp info from the PDU to aggregate the monthly power consumed.
Logic monitor has APC PDU data sources that include a "live" view of the amps per phase on the 3 phase PDU

Ideally, we want to avoid using APC datacenter expert or the like to manage the data.
Has anyone worked on converting the amps to kilowatts and reporting on that directly in logic monitor?

Link to post
Share on other sites

14 answers to this question

Recommended Posts

  • 1
  • Administrators

Yeah, you'll need to create a "Resource Metric Trend". Setup the filter so that it includes the instances you're interested in and the new live power usage datapoint. Then make sure the sum column is checked/included. It will sum the datapoint over the timeframe for each instance (row) in the report.

Link to post
Share on other sites
  • 1
  • Administrators
36 minutes ago, Mac said:

In an ideal world, id like to be able to refer to the calculated value of Watthours based on the current dashboard view time range

This is your feature request. I know it's already in the system, but you should throw your weight behind it. Every customer that requests it moves it up in priority for the Product Management team.

37 minutes ago, Mac said:

Near as I can tell, there is not a way to look at the first and last value in a data range for a dashboard.. it appears to be designed to look exclusively at the most recent data values.

That's correct.

37 minutes ago, Mac said:

However, the widgets are able to display a graph showing the historic data. So that makes me thinks there may be a way to reference the previous data values.

They do that because that's how those widgets are hard coded to work.

  • Like 1
Link to post
Share on other sites
  • 0
1 hour ago, Stuart Weenig said:

You'd need to know the RMS Voltage along with the Amps as well as the power factor (assuming AC). If those metrics are available via SNMP from the PDU, this should be doable.

Thanks Stuart.
the PDU I am testing with does not include the SNMP info for voltage and power factor with the default data source.
I will need to do an SNMP walk to see if i can pull that data manually 

i may need to test with a newer PDU as well. 

  • Like 1
Link to post
Share on other sites
  • 0
On 8/26/2020 at 8:53 AM, Stuart Weenig said:

You'd need to know the RMS Voltage along with the Amps as well as the power factor (assuming AC). If those metrics are available via SNMP from the PDU, this should be doable.

 

i've found that newer APC PDUs have a datasource for live power usage 
I am able to report on that with live data and see the graph for past usage

the next hurdle is to find a way to sum the usage for a given time period
I dont see a clear way to do that using any of the available dashboard widgets. 
Is this even possible?

the only possible solution Ive come up with is to assume power consumption will remain close to the same, then multiply the KW usage by a set integer representing hours of  month to estimate monthly KW hours consumed.
But this is a horrendously inaccurate representation for power usage over time. 

Any suggestions?

Link to post
Share on other sites
  • 0
On 8/28/2020 at 7:16 AM, Stuart Weenig said:

Yeah, you'll need to create a "Resource Metric Trend". Setup the filter so that it includes the instances you're interested in and the new live power usage datapoint. Then make sure the sum column is checked/included. It will sum the datapoint over the timeframe for each instance (row) in the report.

Thanks for all the assistance on this!

I was able to make the report and I can output the datapoint delta for the given time

my trouble now is that the report wants to automatically adjust the value for the large number. I dont seem to have anyway to adjust the output.

Device interface:45,154.2 kWh
SNMP Energy: 45154.2 (kWh)
SNMP EnergyRaw: 451542 (kWh tenths)

Report output
Energy: 45.15k
EnergyRaw: 451.54k

While these numbers are technically correct summaries for the input data, it is inaccurate representation of the actual units being tallied
You would not display the output of 45.15k kWh… it just doesn’t look right. And I cant add a unit reference or description to the report output. 

Secondarily, the Change(Delta) column doesn’t really explain what we are looking at if I give this report to a client. 
image.png.827663c44a8aa23acc1f9f5f13f83dc1.png

Is there any way to edit this type of report to make it more presentable?

Thanks again,
Mac

Link to post
Share on other sites
  • 0
  • Administrators

hehe, so it's saying 45.15 k kWh (thousand kiloWatt hours). 45 MWhours? Great Scot!

Yes, you can fix this and you probably should think about the graphs as you do this as well. Since the raw value is in 10ths, you should consider either modifying the existing datapoint or creating a new complex datapoint that converts from tenths of a kWh to Wh. That way the actual number is stored and both the graph and report will automatically scale (along SI units). So the actual value that gets stored would be 45154200, which is in Watt-hours. When the reporting system and the graphing system go to display them, they will automatically scale up to MWh.

Link to post
Share on other sites
  • 0
On 8/31/2020 at 11:26 AM, Stuart Weenig said:

hehe, so it's saying 45.15 k kWh (thousand kiloWatt hours). 45 MWhours? Great Scot!

Yes, you can fix this and you probably should think about the graphs as you do this as well. Since the raw value is in 10ths, you should consider either modifying the existing datapoint or creating a new complex datapoint that converts from tenths of a kWh to Wh. That way the actual number is stored and both the graph and report will automatically scale (along SI units). So the actual value that gets stored would be 45154200, which is in Watt-hours. When the reporting system and the graphing system go to display them, they will automatically scale up to MWh.

LOL, Yeah Mega Watt Hours... who knew we'd worry about that at a PDU level. 
This field is a "user resetable" number that id be no one ever resets. Mine were last rese years ago, probably the install date :)

I try not to edit the data sources because that means updating them from the repository will remove my changes. 
So I cloned the data source and added the complex datapoints I needed to track Watt Hours

after a few days i can confirm the report is displaying the data correctly
image.png.26b533868a52f8cba4a02b353a1eb0d3.png

My next hurdle is that this is a useful repot for internal testing, however it is not at all a clean customer facing report I could schedule and email monthly.
I understand that the data is stored and available to draw on for the metric report, but I cant see a way to build this as a clean dashboard or gauge. 
I guess I am asking if there is a "report designer" or maybe a means of making a gauge from this data now that I have it tracked?

Link to post
Share on other sites
  • 0
  • Administrators
1 minute ago, Mac said:

I try not to edit the data sources because that means updating them from the repository will remove my changes. 

This is no longer the case thanks to the new LM Exchange. When downloading updates to a DataSource, it kicks off Save LogicModule Merge, which identifies the difference between your installed version and the updated version. Then, for each difference, you get to walk through choosing to keep your version of that setting or the exchange version of the setting.

 

4 minutes ago, Mac said:

I guess I am asking if there is a "report designer" or maybe a means of making a gauge from this data now that I have it tracked?

Help me get a better idea of how you want to present the data. You mention gauge, does that mean you want to try to use a gauge widget?

LM Exchange Training Deck.jpg

  • Like 1
Link to post
Share on other sites
  • 0

Thank for the info on the data sources. I didnt know they would keep customizations now, thats awesome!

I am not sure what the best approach is to making the KWH usage into a clean customer facing report would be. Currently the only way to get that number is to use the resource metric trend report.

In an ideal world, id like to be able to refer to the calculated value of Watthours based on the current dashboard view time range
The data point should be simple enough.... (WattHours maximum value) - (WattHours minimum value) = Consumed WattHours for the given time range. 
If that data point could be calculated with the Big Number widget, it would be ideal.
The additional step would be to combine the usage of all of the PDUs into a single Big Number for the given date range (probably a monthly view)

Near as I can tell, there is not a way to look at the first and last value in a data range for a dashboard.. it appears to be designed to look exclusively at the most recent data values.
However, the widgets are able to display a graph showing the historic data. So that makes me thinks there may be a way to reference the previous data values.

The dashboard I put together shows a live view of the data from each PDU. 
The Gauge and Big Number widgets display the current values.
The Graph widget displays historic data - but I dont see a way to refer to the historic values for any other widget.
image.thumb.png.c8245d0a3e7f481e4adea2f7f41bdfa8.png
 

Link to post
Share on other sites
  • 0

I was tinkering with the big number widget and looks like it "could" do this. However, it is displaying Resource not found
I tried using sum, min and max from the new watthour complex datpoint and from the snmp raw value
its seems like this is right at the cusp of working..... so frustrating :)

So if a widget is not possible, is there a way to create a Resource Metric Trend Report with a custom configuration?
being able to adjust Column titles, the data scaling and data labels would make this almost usable for a client facing report. 

If a custom report solution isnt an option, is there a way to integrate to PowerBI?

Link to post
Share on other sites
  • 0
  • Administrators

What you're seeing when you see sum/min/max/average is actually the sum of the most recent data for all instances that match your glob expression.

I'm sure you can integrate into PowerBI. Reports have CSV output option. I think you can trigger the report to gen via API then fetch the URL from which you can fetch the data.

Not sure if you're overlooking the report options, but what you see in the dialog is what you get. 

Link to post
Share on other sites
  • 0
16 hours ago, Stuart Weenig said:

What you're seeing when you see sum/min/max/average is actually the sum of the most recent data for all instances that match your glob expression.

I'm sure you can integrate into PowerBI. Reports have CSV output option. I think you can trigger the report to gen via API then fetch the URL from which you can fetch the data.

Not sure if you're overlooking the report options, but what you see in the dialog is what you get. 

 

Thanks Stuart

I really dont want to use an external system for this, but it sounds like we have run this as far as we can with Logic Monitor reporting and widgets. 
I looked through the feature requests as you mentioned before and I couldnt find anything that sounded like this. So I submitted as new one and figured they could be joined if the other one pops up. 

Thank you again for all of your help

Link to post
Share on other sites
  • 0
  • Administrators

Understood. For what it's worth, the Feature Requests forum on this community isn't the comprehensive list of feature requests. It's meant to be a place where feature requests can be brought up, fleshed out, and shown support by customers. I am sure the official FR system (known internally as FEED) has this in it. That said, the FR forum here is monitored by the Product Management team and they usually take it into consideration when planning the roadmap. Your CSM can assist with that by making sure your post in the FR forum gets turned into an actual record in the FEED system. 

  • Like 1
Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.