data from ChangeLog on the IP address

[zx18018]

How it is possible to obtain data from ChangeLog on the IP address?
from ChangeLog information on Users and Date is necessary

[zombah]

@zx18018 When you enter ipaddress details there is Changelog section on the right side:

[zx18018]

I need to obtain data through api or RESt

[zombah]

There is no currently REST API to changelog module, use can query MySQL DB directly or via redirecting syslog to some system with api.

[zx18018]

I know there is no such module, so I ask here. Maybe someone already did it? Can anyone know how to get this data from DB?

[zombah]

It's in table changelog. For example:

SELECT changelog.ctype,changelog.coid,ipaddresses.hostname,users.username,changelog.cdate
FROM changelog 
    LEFT JOIN users ON changelog.cuser = users.id
    LEFT JOIN ipaddresses ON changelog.coid = ipaddresses.id
LIMIT 10;

[Anyone9060]

Is there a recommended method of viewing DB data directly? Or a guide for how someone would view that data? It may be helpful for my issue here: ChangeLog viewing and row limits #4092