| Author |
|
smarty
Super User
Joined: May 21 2006
Location: United States
Online Status: Offline
Posts: 728
|
| Posted: December 16 2011 at 15:36 | IP Logged
|
|
|
If any of my Insteon devices have a communications failure, I have a trigger set up that fires the following macro. This macro sends a text mesage to my phone. Macro is:
ph_sendsmtpemail("{EMAIL SERVER}",25,"{EMAIL ADDRESS-2}","{EMAIL TXT ADDRESS-1}","[TEMP1]","[TEMP10]")
Variable [TEMP1] will say "INSTEON COMM FAIL", and variable [TEMP10] will the the insteon address of the failed device (ie 19.47.B9).
Does any know how I could find insteon "ID" and "Description" corresponding to the insteon address?
I want my text message to tell me it was "bathroom lts" "load bearing north switch" at address "19.47.B9".
Edited by smarty - December 16 2011 at 15:37
__________________
Elk - Insteon - BlueIris - DMC1 - PowerHome - XLobby - HA_Bridge w/Dots - Brultech
|
| Back to Top |
|
| |
JaredM
Newbie
Joined: November 04 2007
Online Status: Offline
Posts: 36
|
| Posted: December 18 2011 at 01:43 | IP Logged
|
|
|
I'd try querying the database directly. Since you said [TEMP10] has the Insteon address, this will get you the device's ID:
Code:
| ph_sql(0,"select id from insteondevices where Address='[TEMP10]'") |
|
|
...and this will get you its description:
Code:
| ph_sql(0,"select key_desc from insteondevices where Address='[TEMP10]'") |
|
|
|
| Back to Top |
|
| |
smarty
Super User
Joined: May 21 2006
Location: United States
Online Status: Offline
Posts: 728
|
| Posted: December 18 2011 at 17:20 | IP Logged
|
|
|
Works like a champ....many thanks!
__________________
Elk - Insteon - BlueIris - DMC1 - PowerHome - XLobby - HA_Bridge w/Dots - Brultech
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome General
Topic: How to get Insteon ID and Description
