Is it possible to make a summary of devices in HC2

[Robert66 0]

I am looking for a summary, a report, or something, from all the devices,  are connected with the Home Center.

Is that possible? To excel or something like that?

By example I want to all the information about the fibaro wall plugs I am using with HC2. 

[AndyY 11]

I use this nice script from @jwi

 

[Robert66 0]

thanks, but how do I get this on my screen:-)

[drboss 107]

Or use report function of HC2 Toolkit (

Please login or register to see this link.

). It's save txt file on PC. For download you need to create account on French forum and for enable download section post message on welcome section

. 

[jayrock 10]

The answer to your question depends on

- what devices you want to include: HW devices only or "devices" in the HC sense? Hidden devices? Virtual devices?

- what information you want to see: names only, or configuration and meta data?

- what format the report shall have: text, json, Excel, ....?

 

I suggest that you start with an API call to https://_ip_/api/devices and explore the response.

 

Cheers,

 

jayrock

[Robert66 0]

I want to see the fibaro wall plugs I am using 

[ggoetz56 9]

Hi Robert:

This is the information I reveice from "Plug5" one of my plugs.

 

{"id":306,"name":"Plug5","roomID":162,"type":"com.fibaro.FGWP102","baseType":"com.fibaro.FGWP","enabled":true,"visible":true,"isPlugin":false,"parentId":305,"remoteGatewayId":0,"viewXml":false,"configXml":false,"interfaces":["deviceGrouping","energy","fibaroFirmwareUpdate","power","zwave","zwaveAlarm","zwaveMultiChannelAssociation"],"properties":{"pollingTimeSec":0,"zwaveCompany":"Fibargroup","zwaveInfo":"3,4,5","zwaveVersion":"3.2","alarmLevel":"0","alarmType":"0","color":"white","configured":true,"dead":"false","deadReason":"","deviceControlType":"20","deviceGroup":"[]","deviceGroupMaster":"0","deviceIcon":"125","emailNotificationID":"0","emailNotificationType":"0","endPointId":"0","energy":"264.49","firmwareUpdate":"{\"info\":\"\",\"progress\":0,\"status\":\"UpToDate\",\"updateVersion\":\"3.2\"}","icon":"{\"path\":\"fibaro/icons/com.fibaro.FGWP_EU/plug1.png\",\"source\":\"HC\"}","log":"","logTemp":"","manufacturer":"","markAsDead":"true","model":"","nodeId":"24","parametersTemplate":"741","power":"24.90","productInfo":"1,15,6,2,16,1,3,2","pushNotificationID":"0","pushNotificationType":"0","remoteGatewayId":"0","saveLogs":"true","serialNumber":"h'000000000000371c","showEnergy":"true","smsNotificationID":"0","smsNotificationType":"0","updateVersion":"","useTemplate":"true","userDescription":"","value":"true"},"actions":{"abortUpdate":1,"reconfigure":0,"reset":0,"retryUpdate":1,"startUpdate":1,"turnOff":0,"turnOn":0,"updateFirmware":1},"created":1533506607,"modified":1533506607,"sortOrder":118},{"id":317,"name":"317","roomID":0,"type":"com.fibaro.zwaveDevice","baseType":"com.fibaro.device","enabled":true,"visible":false,"isPlugin":false,"parentId":1,"remoteGatewayId":0,"viewXml":false,"configXml":false,"interfaces":["battery","zwave","zwaveAssociation","zwaveConfiguration","zwaveMultiChannelAssociation","zwaveSlaveRouting","zwaveWakeup"],"properties":{"batteryLevel":"100","batteryLowNotification":"true","configured":true,"dead":"false","deadReason":"","defInterval":"21600","deviceControlType":"0","deviceIcon":"28","deviceSpecificData":"h'0000000000005e4b","deviceSpecificIdType":"Serial Number","deviceState":"Configured","emailNotificationID":"0","emailNotificationType":"0","endPointId":"0","lastWorkingRoute":"[]","lastWorkingRouteRequestStatus":"Ok","lastWorkingRouteRequestTimestamp":"0","lastWorkingRouteResponseTimestamp":"0","log":"","logTemp":"","manufacturer":"","markAsDead":"true","maxInterval":"64800","minInterval":"3600","model":"","neighborList":"[]","neighborListRequestStatus":"Ok","neighborListRequestTimestamp":"0","neighborListResponseTimestamp":"0","nodeId":"27","parameters":[{"id":1,"lastReportedValue":0,"lastSetValue":0,"size":1,"value":0},{"id":2,"lastReportedValue":0,"lastSetValue":0,"size":1,"value":0},{"id":3,"lastReportedValue":6,"lastSetValue":6,"size":1,"value":6},{"id":4,"lastReportedValue":0,"lastSetValue":0,"size":1,"value":0},{"id":10,"lastReportedValue":0,"lastSetValue":0,"size":1,"value":0},{"id":11,"lastReportedValue":2,"lastSetValue":2,"size":1,"value":2},{"id":12,"lastReportedValue":255,"lastSetValue":255,"size":2,"value":255},{"id":13,"lastReportedValue":0,"lastSetValue":0,"size":2,"value":0},{"id":14,"lastReportedValue":0,"lastSetValue":0,"size":2,"value":0},{"id":15,"lastReportedValue":0,"lastSetValue":0,"size":2,"value":0},{"id":20,"lastReportedValue":0,"lastSetValue":0,"size":1,"value":0},{"id":30,"lastReportedValue":5,"lastSetValue":5,"size":2,"value":5},{"id":31,"lastReportedValue":1,"lastSetValue":1,"size":1,"value":1},{"id":50,"lastReportedValue":300,"lastSetValue":300,"size":2,"value":300},{"id":51,"lastReportedValue":10,"lastSetValue":10,"size":2,"value":10},{"id":52,"lastReportedValue":0,"lastSetValue":0,"size":2,"value":0},{"id":53,"lastReportedValue":0,"lastSetValue":0,"size":2,"value":0},{"id":54,"lastReportedValue":0,"lastSetValue":0,"size":1,"value":0},{"id":55,"lastReportedValue":540,"lastSetValue":540,"size":2,"value":540},{"id":56,"lastReportedValue":40,"lastSetValue":40,"size":2,"value":40},{"id":70,"lastReportedValue":0,"lastSetValue":0,"size":2,"value":0},{"id":71,"lastReportedValue":0,"lastSetValue":0,"size":1,"value":0},{"id":72,"lastReportedValue":15,"lastSetValue":15,"size":1,"value":15}],"parametersTemplate":"711","pollingTimeSec":0,"productInfo":"1,15,7,1,16,1,3,2","pushNotificationID":"0","pushNotificationType":"0","remoteGatewayId":"0","saveLogs":"true","serialNumber":"h'0000000000005e4b","smsNotificationID":"0","smsNotificationType":"0","stepInterval":"1","useTemplate":"true","userDescription":"","wakeUpTime":4000,"zwaveCompany":"Fibargroup","zwaveInfo":"3,4,5","zwaveSoftwareVersion":"{}","zwaveVersion":"3.2"},"actions":{"getParameter":1,"reconfigure":0,"setInterval":1,"setParameter":2},"created":1533506607,"modified":1533506607,"sortOrder":69},

 

