MariaDB [catalogdb]> select * from service ; +--------------------------------------+------------------------------+--------------------------------------+---------------+-------------------------------------------------------------------------------------+---------------------+--------------------------------------+--------------+--------------+-------------------------+------------------+------------------+----------------------------------------------------------------------------------------+-----------------------------+-----------------------+---------------+ | MODEL_UUID | MODEL_NAME | MODEL_INVARIANT_UUID | MODEL_VERSION | DESCRIPTION | CREATION_TIMESTAMP | TOSCA_CSAR_ARTIFACT_UUID | SERVICE_TYPE | SERVICE_ROLE | ENVIRONMENT_CONTEXT | WORKLOAD_CONTEXT | SERVICE_CATEGORY | RESOURCE_ORDER | OVERALL_DISTRIBUTION_STATUS | ONAP_GENERATED_NAMING | NAMING_POLICY | +--------------------------------------+------------------------------+--------------------------------------+---------------+-------------------------------------------------------------------------------------+---------------------+--------------------------------------+--------------+--------------+-------------------------+------------------+------------------+----------------------------------------------------------------------------------------+-----------------------------+-----------------------+---------------+ | 0872e134-79ee-41c4-9b5e-2da694ab4f5e | demoVFWCL | 75197f4e-9f61-4eca-a9c4-d17083b8d37a | 1.0 | catalog service description | 2019-09-30 10:45:08 | 5785add3-7c25-4d48-9af1-4a35b075a853 | | | General_Revenue-Bearing | Production | Network L1-3 | vFWCL_vFWSNK 5601d5b7-06d8,vFWCL_vPKG 9241637a-000a | NULL | 1 | | | 0b3d7786-cb04-4eef-ad86-f365687d3ec5 | vFW 2019-09-30 18:36:21 | 23b65182-ebdf-446c-883b-f744da5b56d7 | 1.0 | catalog service description | 2019-09-30 18:39:55 | 74eb26f6-daa8-4e9a-983c-2a93878199bd | | | General_Revenue-Bearing | Production | Network L1-3 | vFW fb9a938b-7c68 | NULL | 1 | | | 217b59f6-71a2-4635-8904-96b7318c7836 | demoVFWCL | 966d60a5-402c-4423-be5d-da81fbee3804 | 1.0 | catalog service description | 2019-09-30 21:44:56 | 52f34d56-21fe-4b07-a4f6-9483652ae72c | | | General_Revenue-Bearing | Production | Network L1-3 | vFWCL_vPKG 2a674ffe-1752,vFWCL_vFWSNK c203f7fa-4513 | NULL | 1 | | | 2a5cb375-431a-4be3-9219-01b2a9f72f0a | demoVCPEvGW | 5c69659f-4b36-478c-8f4e-f3d2cb1d884a | 1.0 | catalog service description | 2019-09-30 11:46:52 | 5a708005-d0af-4bc1-852b-7ea27360ef90 | | | General_Revenue-Bearing | Production | Network L1-3 | vCPE_vgw 78c0a23e-843d | NULL | 1 | | | 2d76d939-6750-426b-aad5-e803b2f032c7 | demoVCPEvBRGEMU | d2e52dad-1806-4ed8-a788-ef7c1a980486 | 1.0 | catalog service description | 2019-09-30 22:09:48 | 1a839637-8b4c-4f1e-afa4-66d20006052c | | | General_Revenue-Bearing | Production | Network L1-3 | vCPE_vbrgemu d78fc15a-8f06 | NULL | 1 | | | 3c6c56a0-726c-4721-9208-06c4e59c4e0c | demoVCPEvBNG | 005124d2-dcc0-464a-936e-ff6a422bce08 | 1.0 | catalog service description | 2019-09-30 22:03:48 | 3531e271-6a05-484a-878d-e6a58e5235c9 | | | General_Revenue-Bearing | Production | Network L1-3 | Generic NeutronNet,vCPE_vbng 9402e130-db8a | NULL | 1 | | | 461f4557-478f-4c03-b42f-bee729941bda | Demo_pNF | a0eef3b3-99b1-47b5-8766-b95b2072d9f2 | 1.0 | catalog service description | 2019-09-30 11:58:42 | abcc594a-da80-474d-88f2-d3d2f7195bdd | | | General_Revenue-Bearing | Production | Network L1-3 | pNF 64566db4-8ab1 | NULL | 1 | | | 48cc36cc-a9fe-11e7-8b4b-0242ac120002 | VNF-API-DEFAULT | 48cd56c8-a9fe-11e7-8b4b-0242ac120002 | 1.0 | Vnf api service for VID to use for infra APIH orchestration | 2017-10-05 18:52:03 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 48cc3acd-a9fe-11e7-8b4b-0242ac120002 | * | 48ce2256-a9fe-11e7-8b4b-0242ac120002 | 1.0 | Default service to use for infra APIH orchestration1707MIGRATED1707MIGRATED | 2017-10-05 18:52:03 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 4dad5b13-75b1-49c6-8b29-0de9f43ad508 | demoVCPEInfra | 420093b3-7b39-4209-8216-326615a7a8b0 | 1.0 | catalog service description | 2019-09-30 21:57:49 | 44a3401d-8db6-428a-ba30-fef8b5d1c61d | | | General_Revenue-Bearing | Production | Network L1-3 | Generic NeutronNet,vCPE_infra 1b361713-a00b | NULL | 1 | | | 6845e325-8ce4-4f17-85d5-d5cffc8ec097 | demoVCPEvGMUX | a27a5999-67e8-4cd8-bbab-52ffaae4d975 | 1.0 | catalog service description | 2019-09-30 22:13:42 | 1468a3da-d986-4eee-99cd-80272f8f287a | | | General_Revenue-Bearing | Production | Network L1-3 | vCPE_vgmux d36b2d44-2d7a,Generic NeutronNet | NULL | 1 | | | 772d379e-7f73-4b94-8726-84ce1d1b5454 | demoVCPEvGW | ad206345-31a2-42c5-ac05-6b0d77a03ea5 | 1.0 | catalog service description | 2019-09-30 22:17:47 | c2c8f8ee-40b5-4763-8687-a29b947ac961 | | | General_Revenue-Bearing | Production | Network L1-3 | vCPE_vgw 6fee2ffe-cdfc | NULL | 1 | | | d3aac917-543d-4421-b6d7-ba2b65884eb7 | vCPEResCust 2019-10-01 _2364 | d0568a10-a0e0-4efa-b698-ad3772f2e30f | 1.0 | catalog service description | 2019-10-01 03:25:42 | 2da4976c-1532-4b1e-b662-d80f487d1661 | | | General_Revenue-Bearing | Production | Network L1-3 | vCPE_vgw bf175ab0-4fa2,BRG_2019-10-01 03:23:27.409,TunnelXConn_2019-10-01 03:23:27.409 | NULL | 1 | | | d88da85c-d9e8-4f73-b837-3a72a431622b | GR-API-DEFAULT | 944862ae-bb65-4429-8330-a6c9170d6672 | 1.0 | Gr api service for VID to use for infra APIH orchestration | 2019-09-30 05:56:08 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | dfcd7471-16c7-444e-8268-d4c50d90593a | UUI_DEFAULT | dfcd7471-16c7-444e-8268-d4c50d90593a | 1.0 | Default service for UUI to use for infra APIH orchestration1707MIGRATED1707MIGRATED | 2017-10-23 18:52:03 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | e62c194f-0c0b-4b91-993a-e0ede7537547 | vFWCL 2019-09-30 12:20: | c513b4a4-7c6f-4d80-8c25-5bc4a403a0e4 | 1.0 | catalog service description | 2019-09-30 12:28:01 | 2353f612-bc5b-4f14-a1c8-83ed93e114a1 | | | General_Revenue-Bearing | Production | Network L1-3 | vFWCL_vPKG e1e2ed06-12d2,vFWCL_vFWSNK 63e49c48-7d25 | NULL | 1 | | | f5275ec7-bcbe-46f4-8762-9ee400500589 | vVG 2019-09-30 12:10:13 | 4e9abd0d-89e2-4ff2-ba4b-b0360bdf7253 | 1.0 | catalog service description | 2019-09-30 12:13:54 | 37a13fd2-ba20-453d-aec8-a08bbaebff90 | | | General_Revenue-Bearing | Production | Network L1-3 | vVG 98e71f08-3a33 | NULL | 1 | | +--------------------------------------+------------------------------+--------------------------------------+---------------+-------------------------------------------------------------------------------------+---------------------+--------------------------------------+--------------+--------------+-------------------------+------------------+------------------+----------------------------------------------------------------------------------------+-----------------------------+-----------------------+---------------+ 17 rows in set (0.00 sec) MariaDB [catalogdb]> select * from allotted_resource_customization; +--------------------------------------+---------------------------------------+--------------------------------------+----------------------------------------+---------------------------------------+---------------------+-------------+-------------+-------------+----------------+---------------+---------------+--------------------------------------+---------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | MODEL_CUSTOMIZATION_UUID | MODEL_INSTANCE_NAME | PROVIDING_SERVICE_MODEL_UUID | PROVIDING_SERVICE_MODEL_INVARIANT_UUID | PROVIDING_SERVICE_MODEL_NAME | TARGET_NETWORK_ROLE | NF_TYPE | NF_ROLE | NF_FUNCTION | NF_NAMING_CODE | MIN_INSTANCES | MAX_INSTANCES | AR_MODEL_UUID | CREATION_TIMESTAMP | RESOURCE_INPUT | +--------------------------------------+---------------------------------------+--------------------------------------+----------------------------------------+---------------------------------------+---------------------+-------------+-------------+-------------+----------------+---------------+---------------+--------------------------------------+---------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 4e0249f0-5118-4323-b5e9-0783ad1123ba | TunnelXConn_2019-10-01 03:23:27.409 0 | 6845e325-8ce4-4f17-85d5-d5cffc8ec097 | a27a5999-67e8-4cd8-bbab-52ffaae4d975 | org.openecomp.service.Demovcpevgmux | NULL | TunnelXConn | TunnelXConn | NULL | NULL | NULL | NULL | 93d3e01d-4f8c-4a60-99f2-26b64c69bc11 | 2019-10-01 03:25:42 | {\"nf_naming\":\"true\",\"skip_post_instantiation_configuration\":\"true\",\"multi_stage_design\":\"false\",\"availability_zone_max_count\":\"1\",\"nf_role\":\"TunnelXConn\",\"nf_type\":\"TunnelXConn\"} | | aff592e4-cfc7-43ce-abea-f026b56995ab | BRG_2019-10-01 03:23:27.409 0 | 2d76d939-6750-426b-aad5-e803b2f032c7 | d2e52dad-1806-4ed8-a788-ef7c1a980486 | org.openecomp.service.Demovcpevbrgemu | NULL | BRG | BRG | NULL | NULL | NULL | NULL | 12519dd0-46ca-46da-9dcc-c6155b2a6d15 | 2019-10-01 03:25:42 | {\"nf_naming\":\"true\",\"skip_post_instantiation_configuration\":\"true\",\"multi_stage_design\":\"false\",\"availability_zone_max_count\":\"1\",\"nf_role\":\"BRG\",\"nf_type\":\"BRG\"} | +--------------------------------------+---------------------------------------+--------------------------------------+----------------------------------------+---------------------------------------+---------------------+-------------+-------------+-------------+----------------+---------------+---------------+--------------------------------------+---------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) MariaDB [catalogdb]> select * from allotted_resource_customization_to_service; +--------------------------------------+--------------------------------------+ | SERVICE_MODEL_UUID | RESOURCE_MODEL_CUSTOMIZATION_UUID | +--------------------------------------+--------------------------------------+ | d3aac917-543d-4421-b6d7-ba2b65884eb7 | 4e0249f0-5118-4323-b5e9-0783ad1123ba | | d3aac917-543d-4421-b6d7-ba2b65884eb7 | aff592e4-cfc7-43ce-abea-f026b56995ab | +--------------------------------------+--------------------------------------+ 2 rows in set (0.00 sec)