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>

1 files changed, 20 insertions, 0 deletions

diff --git a/cmso-robot/robot/assets/sql/searchSQL.sql b/cmso-robot/robot/assets/sql/searchSQL.sql
new file mode 100644
index 0000000..952800c
--- /dev/null
+++ b/cmso-robot/robot/assets/sql/searchSQL.sql
@@ -0,0 +1,20 @@
+select distinct 
+s.vnf_name as vnFName,
+s.vnf_id as vnfId,
+s.status as status,
+s.aots_change_id as aotsChangeId,
+s.start_time as startTime,
+s.finish_time as finishTime,
+g.group_id as groupId,
+g.last_instance_start_time as lastInstanceStartTime,
+g.policy_id as policyId,
+g.schedules_id as id,
+ss.schedule_id as scheduleId,
+dd.name
+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