How to query and retrieve device configuration using a IP address with Telnet and SSH?

[jimfram2002]

Hi, I would like to obtain technical information from hundreds of devices with specific IP address's and Subnet's remotely located. Today I must use Putty to accomplish this but I would really like to to Power BI maps to "drill down" into a specific sites that may or may not be having problems. So  in esance I would like to have the following:

1. A map of my County showing 20+ sites
2. If one (2) of the sites has an issue this site will turn red in color.
3. Once the site is identified I would be able to "click" on the site, then drill (graphically) into the site and finally the actual device that is havign issues. 

Is this possible with Power BI?

Any help would be greatly appreated!

Thanks,

Jim 

[v-shex-msft · Accepted solution]

HI @jimfram2002 ,

AFAIK, power bi not suitable for scraping data from different websites. Maybe you can try to use power query to invoke python code to scrape data from websites and transform it to query table.

Web scraping advice

POWER BI AND PYTHON: SCRAPING DE TIJDLOZE 100 WEBSITE
Regards,

Xiaoxin Sheng