Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-4785

Export Counter Values for a specific date

Details

    • Help
    • Resolution: Done
    • Minor
    • None
    • Professional Edition
    • Default

    Description

      Hi,
      I am currently looking for a way to bulk display/export a lot of counter values for a specific date.

      The idea behind this would be to obtain the energy values for the monthly or annual bill. The values are all available in Observium and I would like to avoid using other software for this.

      I imagine this as in the view: /health/metric=counter/
      Except that I can still select the time period for the value displayed in the list.

      Is this possible?

      Thanks!

      Attachments

        Activity

          [OBS-4785] Export Counter Values for a specific date
          adama Adam Armstrong made changes -
          Resolution New: Done [ 10000 ]
          Status Original: Pending Response [ 10000 ] New: Resolved [ 5 ]
          adama Adam Armstrong added a comment -

          Hi,

          The only place this data exists is in the RRDs. It's quite fiddly to get data out of the RRDs in a generic fashion, but you can generate a graph of the period you want and then ask for the JSON representation of the graph, and use the data provided.

          If you click on a graph, you can select JSON format in the export menu. This basically just puts &format=jsontime on the image URL and outputs a JSON block instead.

          For power you can probably extrapolate a single usage value from the average W * time. 

          If you're using a Wh sensor, you can probably ask for a graph of a time period and diff the min + max from the legend? These are contained in text near the top of the JSON output.

          Note that data in RRD is averaged over time, so it's not accurate enough to do 95th or similar billing from.

          Adam.

          adama Adam Armstrong added a comment - Hi, The only place this data exists is in the RRDs. It's quite fiddly to get data out of the RRDs in a generic fashion, but you can generate a graph of the period you want and then ask for the JSON representation of the graph, and use the data provided. If you click on a graph, you can select JSON format in the export menu. This basically just puts &format=jsontime on the image URL and outputs a JSON block instead. For power you can probably extrapolate a single usage value from the average W * time.  If you're using a Wh sensor, you can probably ask for a graph of a time period and diff the min + max from the legend? These are contained in text near the top of the JSON output. Note that data in RRD is averaged over time, so it's not accurate enough to do 95th or similar billing from. Adam.
          adama Adam Armstrong made changes -
          Comment [ _*General questions and device support can be discussed in [our Discord channel, click here to join|https://discord.gg/GjpNXKWm8W].*_
          ----

          Please make and attach additional information about the device:
           * full snmp dump from device:
          {noformat}
          snmpwalk -v2c -c <community> -t 3 -Cc --hexOutputLength=0 -Ih -ObentxU <hostname> .1 > myagent.snmpwalk
          snmpwalk -v2c -c <community> -t 3 -Cc --hexOutputLength=0 -Ih -ObentxU <hostname> .1.3.6.1.4.1 >> myagent.snmpwalk
          {noformat}
            _If device not support SNMP version 2c, replace -v2c with -v1._

           * If you have problems with discovery or poller processes, please do and attach these debugs:
          {noformat}
          ./discovery.php -d -h <device>
          ./poller.php -d -h <device>
          {noformat}
           
          * additionally attach device and/or vendor specific MIB files

          ----
          {color:#505F79}_This comment is added automatically._{color} ]
          bot Observium Bot made changes -
          Component/s New: Default [ 10900 ]
          bot Observium Bot made changes -
          Assignee Original: Adam Armstrong [ adama ] New: Mike Stupalov [ landy ]
          bot Observium Bot made changes -
          Status Original: Open [ 1 ] New: Pending Response [ 10000 ]
          swfeldkirch Siegfried Gumilar created issue -

          People

            landy Mike Stupalov
            swfeldkirch Siegfried Gumilar
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: