ADSM-L

Re: [ADSM-L] sql query from tsm end.......please help me out.....

2012-03-20 07:43:11
Subject: Re: [ADSM-L] sql query from tsm end.......please help me out.....
From: Grigori Solonovitch <Grigori.Solonovitch AT AHLIUNITED DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 20 Mar 2012 14:39:19 +0300
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 = <STGNAME> -
  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 AT VM.MARIST DOT EDU] On Behalf Of 
Yuvaraja Shivarama
Sent: 20 03 2012 2:16 PM
To: ADSM-L AT VM.MARIST DOT 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.

<Prev in Thread] Current Thread [Next in Thread>