how to find the management class binded to the filespace for each node from the backups table.

[abcd]

Any ideas on how to get the list of class_name,node_name from the backups table?



If I join the nodes table and backups table from the SQL statement by joining node_name of both tables, the list never comes out.



thanks in anticipation

 

[goc]

please write here your select statement ... ok ?

 

[abcd]

Ofcourse there can be many ways to that the SQL query be written.......



select distinct b.class_name, b.node_name from backups b, nodes n where n.node_name=b.node_name



let me know if you need more info...





Thanks

 

[goc]

what do you mean "never comes out" ... you have to wait long ? or it comes out with no results returned ?