Maybe you expect something different . But this info you can easily copy and past to excel and with VBA-Makro you can extract the infomation you need.

Gerät Name        Nachbarn                                                                                                                                Last working Route               Timestamp

65    No Name       [305,323,331,513,425,490]                                                                                                [1,473,497]   1533819262    09.08.2018 12:54:22
114    Aquarium     [266,121,305,323,328,125,331,464,471,473,490,497,504,520,568,227,231,236]    [1,331]           1533819264    09.08.2018 12:54:24
121    HktWanne    [1,114,266,323,331,513,430,464,473,490,504]                                                             [1]                  1533819266    09.08.2018 12:54:26
125    HktBuero      [114,266,305,323,331,381,513,464,471,473,490,497]                                                [1,425,473]    1533819268    09.08.2018 12:54:28
227    SmokeKeller    [1,114,266,305,323,331,381,513,425,430,464,473,490,497,504]                           [1]                  1533819271    09.08.2018 12:54:31
231    Smoke1OG    [1,254,114,266,305,323,331,513,425,430,464,473,490,497,504]    [1]    1533819273    09.08.2018 12:54:33
236    Aqua    [114,266,305,331,464,471,473,490,504]    [1,266,114]    1533818798    09.08.2018 12:46:38
254    Mäher SW1 Q1    [264,328,372,430,568,573,582,231]    [1,490,504,573]    1533819277    09.08.2018 12:54:37
264    264.0    [1,254]    [1,331,323]    1533818802    09.08.2018 12:46:42
266    266.0    []    []    0    01.01.1970 00:00:00
305    Plug5    [65,114,266,317,320,323,325,328,125,331,464,471,473,490,497,504,520,227,231,236]    [1,473]    1533819283    09.08.2018 12:54:43
317    Gartentür    []    []    0    01.01.1970 00:00:00
320    HktEZ-S    [1,305]    [1]    1533819288    09.08.2018 12:54:48
323    Steckdose    [1,65,114,266,121,305,325,328,125,331,336,446,372,381,513,425,430,473,488,497,568,576,582,440,227,231]    [1]    1533819290    09.08.2018 
325    325.0    [1,305,323,331,372,513,425,490]    [1]    1533819292    09.08.2018 12:54:52
328    328.0    [1,254,114,266,305,323,331,372,513,425,430,464,473,497,504,576]    [1]    1533819294    09.08.2018 12:54:54

 

