Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+select\s+question\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+select\s+question\s*$/: 4 ]

Total 4 documents matching your query.

1. SQL select question (score: 1): Author: William Goliak <wgoliak AT MIDWAY.UCHICAGO DOT EDU>; Date: Thu, 30 Oct 2003 15:53:03 -0600; Does anyone have a way to determine the total amount of files and data used by a specific file type across the server? In particular, mp3's but there are other questionable data types. I realize that; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2003-10/msg01036.html (10,815 bytes)
2. Re: SQL select question (score: 1): Author: James Choate <jchoate AT SOURCE1INC DOT COM>; Date: Thu, 30 Oct 2003 16:46:45 -0700; William, Have you ever looked into ITSRM. Here is a brief description of its capibilities, one of which is the ability of file level analysis. Managing Storage Resources Across the Enterprise Tivoli; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2003-10/msg01037.html (12,522 bytes)
3. Re: SQL select question (score: 1): Author: Anders Pontusson <anders.pontusson AT EXIST DOT SE>; Date: Fri, 31 Oct 2003 11:32:12 +0100; but Try this one... However I got no idea if includes just active or both active and inactive files, copypool and so on. SELECT CAST(SUM(FILE_SIZE/1024/1024) AS DECIMAL (1000,0)) AS TOT_MP3_MB FROM; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2003-10/msg01042.html (10,671 bytes)
4. sql select question (score: 1): Author: Rainer Holzinger <Rainer.Holzinger AT HAINDL DOT COM>; Date: Fri, 5 Nov 1999 08:14:56 +0100; Hi all, I have a simple "report" to monitor ADSM's storage pool utilization for primary and copy storage pools: select stgpool_name,est_capacity_mb,pct_utilized,maxscratch from stgpools). Another "re; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/1999-11/msg00291.html (11,412 bytes)

Current List: 1 - 4
Page: [1]