I created this little spreadsheet that converts the Z-Wave Radio Devices table
into a more readable report:
You need to have at least firmware 126.96.36.199 installed as the routing information isn't listed in the Z-Wave Radio Devices page in prior firmwares.
If you are using "Hub Login Security", you need to turn it temporarily off to create the report. Otherwise the spreadsheet can't read the information needed.
I tried to use Excel's "Basic Authentication", but it appears that Hubitat is using a different method of securing the hub. If anybody has some insight to this, feel free to contact me and I will try to implement it.
The current version of my spreadsheet is limited to 3 hops as that is what I have on my network, but you can expand it to more if needed. See below for instructions.
After you download the spreadsheet you will need to update the IP address of where to pull the report from. Here is how:
Select "Data" | "Show Queries".
If you don't see this tab on your Ribbon, then you need to install Power Query from Microsoft.
Double click "IP"
Update the IP address with the one of your hub
You can find it by looking at the IP address when you access your hub using your browser
Select "Close & Load" to generate your report
You can sort the resulting report by select "Data" | "Sort". Just make sure your cursor is located within the data to be sorted.
The report will automatically refresh when you first open the spreadsheet, but you can also refresh it manually, by selecting "Data" | "Refresh All"
If you have more than 3 hops than you'll need additional columns in the spreadsheet. Here is how:
Copy I2 to J2 (using copy/paste)
In J2, change "ID3" in the formula
to match the name of the column that has been created for the additional hop (column F).
My apologies for the lacking screenshots for the last steps. Also not quite sure what happens if you have less than 3 hops. Feel free to send me your "Z-Wave Details.html" file (select "Save As ..." using your browser) and I'll try to figure out how to deal with this variable. If someone has more experience dealing with these dynamic data sources in Excel and knows a solution, I'll be more than happy to implement them.