ADSM-L

[ADSM-L] tsm sql question

2009-05-04 12:43:38
Subject: [ADSM-L] tsm sql question
From: eric wonderley <eric.wonderley AT VT DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 4 May 2009 12:42:44 -0400
i run:
SELECT activity, count(entity) as "SESSIONS",
cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as "GB" FROM summary
where end_time>current_timestamp-48 hours GROUP BY activity

why is it that tape mount and expiration sessions are 0?

--
eric.wonderley AT vt DOT edu
Systems Engineering and Admin
Virginia Tech
1700 Pratt Drive
Blacksburg, VA  24061
Ph: 540-231-4385 Fx: 540-231-7413

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