summaryrefslogtreecommitdiffstats
path: root/cmso-robot/robot/assets/sql/VericaQueries.sql
blob: 9d59f43c2946f9767475c9a06f63fa34c0759d67 (plain) 
1
2
3
4
5
6
7
8
9

 SELECT distinct vnf_name, pserver_fqdn, pserver_hostname
            from qa0_dcaecommon_views.v_vnf_vm_pserver;
            
SELECT distinct vnf_name, pserver_fqdn, pserver_hostname from qa0_dcaecommon_views.v_vce_vm_pserver where vnf_name in ('ZRDM1MMSC04')
UNION
SELECT distinct vnf_name, pserver_fqdn, pserver_hostname from qa0_dcaecommon_views.v_vnf_vm_pserver where vnf_name in ('ZRDM1MMSC04')
UNION
SELECT distinct vnf_name, pserver_fqdn, pserver_hostname from qa0_dcaecommon_views.v_vpe_vm_pserver where vnf_name in ('ZRDM1MMSC04')
;