NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.

Forum Discussion

SLK-Purdue's avatar
SLK-Purdue
Luminary
Apr 21, 2020
Solved

Orbi, SOAP, and Excel

In previous post I have tried to improved the Connected Devices display in the WebUI (added sorting) and put together an Excel spreadsheet to extract that data.  I still wanted signal information.  T...
CrimpOn's avatar
CrimpOn
Guru - Experienced User
May 24, 2020

This Excel sheet is amazing!  It now removes any incentive to open the Orbi "app" as the only thing the app does that the web interface does not is show the "Link Rate" and signal strength.

 

Was surprised to see the satellite signal strength on my satellite is (minus) 64, whereas all the other devices show signal strength as positive numbers. The spread sheet does not show transmit/receive speeds that I see in

satelliteinfo wifi

That data is probably not in the information SOAP returns?

 

GREAT WORK

 

SLK-Purdue's avatar
SLK-Purdue
Luminary
May 24, 2020

Thanks for the question.   I run a wired backhaul so I hadn't thought about wireless backhaul link information.   It does appear that the backhaul BHPhyTxRate and BHPhyTxRate is available via SOAP in the request GetCurrentSatellitesWIFIinfo and I would love to include that in the Excel code.   I can made that SOAP request but I am not getting complete information in the return.  It seems likely I have a syntax error somehow in the request but I am flying blind without a spec.  If anyone can point me in the right directly or if anyone at Netgear would share to spec (even if via a backdoor and I promise I won't ask questions :-) ), this could be easily included in the spreadsheet infomation.  Thanks again for the input.   

 

Wish I could have reported better results. 

 

Current version of the spreadsheet with the GetCurrentSatelliteWIFIinfo response in the breakout spreadsheets can be found at

 

    www dropbox com/s/fjqnfp0puahc604/ORBI%20Soap%20Request.xlsm?dl=0

 

Scott

  • tomschmidt's avatar
    tomschmidt
    Virtuoso
    May 27, 2020

    Great work Scott!

     

    I have been working on a monitoring system for the Orbi using Xymon.  So far it is parsing data from various web pages of the router and satellites to gather data.  But SOAP calls would be cleaner.

     

    Do you know if there are SOAP calls to get CPU and memory information like is seen on the debug.htm page?  I like to gather trend data on the CPU and memory usage to watch for any spikes or issues.  Perhaps there is a call simular to the one used for system uptime that is also shown on the debug.htm page.

     

    Sample data from my monitor:

     

    Tue May 26 21:31:35 MDT 2020 Status: OK
    RBR50 Router

    Hostname : RBR50
    IP Address : 192.168.1.1
    CPU Load : 17.0316%
    Memory Usage : 144MB/495MB
    Flash Usage : 2945MB/4096MB
    Network Session : 1196/65536
    System Uptime : 56 days 6 hours 8 minutes

    Firmware Version : V2.5.1.16
    Region : us
    Internet Connection Status : Up
    Open DNS Enabled : No
    Circle Enabled : No

  • tomschmidt's avatar
    tomschmidt
    Virtuoso
    May 27, 2020

    SLK-Purdue Scott, wonderful work that you have done!  Can the SOAP calls also check CPU and memory load?  I see you found System Uptime, but I would also like to find CPU and memory usage as reported by the debug.htm page using SOAP calls.  I am working on a system monitor using Xymon and would like to track the CPU and memory load.

    • SLK-Purdue's avatar
      SLK-Purdue
      Luminary
      May 27, 2020

      Good idea!   I added the information I know about and there is a link to the new version below.   Hope this helps.  There is still some other information that is clearly available but I don't have the correct syntax yet.   I AM STILL HOPING SOMEONE AT NETGEAR WILL SHARE THE ORBI SOAP SPEC WITH ME so I can add other interesting information. 

       

      NETGEAR -Hint, hint!! (I promise I will keep it private)

       

      New version

       

             www dropbox com/s/fjqnfp0puahc604/ORBI%20Soap%20Request.xlsm?dl=0

       

      Thanks for the input,

       

      Scott

      • CrimpOn's avatar
        CrimpOn
        Guru - Experienced User
        May 27, 2020

        Although I am enjoying this a lot, the reports for CPU, memory, & flash do not match my Orbi "debug page" report.  Not even close.

        Maybe there is a scaling factor missing somewhere?

        Could it be that the processor is multi-cpu and SOAP is reporting only one?

         

        I just realized that up time is reported in hours, minutes, and seconds.  No "Days".  The figure is correct. The debug page calculates "Days".