apt_v_date_window
The apt_v_date_window view can be used in the query combo box of custom reports to select a backup window that has been configured in Storage Viewer.
Table 3.3 apt_v_date_window
Column Name | Data Type | Description |
domain_id | NUMBER | Domain ID |
is_default | STRING | Indicates if it is a default |
window_group_id | NUMBER | Unique ID for the window |
window_group_name | STRING | Name of the date window |
EXAMPLE:
In the Report Template Designer Query Custom Combo box, enter: select window_group_id, window_group_name from apt_v_date_window order by window_group_name
Then, in the Report Template Designer Query, use the following query to report Ultimate NetBackup Job Status:
SELECT
a.nbu_job_id,
a.client_id,
b.client_host_name,
b.policy_name,
b.job_type_name,
decode(a.overall_status,0,'Success',
1,'Partial',2,'Queued',3,'Running','Failed') overall_status,
a.start_date,
a.finish_date,
a.kilobytes,
file_pathlist,
decode(was_restarted,1,'Y','N') was_restarted
FROM table (nbu_rtd.listJobSummaryAfterRestart (
${startDate},
${endDate},
${queryCombo1},
${spHosts},
null,
null,
null)) a
, apt_v_nbu_job_detail b
where a.job_id = b.job_id