SELECT nj.start_date,nj.policy_name,f.pathname,nj.kilobytes/1024/1024,nbr_of_files
FROM APT_V_NBU_JOB_DETAIL nj, APT_V_NBU_JOB_FILE f, APT_V_SERVER ns
WHERE nj.job_id=f.job_id
AND nj.policy_name like '%some_policy_name%'
AND nj.client_id=ns.server_id
AND nj.start_date >= sysdate -1
AND nj.summary_status is not null
order by nj.policy_name,nj.start_date
It used to work with no issues and now it returns 0 rows after the application was upgraded from 7.2.02.
