Urgent help with sql

Question

Please, tell me how create a report showing all data from a specified server (using sql queries)

I'm issuing these:

select * from nodes where (nodename='my_linux');

but I'm getting strange output.

I need all fields from a record (node details, volumes, interfaces, poller , etc).

Thanks

FormerMember · Accepted Answer

your select is only going to get data from the nodes table.  You will need a much broader statement to grab all the info you are looking for with unions on the node id to span all the tables.  As it is all you will get is data from the nodes table.