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: [email protected] Pavel Sitnikov <[email protected]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 25/06/2009 11:12 Please respond to "ADSM: Dist Stor Manager" <[email protected]> To [email protected] 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!
