X-Git-Url: https://osm.etsi.org/gitweb/?a=blobdiff_plain;f=nfvo_db.py;h=d8305a7456f581d01322d3e16ee02aa055b02556;hb=ac1e379bcb9d68731df3b988cb622f69468d904a;hp=b5ec9a0da3ff3562cd8fd5eab79bcefebcab4ff5;hpb=5bb59dc875caf2d71aad5e5e38ab3f63f4c73607;p=osm%2FRO.git

diff --git a/nfvo_db.py b/nfvo_db.py
index b5ec9a0d..d8305a74 100644
--- a/nfvo_db.py
+++ b/nfvo_db.py
@@ -912,7 +912,7 @@ class nfvo_db(db_base.db_base):
                     #from_text = "instance_nets join instance_scenarios on instance_nets.instance_scenario_id=instance_scenarios.uuid " + \
                     #            "join sce_nets on instance_scenarios.scenario_id=sce_nets.scenario_id"
                     #where_text = "instance_nets.instance_scenario_id='"+ instance_dict['uuid'] + "'"
-                    cmd = "SELECT uuid,vim_net_id,status,error_msg,vim_info,created, sce_net_id, net_id as vnf_net_id, datacenter_id, datacenter_tenant_id"\
+                    cmd = "SELECT uuid,vim_net_id,status,error_msg,vim_info,created, sce_net_id, net_id as vnf_net_id, datacenter_id, datacenter_tenant_id, sdn_net_id"\
                             " FROM instance_nets" \
                             " WHERE instance_scenario_id='{}' ORDER BY created_at".format(instance_dict['uuid'])
                     self.logger.debug(cmd)