Re: [ADSM-L] How can I insert "Completed" column in report?
2009-06-25 06:44:03
Hello
Try this for a starter:
select * from summary where schedule_name is not null and
start_time>current_timestamp - 24 hours
That will list all scheduled tasks from the summary table that started in
the last 24 hours.
You can replace the * with a comma separated list of fields you need. Try
it out and feedback if it's not what you need.
Steven
Steven Langdale
Global Information Services
EAME SAN/Storage Planning and Implementation
( Phone : +44 (0)1733 584175
( Mob: +44 (0)7876 216782
ü Conference: +44 (0)208 609 7400 Code: 331817
+ Email: steven.langdale AT cat DOT com
Pavel Sitnikov <SitnikovPG AT URALSIBBANK DOT RU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
25/06/2009 11:12
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To
ADSM-L AT VM.MARIST DOT EDU
cc
Subject
[ADSM-L] How can I insert "Completed" column in report?
Caterpillar: Confidential Green Retain Until: 25/07/2009
Hi,
sql queries guru
need some script for my custom OR rep with output like TSM command "q ev *
* f=d"
I know about standart "Client Schedules Status" report and use it. But it
have only one option setting in OR - Node Filter. And report output
doesn't have "Completed" column, only "Schedule Start" and "Actual
Start". Command output "q ev * * f=d" include this column.
How can I insert "Completed" column in report?
Thx in advance!
|
|
|