aboutsummaryrefslogtreecommitdiffstats
path: root/cmso-robot/robot/assets/sql/demo.sql
diff options
context:
space:
mode:
Diffstat (limited to 'cmso-robot/robot/assets/sql/demo.sql')
-rw-r--r--cmso-robot/robot/assets/sql/demo.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/cmso-robot/robot/assets/sql/demo.sql b/cmso-robot/robot/assets/sql/demo.sql
new file mode 100644
index 0000000..c099283
--- /dev/null
+++ b/cmso-robot/robot/assets/sql/demo.sql
@@ -0,0 +1,11 @@
+ SELECT DISTINCT
+ s.schedule_id, s.status, s.schedule_info, s.schedule, g.start_time,
+ d.vnf_name, d.status vnf_status, d.status_message, d.aots_change_id, d.aots_approval_status, d.mso_request_id, d.mso_status, d.aots_status, s.user_id, FROM_UNIXTIME(d.start_time/1000) as StartTime, FROM_UNIXTIME(s.create_date_time/1000) as CreateDateTime
+FROM
+ SCHEDULES s,
+ CHANGE_MANAGEMENT_GROUPS g,
+ CHANGE_MANAGEMENT_SCHEDULES d
+WHERE
+ g.schedules_id = s.id
+ AND d.change_management_groups_id = g.id
+ order by CreateDateTime desc; \ No newline at end of file