diff options
Diffstat (limited to 'cmso-robot/robot/assets/sql/demo.sql')
| -rw-r--r-- | cmso-robot/robot/assets/sql/demo.sql | 11 |
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 |