cancel
Showing results for 
Search instead for 
Did you mean: 

OpsCenter Custom SQL Query (Help Needed)

Vaibhavd87
Level 1
Hi,
I need opcenter SQL query to

Display first backup date of each client.

Please help!
Thanks.
3 REPLIES 3

Deeps
Level 6

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.id

You 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