1 Reply Latest reply on Aug 24, 2015 4:12 PM by SharatSagar

    Need a query which needs to give last one month sessions ran count info

    New Member


      Hi Friends,

       

      i need to fetch the below details from repository tables. Does any one have the query,Please provide me the query details

       

      how many workflows ran in my environment since one month?

      how many sessions ran in my environment since one month?

       

      Please dont post the opb tables or views info. if you have the query please post the query will be appreciate

        • 1. Re: Need a query which needs to give last one month sessions ran count info
          New Member

          select distinct t.server_name, t.server_node_name, w.subject_area, w.workflow_name,

          t.task_name, t.start_time, t.end_time,

          CAST(W.session_timestamp AS TIMESTAMP)-CAST(W.actual_start AS TIMESTAMP) time_taken,

          w.successful_source_rows --, l.throughput

          from opb_task_inst_run t, rep_sess_log w--, rep_sess_tbl_log l

          where t.task_type=68

          and t.workflow_run_id= w.workflow_run_id

          and t.instance_id= w.instance_id

          and t.start_time >= to_date('07/24/2015 16:00:00','mm/dd/yyyy hh24:mi:ss')

          --and (t.end_time - t.start_time)*24 > 2

          order by t.task_name,t.start_time