public static boolean removeEnduserNumplanMap(String value1) {
		String data = null;
		String string = null;
		Socket socket = null;
		OutputStream out = null;
		InputStream in = null;
		byte[] bArray = null;
		data = "<SOAP-ENV:Envelope xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" ";
		data = data
				+ "xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"> ";
		data = data
				+ "<SOAP-ENV:Body> <axl:executeSQLUpdate xmlns:axl=\"http://www.cisco.com/AXL/7.0\" ";
		data = data
				+ " xsi:schemaLocation=\"http://www.cisco.com/AXL/1.0 http://gkar.cisco.com/schema/axlsoap.xsd\" ";
		data = data + "sequence=\"1234\">";
		data = data
				+ "<sql>DELETE from endusernumplanmap WHERE fkdevice IS NOT ( SELECT pkid from device where name = '"
				+ value1 + "' )</sql>";
		data = data
				+ "</axl:executeSQLUpdate> </SOAP-ENV:Body> </SOAP-ENV:Envelope>";

		String header = Methods.getHttpsHeader(data);
		header = header + data;
		StringBuffer sb = null;
		try {
			AXLTrustManager axl = new AXLTrustManager();

			X509TrustManager xtm = axl.new MyTrustManager();
			TrustManager[] mytm = { xtm };
			SSLContext ctx = SSLContext.getInstance("SSL");
			ctx.init(null, mytm, null);
			SSLSocketFactory sslFact = (SSLSocketFactory) ctx
					.getSocketFactory();
			socket = (SSLSocket) sslFact.createSocket(Methods.getKeys("ip"),
					Integer.parseInt("8443"));
			in = socket.getInputStream();
			bArray = new byte[2048];
			sb = new StringBuffer(2048);
			int ch = 0;
			out = socket.getOutputStream();
			out.write(header.getBytes());
			while ((ch = in.read(bArray)) != -1) {
				sb.append(new String(bArray, 0, ch));
			}
			socket.close();
			string = sb.toString();
			String replacePhoneName = string.replace("<name/>",
					"<name>N/A</name>");
			String replaceFirstName = replacePhoneName.replace("<firstname/>",
					"<firstname>N/A</firstname>");
			String replaceLastName = replaceFirstName.replace("<lastname/>",
					"<lastname>N/A</lastname>");
			String replaceUserID = replaceLastName.replace("<userid/>",
					"<userid><NONE></userid>");
			String replaceDesc = replaceUserID.replace("<description/>",
					"<description>N/A</description>");
			String replaceModel = replaceDesc.replace("<tkmodel/>",
					"<tkmodel>N/A</tkmodel>");
			String replaceDevicepool = replaceModel.replace("<fkdevicepool/>",
					"<fkdevicepool>N/A</fkdevicepool>");
			String finalString = replaceDevicepool;
			Variables.phoneNames = Methods.substringsBetween(finalString,
					"<name>", "</name>");
			Variables.enduserFirstnames = Methods.substringsBetween(
					finalString, "<firstname>", "</firstname");
			Variables.enduserLastnames = Methods.substringsBetween(finalString,
					"<lastname>", "</lastname");
			Variables.phoneEndusers = Methods.substringsBetween(finalString,
					"<userid>", "</userid");
			Variables.phoneDesc = Methods.substringsBetween(finalString,
					"<description>", "</description");
			Variables.phoneModel = Methods.substringsBetween(finalString,
					"<tkmodel>", "</tkmodel");
			Variables.phoneDevpool = Methods.substringsBetween(finalString,
					"<fkdevicepool>", "</fkdevicepool");
			Variables.deviceTableRows = new String[Variables.phoneNames.length][9];
			for (int i = 0; i < Variables.phoneNames.length; i++) {
				Variables.deviceTableRows[i][0] = Integer.toString(i + 1);
				Variables.deviceTableRows[i][1] = Variables.phoneNames[i];
				Variables.deviceTableRows[i][2] = Variables.enduserFirstnames[i];
				Variables.deviceTableRows[i][3] = Variables.enduserLastnames[i];
				Variables.deviceTableRows[i][4] = Variables.phoneEndusers[i];
				Variables.deviceTableRows[i][5] = Variables.phoneDesc[i];
				Variables.deviceTableRows[i][6] = Variables.phoneModel[i];
				Variables.deviceTableRows[i][7] = Variables.phoneDevpool[i];
				Variables.deviceTableRows[i][8] = "false";
			}
		} catch (UnknownHostException e) {
			System.err.println("Error connecting to host: " + e.getMessage());
			return false;
		} catch (IOException ioe) {
			System.err.println("Error sending/receiving from server: "
					+ ioe.getMessage());
			try {
				if (socket != null) {
					socket.close();
				}
			} catch (Exception exc) {
				exc.printStackTrace();
				System.err.println("Error closing connection to server: "
						+ exc.getMessage());
			}
		} catch (Exception ea) {
			System.err.println("Unknown exception " + ea.getMessage());
			return false;
		} finally {
			try {
				if (socket != null) {
					socket.close();
				}
			} catch (Exception exc) {
				exc.printStackTrace();
				System.err.println("Error closing connection to server: "
						+ exc.getMessage());
			}
		}
		return true;
	}