Forum Discussion
Robert_Geller
2 years agoLevel 4
DPeaco can you create a simple RTD with SQL Template designer and include Host Group and client scope and data range and use this query? This will tell you if the 7 hosts have jobs.
SELECT s.hostname, j.client_name, COUNT(job_id) job_count, MAX(finish_date)
FROM apt_v_job j, apt_v_server s
WHERE s.server_id IN (${hosts})
AND (j.finish_date > ${startDate} OR creation_date > ${startDate})
AND s.server_id=j.client_id (+)
GROUP BY s.hostname, j.client_name
ORDER BY 1
Related Content
- 5 months ago
- 3 months ago
- 3 months ago
- 26 days ago