Forum Discussion
3 Replies
- DeepsLevel 6
What is the objecteive you want to achive ?
DeepS
- DeepsLevel 6
Try this
Select tbl.clientname,adjust_timestamp(tbl.starttime,-18000000 ) as "StartTime",tbl.policyname,tbl.schedulename,tbl.statuscode
From domain_jobarchive tbl
Inner Join
(
Select clientname,MIN(id) jobID From domain_jobarchive Group By clientname
)tbl1
On tbl1.clientname=tbl.clientname
Where tbl1.jobID=tbl.idYou may add more columns to output.
DeepS
- DeepsLevel 6
Vaibhavd87Did this query help ? Or you need some diffrent output ? This query will provide the oldest job for each client in opscenter database.
DeepS
Related Content
- 7 years ago
- 10 years ago
- 11 years ago