Hello to everyone
Run every day a script to collect the amount and time for clients backup as:
SELECT ENTITY AS NODE, -
CAST(SUM(BYTES/1024/1024) -
AS DECIMAL(8,2)) AS "MB", -
substr(cast(min(start_time) as char(26)),1,19) as "DATETIME
", -
cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as
char(8)) as "Length " -
FROM SUMMARY -
WHERE ACTIVITY IN ('BACKUP','ARCHIVE') -
and current date - 1 days = date(Start_time) and
time(start_time)>'18:00:00' -
GROUP BY ENTITY -
ORDER BY MB
SELECT ENTITY AS NODE, -
CAST(SUM(BYTES/1024/1024) -
AS DECIMAL(8,2)) AS "MB", -
substr(cast(min(start_time) as char(26)),1,19) as "DATETIME
", -
cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as
char(8)) as "Length " -
FROM SUMMARY -
WHERE ACTIVITY IN ('BACKUP','ARCHIVE') -
and current date = date(Start_time) and time(end_time)<'08:00:00' -
GROUP BY ENTITY -
ORDER BY MB
The OUTPUT look like:
NODE MB DATETIME
Length
------------------ ---------- ----------------------------------
---------
HIGHLEARN2K 2766.09 2004-01-13 22:30:06
00:10:30
EXCHANGE1 57807.11 2004-01-13 22:07:16
01:38:54
NODE MB DATETIME
Length
------------------ ---------- ----------------------------------
---------
WEB2000_DB 0.13 2004-01-14 03:30:07
00:00:23
EXCHANGE2 23187.05 2004-01-14 01:08:48
00:38:03
This script give almost all my clients but a few are missing but when
running a query actlog the client missing as an output:
01/13/2004 23:04:02 ANE4952I (Session: 23, Node: IBROWSE2) Total number of
objects inspected: 17,827
01/13/2004 23:04:02 ANE4954I (Session: 23, Node: IBROWSE2) Total number of
objects backed up: 67
01/13/2004 23:04:02 ANE4958I (Session: 23, Node: IBROWSE2) Total number of
objects updated: 0
01/13/2004 23:04:02 ANE4960I (Session: 23, Node: IBROWSE2) Total number of
objects rebound: 0
01/13/2004 23:04:02 ANE4957I (Session: 23, Node: IBROWSE2) Total number of
objects deleted: 0
01/13/2004 23:04:02 ANE4970I (Session: 23, Node: IBROWSE2) Total number of
objects expired: 1
01/13/2004 23:04:02 ANE4959I (Session: 23, Node: IBROWSE2) Total number of
objects failed: 0
01/13/2004 23:04:02 ANE4961I (Session: 23, Node: IBROWSE2) Total number of
bytes transferred: 1.07 GB
The node IBROWSE2 is not shown in my summary query ???????
Why is a difference between summary table to actlog table ????????????
Can I run something else to give me a correct result !!!!!!!