This table  (i don't know how to copy an excel sheet) show some of my devices, their neighbor devices, the lastworking route, and the timestamp of last refresh of LWR. If just want to know the ids of your Plugs there is a simple api- command using a filter. That would give you something like that.

 

[DEBUG] 10:04:13: Neighbours of device 65)No Name : [305,323,331,513,425,473,490,497]
[DEBUG] 10:04:13: Last working route used by device 65 : [1,323,305]
[DEBUG] 10:04:13: -----------------------------------------------------------
[DEBUG] 10:04:15: Neighbours of device 114)Aquarium : [266,121,305,328,125,331,464,471,473,490,497,504,520,568,227,231,236]
[DEBUG] 10:04:16: Last working route used by device 114 : [1,331]
[DEBUG] 10:04:16: -----------------------------------------------------------
[DEBUG] 10:04:18: Neighbours of device 121)HktWanne : [1,114,266,323,331,513,430,464,473,490,504]
[DEBUG] 10:04:18: Last working route used by device 121 : [1]
[DEBUG] 10:04:18: -----------------------------------------------------------

Edited August 13, 2018 by ggoetz56

[Robert66 0]

thanks, but how do I get this on my screen:-)

7 hours ago, ggoetz56 said:

Hi Robert:

This is the information I reveice from "Plug5" one of my plugs.

 

{"id":306,"name":"Plug5","roomID":162,"type":"com.fibaro.FGWP102","baseType":"com.fibaro.FGWP","enabled":true,"visible":true,"isPlugin":false,"parentId":305,"remoteGatewayId":0,"viewXml":false,"configXml":false,"interfaces":["deviceGrouping","energy","fibaroFirmwareUpdate","power","zwave","zwaveAlarm","zwaveMultiChannelAssociation"],"properties":{"pollingTimeSec":0,"zwaveCompany":"Fibargroup","zwaveInfo":"3,4,5","zwaveVersion":"3.2","alarmLevel":"0","alarmType":"0","color":"white","configured":true,"dead":"false","deadReason":"","deviceControlType":"20","deviceGroup":"[]","deviceGroupMaster":"0","deviceIcon":"125","emailNotificationID":"0","emailNotificationType":"0","endPointId":"0","energy":"264.49","firmwareUpdate":"{\"info\":\"\",\"progress\":0,\"status\":\"UpToDate\",\"updateVersion\":\"3.2\"}","icon":"{\"path\":\"fibaro/icons/com.fibaro.FGWP_EU/plug1.png\",\"source\":\"HC\"}","log":"","logTemp":"","manufacturer":"","markAsDead":"true","model":"","nodeId":"24","parametersTemplate":"741","power":"24.90","productInfo":"1,15,6,2,16,1,3,2","pushNotificationID":"0","pushNotificationType":"0","remoteGatewayId":"0","saveLogs":"true","serialNumber":"h'000000000000371c","showEnergy":"true","smsNotificationID":"0","smsNotificationType":"0","updateVersion":"","useTemplate":"true","userDescription":"","value":"true"},"actions":{"abortUpdate":1,"reconfigure":0,"reset":0,"retryUpdate":1,"startUpdate":1,"turnOff":0,"turnOn":0,"updateFirmware":1},"created":1533506607,"modified":1533506607,"sortOrder":118},{"id":317,"name":"317","roomID":0,"type":"com.fibaro.zwaveDevice","baseType":"com.fibaro.device","enabled":true,"visible":false,"isPlugin":false,"parentId":1,"remoteGatewayId":0,"viewXml":false,"configXml":false,"interfaces":["battery","zwave","zwaveAssociation","zwaveConfiguration","zwaveMultiChannelAssociation","zwaveSlaveRouting","zwaveWakeup"],"properties":{"batteryLevel":"100","batteryLowNotification":"true","configured":true,"dead":"false","deadReason":"","defInterval":"21600","deviceControlType":"0","deviceIcon":"28","deviceSpecificData":"h'0000000000005e4b","deviceSpecificIdType":"Serial Number","deviceState":"Configured","emailNotificationID":"0","emailNotificationType":"0","endPointId":"0","lastWorkingRoute":"[]","lastWorkingRouteRequestStatus":"Ok","lastWorkingRouteRequestTimestamp":"0","lastWorkingRouteResponseTimestamp":"0","log":"","logTemp":"","manufacturer":"","markAsDead":"true","maxInterval":"64800","minInterval":"3600","model":"","neighborList":"[]","neighborListRequestStatus":"Ok","neighborListRequestTimestamp":"0","neighborListResponseTimestamp":"0","nodeId":"27","parameters":[{"id":1,"lastReportedValue":0,"lastSetValue":0,"size":1,"value":0},{"id":2,"lastReportedValue":0,"lastSetValue":0,"size":1,"value":0},{"id":3,"lastReportedValue":6,"lastSetValue":6,"size":1,"value":6},{"id":4,"lastReportedValue":0,"lastSetValue":0,"size":1,"value":0},{"id":10,"lastReportedValue":0,"lastSetValue":0,"size":1,"value":0},{"id":11,"lastReportedValue":2,"lastSetValue":2,"size":1,"value":2},{"id":12,"lastReportedValue":255,"lastSetValue":255,"size":2,"value":255},{"id":13,"lastReportedValue":0,"lastSetValue":0,"size":2,"value":0},{"id":14,"lastReportedValue":0,"lastSetValue":0,"size":2,"value":0},{"id":15,"lastReportedValue":0,"lastSetValue":0,"size":2,"value":0},{"id":20,"lastReportedValue":0,"lastSetValue":0,"size":1,"value":0},{"id":30,"lastReportedValue":5,"lastSetValue":5,"size":2,"value":5},{"id":31,"lastReportedValue":1,"lastSetValue":1,"size":1,"value":1},{"id":50,"lastReportedValue":300,"lastSetValue":300,"size":2,"value":300},{"id":51,"lastReportedValue":10,"lastSetValue":10,"size":2,"value":10},{"id":52,"lastReportedValue":0,"lastSetValue":0,"size":2,"value":0},{"id":53,"lastReportedValue":0,"lastSetValue":0,"size":2,"value":0},{"id":54,"lastReportedValue":0,"lastSetValue":0,"size":1,"value":0},{"id":55,"lastReportedValue":540,"lastSetValue":540,"size":2,"value":540},{"id":56,"lastReportedValue":40,"lastSetValue":40,"size":2,"value":40},{"id":70,"lastReportedValue":0,"lastSetValue":0,"size":2,"value":0},{"id":71,"lastReportedValue":0,"lastSetValue":0,"size":1,"value":0},{"id":72,"lastReportedValue":15,"lastSetValue":15,"size":1,"value":15}],"parametersTemplate":"711","pollingTimeSec":0,"productInfo":"1,15,7,1,16,1,3,2","pushNotificationID":"0","pushNotificationType":"0","remoteGatewayId":"0","saveLogs":"true","serialNumber":"h'0000000000005e4b","smsNotificationID":"0","smsNotificationType":"0","stepInterval":"1","useTemplate":"true","userDescription":"","wakeUpTime":4000,"zwaveCompany":"Fibargroup","zwaveInfo":"3,4,5","zwaveSoftwareVersion":"{}","zwaveVersion":"3.2"},"actions":{"getParameter":1,"reconfigure":0,"setInterval":1,"setParameter":2},"created":1533506607,"modified":1533506607,"sortOrder":69},

 

Maybe you expect something different . But this info you can easily copy and past to excel and with VBA-Makro you can extract the infomation you need.

Gerät Name        Nachbarn                                                                                                                                Last working Route               Timestamp

