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/selectall.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 cmso-robot/robot/assets/sql/selectall.sql

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

diff --git a/cmso-robot/robot/assets/sql/selectall.sql b/cmso-robot/robot/assets/sql/selectall.sql
new file mode 100644
index 0000000..ba41595
--- /dev/null
+++ b/cmso-robot/robot/assets/sql/selectall.sql
@@ -0,0 +1,9 @@
+select * from DOMAINS;
+select * from DOMAIN_DATA order by schedules_id desc;
+select * from CHANGE_MANAGEMENT_SCHEDULES order by id desc;
+select * from CHANGE_MANAGEMENT_CHANGE_WINDOWS;
+select * from CHANGE_MANAGEMENT_GROUPS;
+select * from SCHEDULES order by id desc;
+select * from APPROVAL_TYPES;
+select * from SCHEDULE_APPROVALS;
+select * from SCHEDULE_EVENTS;
\ No newline at end of file
-- 
cgit 1.2.3-korg

