SELECT
DISTINCT
Keith ERVICE_NUM serviceNum,
Keith ERVICE_SHORTNAME serviceShortname,
Keith ERVICE_DESCRIPTION serviceDescription,
C.s. YSTEM_FCNAME, CONCAT (' (', c.s. YSTEM_FENAME, ') ') system,
B.S ERVER_ENV env,
B.S ERVER_NUM serverNum,
D.I NTRANETIP_IP serverIP,
E.D IC_VALUE serverType,
F.S OFT_NAME softName
The FROM SN_BDCLUSTERPROCESS A
LEFT the JOIN SN_SERVER B ON A.C LUSTERPROCESS_SERVERNUM=B.S ERVER_NUM AND B.S ERVER_STATUS!
='DEL'LEFT the JOIN SN_SYSTEM C ON B.S ERVER_SYSTEMNUM=c.s. YSTEM_NUM AND c.s. YSTEM_STATUS!
='DEL'LEFT the JOIN SN_INTRANETIP D ON B.S ERVER_NUM=D.I NTRANETIP_DEVNUM AND D.I NTRANETIP_STATUS!
='DEL'LEFT the JOIN SN_DIC E ON B.S ERVER_VMTYPE=E.D IC_KEY AND E.D IC_STATUS!
='DEL'LEFT the JOIN SN_SOFT F ON B.S ERVER_APPNUM=F.S OFT_NUM AND F.S OFT_STATUS!
='DEL'LEFT the JOIN SN_BDCLUSTER G ON A.C LUSTERPROCESS_CLUSTERNUM=right LUSTER_NUM AND right LUSTER_STATUS!
='DEL'LEFT the JOIN SN_DIC H ON right LUSTER_TYPE=H.D IC_KEY AND H.D IC_STATUS!
='DEL'LEFT the JOIN SN_DIC I ON A.C LUSTERPROCESS_KEY=I.D IC_KEY AND I.D IC_STATUS!='DEL' AND I.D IC_TYPE='CLUSTER_TYPE'
LEFT the JOIN SN_BDSERVICECLUSTER J ON its LUSTER_NUM=A.C LUSTERPROCESS_CLUSTERNUM
LEFT the JOIN ON J.S ERVICE_NUM SN_BDSERVICE K=Keith ERVICE_NUM
WHERE 1=1
AND A.C LUSTERPROCESS_STATUS!
='DEL'AND Keith ERVICE_STATUS!
='DEL'GROUP BY A.C LUSTERPROCESS_SERVERNUM, A.C LUSTERPROCESS_CLUSTERNUM