I recently decided to change ShellyForHASS for Shelly integration. Not an easy process.
When all my device where rediscovered. I notice some inconsistencies. Some where added with their original Shelly name others with their display name and one even with FQN. To investigate, I had to check each Shelly.
Now to make my life a bit easier. I was looking for a way to get all my settings for my Shelly devices in a single file, that I can search and sort. I made this quick and dirty, Powershell script that did the trick.(All my Shelly devices are in a separate VLAN 192.168.152.0/24)
$ShellyJsonStatus = "c:\temp\shellyStatus"+(Get-Date).tostring("yyyy-MM-dd-hh-mm-ss")+".json"
$ShellyJsonShelly = "c:\temp\shellyShelly"+(Get-Date).tostring("yyyy-MM-dd-hh-mm-ss")+".json"
$ShellyJsonSettings = "c:\temp\shellySettings"+(Get-Date).tostring("yyyy-MM-dd-hh-mm-ss")+".json"
$ShellyStatus = @()
$ShellyShelly = @()
$ShellySettings = @()
$i=10
for(;$i -le 253;$i++)
{
$webData1 = @()
$webData2 = @()
$webData3 = @()
$ipBase = "192.168.152." + $i
Write-Host $ipBase
if (Test-Connection -ComputerName $ipBase -Count 1 -Quiet) {
$uriBase = "http://"+$ipBase
$webData1Uri = $uriBase + "/status"
$webData1 = Invoke-RestMethod -Uri $webData1Uri
$webData2Uri = $uriBase + "/shelly"
$webData2 = Invoke-RestMethod -Uri $webData2Uri
$webData3Uri = $uriBase + "/settings"
$webData3 = Invoke-RestMethod -Uri $webData3Uri
Write-Host $uriBase
$ShellyStatus = @($ShellyStatus; $webData1)
$ShellyShelly = @($ShellyShelly; $webData2)
$ShellySettings = @($ShellySettings; $webData3)
}
}
$ShellyStatus | ConvertTo-Json | Out-File $ShellyJsonStatus
$ShellyShelly | ConvertTo-Json | Out-File $ShellyJsonShelly
$ShellySettings | ConvertTo-Json | Out-File $ShellyJsonSettings
#drop in https://data.page/json/csv to get good CSV
Putting that all in excel gave me some interesting insights and saved a ton of time.
Comments powered by CComment