Forum Discussion

Vaibhavd87's avatar
Vaibhavd87
Level 1
9 years ago

OpsCenter Custom SQL Query (Help Needed)

Hi,
I need opcenter SQL query to

Display first backup date of each client.

Please help!
Thanks.

3 Replies

  • What is the objecteive you want to achive ?

    DeepS

    • Deeps's avatar
      Deeps
      Level 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.id

      You may add more columns to output.

      DeepS

      • Deeps's avatar
        Deeps
        Level 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