From fbe4bb98345727d190cefcfb3ec54ad9075fba9d Mon Sep 17 00:00:00 2001
From: "RamaPrasad Amaranarayana (ra5425)" <ra5425@att.com>
Date: Wed, 19 Sep 2018 17:40:40 -0400
Subject: Change Management Schedule Optimization

Adding Robot Test Scripts for Change Management Schedule Optimization

Change-Id: Id5edf9d3fb3c2390791362692c8b25f7607045c6
Issue-ID: OPTFRA-352
Signed-off-by: RamaPrasad Amaranarayana (ra5425) <ra5425@att.com>
---
 cmso-robot/robot/assets/sql/selectDetails.sql | 4 ++++
 1 file changed, 4 insertions(+)
 create mode 100644 cmso-robot/robot/assets/sql/selectDetails.sql

(limited to 'cmso-robot/robot/assets/sql/selectDetails.sql')

diff --git a/cmso-robot/robot/assets/sql/selectDetails.sql b/cmso-robot/robot/assets/sql/selectDetails.sql
new file mode 100644
index 0000000..74fa390
--- /dev/null
+++ b/cmso-robot/robot/assets/sql/selectDetails.sql
@@ -0,0 +1,4 @@
+SET @@global.time_zone='+00:00';
+select distinct ss.create_date_time, s.id as id, s.vnf_name as vnf_name, s.vnf_id as vnf_id, s.status as status, s.aots_change_id as aots_change_Id, s.start_time as start_time, s.finish_time as finish_time, g.group_id as group_id, g.last_instance_start_time as last_instance_start_time, g.policy_id as policy_id, g.schedules_id as schedules_id from change_management_schedules s inner join change_management_groups g on s.change_management_groups_id = g.id inner join schedules ss on g.schedules_id = ss.id  left outer join domain_data dd on ss.id = dd.schedules_id left outer join schedule_approvals sa on ss.id = sa.schedules_id inner join approval_types at on sa.approval_type_id = at.id left outer join change_management_related_assets cmra on cmra.change_management_schedule_id = s.id  
+-- where ((ss.create_date_time >= TIMESTAMP('2017-07-14T21:30:02.000-0000') AND ss.create_date_time <= TIMESTAMP('2017-07-14T21:30:03.000-0000')  ))
+order by id 
\ No newline at end of file
-- 
cgit 1.2.3-korg

