tivoli tsm sorguları

QUERY ACTLOG BEGINDATE=12/25/2009 BEGINTIME=NOW-1:00 ENDDATE=12/26/2009 ENDTIME=NOW ORIGINATOR=ALL


QUERY SESSION


QUERY EVENT * * BEGINDATE=12/25/2009 BEGINTIME=00:00 ENDDATE=12/26/2009 ENDTIME="08:02:14 "



select
volume_name as dbbackup from volhistory where type='BACK-
UPFULL' and devclass='LTO'



select
stgpool_name,count(*) as "toplam adet" from volumes where
devclass_name='LTO' group by stgpool_name order by 1


select count(*) as Scratch_adedi from libvolumes where status='Scratch'


select
count(*) as Lib_Kartus_sayisi from libvolumes


select
node_name,contact from nodes where node_name in (select
node_name from nodes where node_name in (select node_name
from events where (scheduled_start between '2009-12-22
08:00:00' and '2009-12-23 07:59:59') and LENGTH(domain_n-
ame) IS NOT NULL and (status='Missed')))


select
node_name,contact from nodes where node_name in (select
node_name from nodes where node_name in (select node_name
from events where (scheduled_start between '2009-12-22
08:00:00' and '2009-12-23 07:59:59') and LENGTH(domain_n-
ame) IS NOT NULL and (status='Failed')))


select
nodename,substr(char(date_time), 1, 16) as "TME",message
from actlog where (msgno=4005 or msgno=4007 or msgno=4018
or msgno=4037 or msgno=4987) and (date_time between
'2009-12-22 08:00:00' and '2009-12-23 07:59:59') order by
nodename

select
substr(char(date_time), 1, 16) as date_time,message from
actlog where (date_time between '2009-12-22 08:00:00' and
'2009-12-23 07:59:59') and severity<>'I'


select
entity,activity,bytes as BYTES from summary where
(activity='BACKUP' or activity='RESTORE' or activity='AR-
CHIVE' or activity='RETRIEVE') and (end_time between
'2009-12-22 08:00:00' and '2009-12-23 07:59:59') order by
bytes desc


select node_name,platform_name,client_os_level,client_version,c-
lient_release,client_level,client_sublevel from nodes
where node_name in (select entity from summary where
(activity='BACKUP' or activity='RESTORE' or activity='AR-
CHIVE' or activity='RETRIEVE') and (end_time between
'2009-12-22 08:00:00' and '2009-12-23 07:59:59'))