OpsCenter Custom SQL Query (Help Needed)
Hi,
I need opcenter SQL query to
Display first backup date of each client.
Please help!
Thanks.
I need opcenter SQL query to
Display first backup date of each client.
Please help!
Thanks.
Forum Discussion
3 Replies
What is the objecteive you want to achive ?
DeepS
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
Vaibhavd87Did this query help ? Or you need some diffrent output ? This query will provide the oldest job for each client in opscenter database.
DeepS
