Automatic Reports/Logs via E-Mail

[IPapp]

Correct me if I am wrong but I recall a subject on building automatic reports that would capture trend charts and email them when a condition/schedule was met. Does anyone else recall this or am I way out in the weeds with this?

Also, is there a way to schedule a report via email for a device?

I have a heat trace for my gutters and the Z-Wave module that controls it has an energy meter. It would be really nice to track that kWh information without logging logging into my 994i PRO to obtain it.⚡❄️💸

[Scott847]

Not sure if something like this would be useful but Initial State is great for data visualization: https://www.initialstate.com/

This is one tile showing voltages on an Initial State dashboard. Following are the network resource settings for voltage from an Aeotec Smart Switch 6.

Protocol Information:

https
POST
Host = groker.initialstate.com
Port = 443
Path = /api/events
Encode URL = unchecked
Use SNI = unchecked
Timeout (ms) = 5,000
Mode = Raw Text

Headers:

Content-Type = application/json
X-IS-AccessKey = [your Initial State access key]
X-IS-BucketKey = [your key for an Initial State "bucket" you create]

Body:

[
 {"key": "Sump Pump Volts", "value": ${sys.node.ZW005_143.CV.raw}},
 {"key": "Sump Pump Watts", "value": ${sys.node.ZW005_143.ST.raw}},
 {"key": "Sump Pump Amps", "value": ${sys.node.ZW005_143.CC.raw}},
 {"key": "Sump Pump kWh", "value": ${sys.node.ZW005_143.TPW.raw}}
]

[mmb]

22 hours ago, Scott847 said:

This is one tile showing voltages on an Initial State dashboard. Following are the network resource settings for voltage from an Aeotec Smart Switch 6.

[
 {"key": "Sump Pump Volts", "value": ${sys.node.ZW005_143.CV.raw}},
 {"key": "Sump Pump Watts", "value": ${sys.node.ZW005_143.ST.raw}},
 {"key": "Sump Pump Amps", "value": ${sys.node.ZW005_143.CC.raw}},
 {"key": "Sump Pump kWh", "value": ${sys.node.ZW005_143.TPW.raw}}
]

 

Interesting, I have a GE Z-Wave switch that has no system variables to select from so I can write a reporting program but I see the info I need in the logs as shown below.

@Scott847 were these Sump Pump values selectable as system variables? 

Or did you do something to determine the raw values?

Thanks!

[KeviNH]

I open the ISY interface in a web browser and browse to the node itself (e.g. /rest/nodes/ZW003_143) to see the properties exposed in the XML, like so:

Quote

 

<nodeInfo>

<node flag="0" nodeDefId="UZW0087">

<address>ZW003_143</address>

<name>Washing Machine Watts</name>

...

<property id="ST" value="681" formatted="0.681 Watts" uom="73" prec="3"/>

</node>

<properties>

<property id="CC" value="38" formatted="0.038 Amps" uom="1" prec="3"/>

<property id="CV" value="123273" formatted="123.273 Volts" uom="72" prec="3"/>

<property id="ST" value="681" formatted="0.681 Watts" uom="73" prec="3"/>

<property id="TPW" value="7" formatted="0.007 kWh" uom="33" prec="3"/>

</properties>

</nodeInfo>

 

To confirm, you could also grab one specific property, just add the property to the end of the URL (So it becomes  "/rest/nodes/ZW003_143/ST"):

<properties>
<property id="ST" value="681" formatted="0.681 Watts" uom="73" prec="3"/>
</properties>

In this case the .raw would give you the "value" field.

If your tool or report needs the formatted decimal version of the value but without the " Watts" or "°F" suffix, one option to get this is to have the ISY994 program assign that device property to a variable, then have your report send the variable value instead of sending the device property.

Looks like InitialState supports "realtime expressions" so you can have their tool convert the raw value on-the-fly.    Given the recurring cost of that service, I'd be more likely to roll my own with InfluxDB+Grafana.

Edited January 1, 2023 by KeviNH

[mmb]

37 minutes ago, KeviNH said:

I open the ISY interface in a web browser and browse to the node itself (e.g. /rest/nodes/ZW003_143) to see the properties exposed in the XML, like so:

To confirm, you could also grab one specific property, just add the property to the end of the URL (So it becomes  "/rest/nodes/ZW013_143/ST"):

Thanks so much for this, I've literally been stuck on this for months.