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.  The information is available on the App.   The App used SOAP requests to Orbi router.   Thanks to some great internet info on SOAP servers on other Netgear products, some Wireshark network forensics, lots of coffee, long hours, some good Scotch, and a bit of magic, I got through most of the Orbi SOAP options.   I put together another Excel spreadsheet to look at this XML data.   The spreadsheet can be found at:

 

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

Dots removed to obey the posting rules.

 

Each SOAP requests creates a new worksheet with that request's XML data.   The top sheet is a compilation of data I wanted.   If I get inspired, I may port this to Javascript and create a new WebUI page but time will tell ...

No support expressed or implied but I would like to hear comments that I will consider.

 

Scott

16 Replies

  • 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. I will check if that data is available somewhere. 

      Scott

       

      CrimpOn wrote:

      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