less than 200 years...
SELECT * FROM EVENTS WHERE SCHEDULED_START BETWEEN '1970-01-01' AND
'2199-12-31' AND CURRENT_TIMESTAMP-SCHEDULED_START<'2 00:00:00'
regards,
Anders Pontusson
x27; output to compute
> durations.
I believe that information can be found in the summary table (but then
theres no problem with the criterias).
SELECT ENTITY AS NODE_NAME,(END_TIME-START_TIME) AS DURATION FROM SUMMARY
WHERE UPPER(ACTIVITY)='BACKUP' AND CURRENT_TIMESTAMP-START_TIME<'2
00:00:00'
regards,
Anders Pontusson
inactive files, copypool and so on.
SELECT CAST(SUM(FILE_SIZE/1024/1024) AS DECIMAL (1000,0)) AS TOT_MP3_MB
FROM CONTENTS WHERE UPPER(FILE_NAME) LIKE '%.MP3'
regards,
Anders Pontusson
NNAME] ARCHIVE_ON_3RD
EXIT
---
Anders Pontusson
Exist i Stockholm AB
Propellervägen 6b
183 62 Täby
Mobile: +46 70 - 399 32 90
Email: [EMAIL PROTECTED]
---
Joni Moyer <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor
