Yeap, ....or BACKUP_END is null.... makes life more comfortable...
select node_name, sum((capacity * pct_util)/100/1024) "Total GB" from filespaces where - cont> (backup_end>'2005-08-28 00:00:00.000000' or BACKUP_END is null) group by node_name //Henrik -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of goc Sent: den 6 oktober 2005 10:12 To: [email protected] Subject: Re: select from filespaces hi, on the first tought i presume it has something to do with "where backup_end>'2005-08-28 00:00:00.000000' " part .. since in query without this condition the kb filespace is showing themself huh? goran ----- Original Message ----- From: "Henrik Wahlstedt" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, October 06, 2005 10:01 AM Subject: select from filespaces Hi, I got this odd reslut when I do a select from filespaces on a Win2k TSM server, 5.2.2.5. select node_name, sum((capacity * pct_util)/100/(1024) as "Total GB" from filespaces where backup_end>'2005-08-28 00:00:00.000000' group by node_name NODE_NAME Total GB ------------------ --------------------------------- KBH-DB01 7.42 select node_name,filespace_name, (capacity * pct_util)/100/1024 as "Total GB" from filespaces where backup_end>'2005-08-28 00:00:00.000000' NODE_NAME FILESPACE_NAME Total GB ------------------ ------------------ --------------------------------- KBH-DB01 / 2.24 KBH-DB01 /boot 0.02 KBH-DB01 /dbarch 0.26 KBH-DB01 /dump 1.84 KBH-DB01 /prog 3.06 select node_name, filespace_name, capacity, pct_util from filespaces NODE_NAME FILESPACE_NAME CAPACITY PCT_UTIL ------------------ ------------------ -------------------- -------------------- KBH-DB01 / 62124.3 3.7 KBH-DB01 /boot 192.9 12.9 KBH-DB01 /db 68353.1 74.7 KBH-DB01 /dbarch 16734.1 1.6 KBH-DB01 /dump 8533.9 22.1 KBH-DB01 /prog 34527.1 9.1 And usning a calulator...... 2299 - 51059 268 1886 3142 =58564 Why doesnt TSM also use KBH-DB01/db in its calculation. Any thoughts? //Henrik ------------------------------------------------------------------- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you. ------------------------------------------------------------------- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
