Re: sql query from tsm end.......please help me out.....
Try next query: select b.domain_name, a.node_name as Node_Name, count(*) as File_Spaces, sum(a.physical_mb) as Physical_MB, sum(a.logical_mb) as Logical_MB, sum(a.num_files) as Files - from occupancy a, nodes b - where a.stgpool_name = - and a.node_name = b.node_name - group by b.domain_name, a.node_name Do not forget to specify correct storage pool name! Grigori G. Solonovitch Senior Technical Architect Ahli United Bank Kuwait www.ahliunited.com.kw Please consider the environment before printing this E-mail -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Yuvaraja Shivarama Sent: 20 03 2012 2:16 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] sql query from tsm end...please help me out. Hi all, can any one knows how to extract the occupancy report along with domain name and node together regards Yuvaraj Please consider the environment before printing this Email. CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail message and any attachments hereto may be legally privileged and confidential. The information is intended only for the recipient(s) named in this message. If you are not the intended recipient you are notified that any use, disclosure, copying or distribution is prohibited. If you have received this in error please contact the sender and delete this message and any attachments from your computer system. We do not guarantee that this message or any attachment to it is secure or free from errors, computer viruses or other conditions that may damage or interfere with data, hardware or software.
Re: sql query from tsm end.......please help me out.....
Not exactly sure what you are looking for, but here is a report I run daily on all our tsm servers. It gives a single line occupancy per node along with the domain. It might be a starting place for you to work with. select - occupancy.node_name, - nodes.domain_name, - sum(occupancy.num_files), - sum(occupancy.physical_mb), - sum(occupancy.logical_mb) - from occupancy, nodes - where occupancy.node_name = nodes.node_name - group by occupancy.node_name, nodes.domain_name From: Yuvaraja Shivarama To: ADSM-L@VM.MARIST.EDU Date: 03/20/2012 07:17 AM Subject:sql query from tsm end...please help me out. Sent by:"ADSM: Dist Stor Manager" Hi all, can any one knows how to extract the occupancy report along with domain name and node together regards Yuvaraj - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
sql query from tsm end.......please help me out.....
Hi all, can any one knows how to extract the occupancy report along with domain name and node together regards Yuvaraj