SELECT
DISTINCT
K.SERVICE_NUM serviceNum,
K.SERVICE_SHORTNAME serviceShortname,
K.SERVICE_DESCRIPTION serviceDescription,
CONCAT(C.SYSTEM_FCNAME,'(',C.SYSTEM_FENAME,')') system,
B.SERVER_ENV env,
B.SERVER_NUM serverNum,
D.INTRANETIP_IP serverIP,
E.DIC_VALUE serverType,
F.SOFT_NAME softName
FROM SN_BDCLUSTERPROCESS A
LEFT JOIN SN_SERVER B ON A.CLUSTERPROCESS_SERVERNUM=B.SERVER_NUM AND B.SERVER_STATUS !='DEL'
LEFT JOIN SN_SYSTEM C ON B.SERVER_SYSTEMNUM=C.SYSTEM_NUM AND C.SYSTEM_STATUS !='DEL'
LEFT JOIN SN_INTRANETIP D ON B.SERVER_NUM=D.INTRANETIP_DEVNUM AND D.INTRANETIP_STATUS !='DEL'
LEFT JOIN SN_DIC E ON B.SERVER_VMTYPE=E.DIC_KEY AND E.DIC_STATUS!='DEL'
LEFT JOIN SN_SOFT F ON B.SERVER_APPNUM=F.SOFT_NUM AND F.SOFT_STATUS !='DEL'
LEFT JOIN SN_BDCLUSTER G ON A.CLUSTERPROCESS_CLUSTERNUM=G.CLUSTER_NUM AND G.CLUSTER_STATUS !='DEL'
LEFT JOIN SN_DIC H ON G.CLUSTER_TYPE=H.DIC_KEY AND H.DIC_STATUS!='DEL'
LEFT JOIN SN_DIC I ON A.CLUSTERPROCESS_KEY=I.DIC_KEY AND I.DIC_STATUS!='DEL' AND I.DIC_TYPE='CLUSTER_TYPE'
LEFT JOIN SN_BDSERVICECLUSTER J ON J.CLUSTER_NUM=A.CLUSTERPROCESS_CLUSTERNUM
LEFT JOIN SN_BDSERVICE K ON J.SERVICE_NUM=K.SERVICE_NUM
WHERE 1=1
AND A.CLUSTERPROCESS_STATUS != 'DEL'
AND K.SERVICE_STATUS !='DEL'
GROUP BY A.CLUSTERPROCESS_SERVERNUM,A.CLUSTERPROCESS_CLUSTERNUM
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/109464.html
標籤：MySQL
上一篇：VFP 9.0epson tm-t86l 列印電影票 但不能自動切紙，高分請教在報表設計器中如何實作自動切紙
下一篇：主從復制的時候如何 設定 賬號