65    No Name       [305,323,331,513,425,490]                                                                                                [1,473,497]   1533819262    09.08.2018 12:54:22
114    Aquarium     [266,121,305,323,328,125,331,464,471,473,490,497,504,520,568,227,231,236]    [1,331]           1533819264    09.08.2018 12:54:24
121    HktWanne    [1,114,266,323,331,513,430,464,473,490,504]                                                             [1]                  1533819266    09.08.2018 12:54:26
125    HktBuero      [114,266,305,323,331,381,513,464,471,473,490,497]                                                [1,425,473]    1533819268    09.08.2018 12:54:28
227    SmokeKeller    [1,114,266,305,323,331,381,513,425,430,464,473,490,497,504]                           [1]                  1533819271    09.08.2018 12:54:31
231    Smoke1OG    [1,254,114,266,305,323,331,513,425,430,464,473,490,497,504]    [1]    1533819273    09.08.2018 12:54:33
236    Aqua    [114,266,305,331,464,471,473,490,504]    [1,266,114]    1533818798    09.08.2018 12:46:38
254    Mäher SW1 Q1    [264,328,372,430,568,573,582,231]    [1,490,504,573]    1533819277    09.08.2018 12:54:37
264    264.0    [1,254]    [1,331,323]    1533818802    09.08.2018 12:46:42
266    266.0    []    []    0    01.01.1970 00:00:00
305    Plug5    [65,114,266,317,320,323,325,328,125,331,464,471,473,490,497,504,520,227,231,236]    [1,473]    1533819283    09.08.2018 12:54:43
317    Gartentür    []    []    0    01.01.1970 00:00:00
320    HktEZ-S    [1,305]    [1]    1533819288    09.08.2018 12:54:48
323    Steckdose    [1,65,114,266,121,305,325,328,125,331,336,446,372,381,513,425,430,473,488,497,568,576,582,440,227,231]    [1]    1533819290    09.08.2018 
325    325.0    [1,305,323,331,372,513,425,490]    [1]    1533819292    09.08.2018 12:54:52
328    328.0    [1,254,114,266,305,323,331,372,513,425,430,464,473,497,504,576]    [1]    1533819294    09.08.2018 12:54:54

 

This table  (i don't know how to copy an excel sheet) show some of my devices, their neighbor devices, the lastworking route, and the timestamp of last refresh of LWR. If just want to know the ids of your Plugs there is a simple api- command using a filter. That would give you something like that.

 

[DEBUG] 10:04:13: Neighbours of device 65)No Name : [305,323,331,513,425,473,490,497]
[DEBUG] 10:04:13: Last working route used by device 65 : [1,323,305]
[DEBUG] 10:04:13: -----------------------------------------------------------
[DEBUG] 10:04:15: Neighbours of device 114)Aquarium : [266,121,305,328,125,331,464,471,473,490,497,504,520,568,227,231,236]
[DEBUG] 10:04:16: Last working route used by device 114 : [1,331]
[DEBUG] 10:04:16: -----------------------------------------------------------
[DEBUG] 10:04:18: Neighbours of device 121)HktWanne : [1,114,266,323,331,513,430,464,473,490,504]
[DEBUG] 10:04:18: Last working route used by device 121 : [1]
[DEBUG] 10:04:18: -----------------------------------------------------------

But what do you do to got that information?

[ggoetz56 9]

Ups I was sure this was the first line-  sorry:

hc_ip_adress\api\devices

type this in your browser and you get a lot of data.  But if you want to retrieve a certain information its not the best way. There is a filter statement to get the desired information. But for this you need a scene with lua code. And this is not a big thing.

[Robert66 0]

29 minutes ago, ggoetz56 said:

Ups I was sure this was the first line-  sorry:

hc_ip_adress\api\devices

type this in your browser and you get a lot of data.  But if you want to retrieve a certain information its not the best way. There is a filter statement to get the desired information. But for this you need a scene with lua code. And this is not a big thing.

if my  ip is 192.168.1.200 what  do I have to use  ? 192.168.1.200/api/devices. ?  is not working 

[ggoetz56 9]

3 hours ago, Robert66 said:

if my  ip is 192.168.1.200 what  do I have to use  ? 192.168.1.200/api/devices. ?  is not working 

Should do. Except your browser didn't autofill the line. The full statement should look like http://192.168.1.200/api/devices

Did you get an 501 or 404 error? You also should be logged on as admin in another browser-tab, if not you will be asked for credentials (user password)

What happens if you just type in the ip of HC i.e. http://192.168.1.200- That should give the homescreen of your HC right?

[ggoetz56 9]

You may also have a look at this documentation:

Please login or register to see this link.

[Robert66 0]

7 hours ago, ggoetz56 said:

Should do. Except your browser didn't autofill the line. The full statement should look like http://192.168.1.200/api/devices

Did you get an 501 or 404 error? You also should be logged on as admin in another browser-tab, if not you will be asked for credentials (user password)

What happens if you just type in the ip of HC i.e. http://192.168.1.200- That should give the homescreen of your HC right?

Thanks it's ok now, I have a lot of data:-) 

We noticed 5 failed login attempts to your HC2-006493 that seemed suspicious. Blocked for 30 minutes:-) My own IP, great Fibaro

[ggoetz56 9]

Fine!