31 lines
1.5 KiB
SQL
31 lines
1.5 KiB
SQL
@@header
|
|
|
|
COLUMN blackout_name HEADING "BlackoutName" FORMAT a35
|
|
COLUMN status HEADING "Status" FORMAT a10
|
|
COLUMN last_start_time HEADING "LastStartTime" FORMAT a15
|
|
COLUMN last_end_time HEADING "LastEndTime" FORMAT a15
|
|
COLUMN schedule_type HEADING "Schedule|Type" FORMAT a10
|
|
COLUMN scheduled_time HEADING "ScheduledTime" FORMAT a15
|
|
COLUMN schedule_start_time HEADING "ScheduleStartTime" FORMAT a15
|
|
COLUMN schedule_end_time HEADING "ScheduleEndTime" FORMAT a15
|
|
COLUMN Duration HEADING "Dur|(min)" FORMAT 9999
|
|
COLUMN created_by HEADING "CreatedBy" FORMAT a15
|
|
COLUMN reason HEADING "Reason" FORMAT a20
|
|
COLUMN description HEADING "Description" FORMAT a30
|
|
|
|
SELECT b.blackout_name
|
|
, b.status
|
|
, TO_CHAR(b.last_start_time,'DD-MON-YY HH24:MI') last_start_time
|
|
, TO_CHAR(b.last_end_time,'DD-MON-YY HH24:MI') last_end_time
|
|
, b.schedule_type
|
|
, TO_CHAR(b.scheduled_time,'DD-MON-YY HH24:MI') scheduled_time
|
|
, TO_CHAR(b.schedule_start_time,'DD-MON-YY HH24:MI') schedule_start_time
|
|
, TO_CHAR(b.schedule_end_time,'DD-MON-YY HH24:MI') schedule_end_time
|
|
, b.duration
|
|
, b.created_by
|
|
, b.reason
|
|
, b.description
|
|
FROM mgmt$blackouts b;
|
|
|
|
@@footer
|