SELECT SERVER_ID, SERVER_DESC, SERVER_URL,EXT_SERVER_URL, SERVER_VAULT_PATH
                        ,DISABLED, CLIENT_LIC_NO, REMARKS, PDF_LICENSE_KEY,ALLOW_REPLICATION
                        ,UPGRADED
                        ,ISNULL(INTERNAL_ATOM_URL,'') INTERNAL_ATOM_URL 
                        ,ISNULL(EXTERNAL_ATOM_URL,'') EXTERNAL_ATOM_URL
                        ,SERVER_TYPE,PARENT_SERVER_ID ,PUBLISHER_SERVER_ID,
                        GUI_ID,MAC_ID,
                        CASE 
                            WHEN SERVER_TYPE=1 
                            THEN 'Main Server' 
                            WHEN SERVER_TYPE=2 
                            THEN 'Sattellite Server' 
                        END AS SERVER_TYPE_STRING ,
                        0 AS MEMBER_SERVER,WRENCH_DRIVE_SHARED_PATH , WRENCH_DRIVE_LETTER
                        ,IS_VAULT_IN_DIFF_DOMAIN,VAULT_USER_NAME,VAULT_PASSWORD,WEB_API_SERVER_PATH,WEB_API_SERVER_URL,WEB_API_SERVER_EXTERNAL_URL,ATOM_SERVICE_URL,EXTERNAL_ATOM_SERVICE_URL,CLOUD_SHARED_PATH,LOCAL_SHARED_PATH,WEB_API_LOCAL_URL
 

                        FROM SERVER_MST
                        WHERE  (MAC_ID IS NULL OR MAC_ID='' OR MAC_ID LIKE '%00-50-56-A0-E0-5B%' OR MAC_ID LIKE '%00-50-56-A0-60-17%' OR MAC_ID LIKE '%00-50-56-A0-5C-D7%')UNION
                        SELECT SERVER_ID, SERVER_DESC, SERVER_URL,EXT_SERVER_URL, SERVER_VAULT_PATH
                        ,DISABLED, CLIENT_LIC_NO, REMARKS,PDF_LICENSE_KEY, ALLOW_REPLICATION
                        ,UPGRADED
                        ,ISNULL(INTERNAL_ATOM_URL,'') INTERNAL_ATOM_URL 
                        ,ISNULL(EXTERNAL_ATOM_URL,'') EXTERNAL_ATOM_URL
                        ,SERVER_TYPE,PARENT_SERVER_ID ,PUBLISHER_SERVER_ID,GUI_ID,MAC_ID,
                        CASE WHEN SERVER_TYPE=1 THEN 'Main Server' 
                            WHEN SERVER_TYPE=2 
                            THEN 'Sattellite Server' 
                        END AS SERVER_TYPE_STRING,
                        1 AS MEMBER_SERVER,WRENCH_DRIVE_SHARED_PATH ,WRENCH_DRIVE_LETTER
                        ,IS_VAULT_IN_DIFF_DOMAIN,VAULT_USER_NAME,VAULT_PASSWORD,WEB_API_SERVER_PATH,WEB_API_SERVER_URL,WEB_API_SERVER_EXTERNAL_URL,ATOM_SERVICE_URL,EXTERNAL_ATOM_SERVICE_URL,CLOUD_SHARED_PATH,LOCAL_SHARED_PATH,WEB_API_LOCAL_URL
                        FROM SERVER_MST
                        WHERE PUBLISHER_SERVER_ID =(SELECT SERVER_ID FROM SERVER_MST 
                        WHERE SERVER_TYPE=1 AND (MAC_ID LIKE '%00-50-56-A0-E0-5B%' OR MAC_ID LIKE '%00-50-56-A0-60-17%' OR MAC_ID LIKE '%00-50-56-A0-5C-D7%'))AND SERVER_ID NOT IN (SELECT SERVER_ID FROM SERVER_MST 
                        WHERE  (  MAC_ID IS NULL OR MAC_ID='' OR MAC_ID LIKE '%00-50-56-A0-E0-5B%' OR MAC_ID LIKE '%00-50-56-A0-60-17%' OR MAC_ID LIKE '%00-50-56-A0-5C-D7%'))