how to get ip using SQL

[tyommik]

Hello! I've tryed to get hosts ip by sql. For example sql query

SELECT ip FROM hosts,interface WHERE hosts.hostid =10228; 

lists array but i want just ip of necessary host.

Thanks!

[neilb]

try instead : sql >

select * from interface


and join that back to the host table if required using hostid.

N.

[tyommik]

Thank you for reply!
Right answer "select ip FROM interface WHERE hostid = 10233". RTFM

[neilb]

no worries. The db schema actually uses obvious names for the tables, which is quite a relief versus some other systems!

the only weird one I've found so far is that templates are actually stored as hosts (in the hosts table).