How can I get a list of all IP addresses for known devices?

[podonnell 47]

I know about this page:

http://<embyip>/web/index.html#!/devices

However, you can't export the data, and highlighting any data to copy it only gets what's visible on the screen. It fails to capture all highlighted content when you scroll down.
If I wanted to get a list of all known IPs for the devices that have previously connected, how could I do this reliably?

Thank you.

[Luke 42078]

Hi, there isn’t an export. Table view might make it easier for you.

[podonnell 47]

32 minutes ago, Luke said:

Hi, there isn’t an export. Table view might make it easier for you.

Table view was what I'm in -- I believe that's the only view that shows IP addresses.
However, if you have to scroll down at all, highlighting the full list does not work. Even a ctrl+a to select everything on the page only grabs what is presently visible.

Is there a way perhaps through querying the DB?

[Jdiesel 1431]

Try the Playback Reporting Plugin. It has the ability to query the db. 

SELECT ROWID, RemoteAddress
FROM PlaybackActivity 
LIMIT 100

For example

If you want all fields change RemoteAddress to * 

SELECT ROWID, *
FROM PlaybackActivity 
LIMIT 10

Change the limit to whatever you need

Edited May 5, 2025 by Jdiesel

[Jdiesel 1431]

On second thought, Playback Reporting might have its own db meaning you won't be able to go back to before you enabled it.

[marriedman 85]

This sounded interesting to me, so I started looking around. I found this chrome extension:

https://chromewebstore.google.com/detail/easy-scraper-one-click-we/cljbfnedccphacfneigoegkiieckjndh

However, I could only get it to scrape the top 25 entries on the table view. After some tinkering, I figured out that was unable to scroll and get the next entries. However I found an easy workaround. I just zoomed out to 20% on the Device page and then clicked the extension. Boom, done.

I say it is a workaround only because I think this is something that might/should be added to the Reports plugin or baked into the server. Heck, if it written to a log file somewhere, that would be good enough (I think) for us to analyze the data.

 

[Lessaj 467]

IP addresses are in the log files, yes. You can look for things like client requests for .m4s, .ts, .vtt, or original.mkv to try to find them. Not sure if there's any others, those are the ones I've seen, I have everything in an MKV I believe so not sure if you'd see for example original.avi or something like that.

Edited May 7, 2025 by Lessaj