TSM node occupancy

[melfaro]

Hi,



I need to write a script that extracts the bytes backed up per node and eventually send these information to an excel spreadsheet to track the backup growth. Does anyone know the select statement that I need to run to get this information?



Thanks and regards,



Melfaro

 

[mm-o]

<TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font class="pn-sub">Quote:</font><HR></TD></TR><TR><TD><FONT class="pn-sub"><BLOCKQUOTE>Hi,



I need to write a script that extracts the bytes backed up per node and eventually send these information to an excel spreadsheet to track the backup growth. Does anyone know the select statement that I need to run to get this information?



Thanks and regards,



Melfaro</BLOCKQUOTE></FONT></TD></TR><TR><TD><HR></TD></TR></TABLE>



select node_name, (sum(physical_mb)*1024)*1024, current_timestamp from occupancy group by node_name



Pipe the output to a file and import it to excel.

Or

Use the ODBC and import it directly into excel.