From fbe4bb98345727d190cefcfb3ec54ad9075fba9d Mon Sep 17 00:00:00 2001 From: "RamaPrasad Amaranarayana (ra5425)" 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) --- 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