blob: 952800c21628e314d60ade370e050a9c2b11700c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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
|
