parsing xml file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting parsing xml file
# 1  
Old 11-10-2011
parsing xml file

Hello!

We need to parse weblogic config.xml file and display rows in format:

machine:listen-port:name:application_name

In our enviroment the output should be (one line for every instance):
Code:
 
Crm-Test-Web:8001:PIA:peoplesoft
Crm-Test-Web:8011:PIA:peoplesoft
Crm-Test-Web:8021:PIA:peoplesoft
:9999:WebLogicAdmin:

The config.xml file looks like:
Code:
<?xml version='1.0' encoding='UTF-8'?>
<domain xmlns="http://xmlns.oracle.com/weblogic/domain" xmlns:sec="http://xmlns.oracle.com/weblogic/security" xmlns:wls="http://xmlns.oracle.com/weblogic/security/wls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http:... ...">
<name>peoplesoft</name>
<domain-version>10.3.3.0</domain-version>
<security-configuration>
<name>peoplesoft</name>
<realm>
<sec:authentication-provider xsi:type="wls:default-authenticatorType"></sec:authentication-provider>
<sec:authentication-provider xsi:type="wls:default-identity-asserterType">
<sec:active-type>AuthenticatedUser</sec:active-type>
</sec:authentication-provider>
<sec:role-mapper xmlns:xac="http://xmlns.oracle.com/weblogic/security/xacml" xsi:type="xac:xacml-role-mapperType"></sec:role-mapper>
<sec:authorizer xmlns:xac="http://xmlns.oracle.com/weblogic/security/xacml" xsi:type="xac:xacml-authorizerType"></sec:authorizer>
<sec:adjudicator xsi:type="wls:default-adjudicatorType"></sec:adjudicator>
<sec:credential-mapper xsi:type="wls:default-credential-mapperType"></sec:credential-mapper>
<sec:cert-path-provider xsi:type="wls:web-logic-cert-path-providerType"></sec:cert-path-provider>
<sec:cert-path-builder>WebLogicCertPathProvider</sec:cert-path-builder>
<sec:name>myrealm</sec:name>
<sec:password-validator xmlns:pas="http://xmlns.oracle.com/weblogic/security/providers/passwordvalidator" xsi:type="pas:system-password-validatorType">
<sec:name>SystemPasswordValidator</sec:name>
<pas:min-password-length>8</pas:min-password-length>
<pas:min-numeric-or-special-characters>1</pas:min-numeric-or-special-characters>
</sec:password-validator>
</realm>
<default-realm>myrealm</default-realm>
<credential-encrypted>{AES}H+LpfH72QMbs6SzJPEAgQSDLzuKuDWf8gfnMJCjVjxHPBUgXKSGs0VP0xNngwj2wDZtEmuX99q/3dSxLSW2khhki1acWq1XtG/MytpJTM1grhNQv4rxtPeUjMs2xWxCx</credential-encrypted>
<node-manager-username>system</node-manager-username>
<node-manager-password-encrypted>{AES}neDvoLnRRW2UiGENxwO2EiCDsQa0Q1KMU109Nby0Vfs=</node-manager-password-encrypted>
<enforce-valid-basic-auth-credentials>false</enforce-valid-basic-auth-credentials>
</security-configuration>
<server>
<name>WebLogicAdmin</name>
<ssl>
<name>WebLogicAdmin</name>
<listen-port>443</listen-port>
</ssl>
<log>
<name>WebLogicAdmin</name>
<file-name>./logs/WebLogicAdmin_weblogic.log</file-name>
<log-file-severity>Info</log-file-severity>
<redirect-stdout-to-server-log-enabled>true</redirect-stdout-to-server-log-enabled>
</log>
<execute-queue>
<name>weblogic.kernel.Default</name>
<thread-count>50</thread-count>
</execute-queue>
<listen-port>9999</listen-port>
<web-server>
<name>WebLogicAdmin</name>
<web-server-log>
<name>WebLogicAdmin</name>
<file-name>./logs/WebLogicAdmin_access.log</file-name>
<logging-enabled>false</logging-enabled>
</web-server-log>
<https-keep-alive-secs>120</https-keep-alive-secs>
</web-server>
<iiop-enabled>false</iiop-enabled>
<listen-address></listen-address>
<staging-directory-name>./stage</staging-directory-name>
<upload-directory-name>./upload</upload-directory-name>
<staging-mode>nostage</staging-mode>
<graceful-shutdown-timeout>30</graceful-shutdown-timeout>
<msi-file-replication-enabled>true</msi-file-replication-enabled>
<custom-identity-key-store-file-name>piaconfig/keystore/pskey</custom-identity-key-store-file-name>
<custom-identity-key-store-type>JKS</custom-identity-key-store-type>
<custom-trust-key-store-file-name>piaconfig/keystore/pskey</custom-trust-key-store-file-name>
<custom-trust-key-store-type>JKS</custom-trust-key-store-type>
</server>
<server>
<name>PIA</name>
<ssl>
<name>PIA</name>
<enabled>true</enabled>
<listen-port>8443</listen-port>
<server-private-key-alias>Crm-Test-Web</server-private-key-alias>
<identity-and-trust-locations>KeyStores</identity-and-trust-locations>
</ssl>
<log>
<name>PIA</name>
<file-name>./logs/PIA_weblogic.log</file-name>
<log-file-severity>Info</log-file-severity>
<redirect-stdout-to-server-log-enabled>true</redirect-stdout-to-server-log-enabled>
</log>
<execute-queue>
<name>weblogic.kernel.Default</name>
<thread-count>50</thread-count>
</execute-queue>
<machine>Crm-Test-Web</machine>
<listen-port>8001</listen-port>
<listen-port-enabled>true</listen-port-enabled>
<cluster xsi:nil="true"></cluster>
<web-server>
<name>PIA</name>
<web-server-log>
<name>PIA</name>
<file-name>./logs/PIA_access.log</file-name>
<logging-enabled>false</logging-enabled>
</web-server-log>
<https-keep-alive-secs>120</https-keep-alive-secs>
</web-server>
<iiop-enabled>false</iiop-enabled>
<listen-address>172.22.12.96</listen-address>
<java-compiler>javac</java-compiler>
<staging-directory-name>./stage</staging-directory-name>
<upload-directory-name>./upload</upload-directory-name>
<staging-mode>nostage</staging-mode>
<graceful-shutdown-timeout>30</graceful-shutdown-timeout>
<msi-file-replication-enabled>true</msi-file-replication-enabled>
<client-cert-proxy-enabled>false</client-cert-proxy-enabled>
<custom-identity-key-store-file-name>piaconfig/keystore/pskey</custom-identity-key-store-file-name>
<custom-identity-key-store-type>JKS</custom-identity-key-store-type>
<custom-trust-key-store-file-name>piaconfig/keystore/pskey</custom-trust-key-store-file-name>
<custom-trust-key-store-type>JKS</custom-trust-key-store-type>
<server-diagnostic-config>
<wldf-diagnostic-volume>Off</wldf-diagnostic-volume>
</server-diagnostic-config>
</server>
<server>
<name>PIA1</name>
<ssl>
<name>PIA1</name>
<enabled>true</enabled>
<listen-port>8443</listen-port>
<server-private-key-alias>Crm-Test-Web</server-private-key-alias>
<identity-and-trust-locations>KeyStores</identity-and-trust-locations>
</ssl>
<log>
<name>PIA1</name>
<file-name>./logs/PIA1_weblogic.log</file-name>
<log-file-severity>Info</log-file-severity>
<redirect-stdout-to-server-log-enabled>true</redirect-stdout-to-server-log-enabled>
</log>
<execute-queue>
<name>weblogic.kernel.Default</name>
<thread-count>50</thread-count>
</execute-queue>
<machine>Crm-Test-Web</machine>
<listen-port>8011</listen-port>
<listen-port-enabled>true</listen-port-enabled>
<cluster xsi:nil="true"></cluster>
<web-server>
<name>PIA1</name>
<web-server-log>
<name>PIA1</name>
<file-name>./logs/PIA1_access.log</file-name>
<logging-enabled>false</logging-enabled>
</web-server-log>
<https-keep-alive-secs>120</https-keep-alive-secs>
</web-server>
<iiop-enabled>false</iiop-enabled>
<listen-address>172.22.12.96</listen-address>
<java-compiler>javac</java-compiler>
<staging-directory-name>./stage</staging-directory-name>
<upload-directory-name>./upload</upload-directory-name>
<staging-mode>nostage</staging-mode>
<graceful-shutdown-timeout>30</graceful-shutdown-timeout>
<msi-file-replication-enabled>true</msi-file-replication-enabled>
<client-cert-proxy-enabled>false</client-cert-proxy-enabled>
<custom-identity-key-store-file-name>piaconfig/keystore/pskey</custom-identity-key-store-file-name>
<custom-identity-key-store-type>JKS</custom-identity-key-store-type>
<custom-trust-key-store-file-name>piaconfig/keystore/pskey</custom-trust-key-store-file-name>
<custom-trust-key-store-type>JKS</custom-trust-key-store-type>
<server-diagnostic-config>
<wldf-diagnostic-volume>Off</wldf-diagnostic-volume>
</server-diagnostic-config>
</server>
<server>
<name>PIA2</name>
<ssl>
<name>PIA2</name>
<enabled>true</enabled>
<listen-port>8443</listen-port>
<server-private-key-alias>Crm-Test-Web</server-private-key-alias>
<identity-and-trust-locations>KeyStores</identity-and-trust-locations>
</ssl>
<log>
<name>PIA2</name>
<file-name>./logs/PIA2_weblogic.log</file-name>
<log-file-severity>Info</log-file-severity>
<redirect-stdout-to-server-log-enabled>true</redirect-stdout-to-server-log-enabled>
</log>
<execute-queue>
<name>weblogic.kernel.Default</name>
<thread-count>50</thread-count>
</execute-queue>
<machine>Crm-Test-Web</machine>
<listen-port>8021</listen-port>
<listen-port-enabled>true</listen-port-enabled>
<cluster xsi:nil="true"></cluster>
<web-server>
<name>PIA2</name>
<web-server-log>
<name>PIA2</name>
<file-name>./logs/PIA2_access.log</file-name>
<logging-enabled>false</logging-enabled>
</web-server-log>
<https-keep-alive-secs>120</https-keep-alive-secs>
</web-server>
<iiop-enabled>false</iiop-enabled>
<listen-address>172.22.12.96</listen-address>
<java-compiler>javac</java-compiler>
<staging-directory-name>./stage</staging-directory-name>
<upload-directory-name>./upload</upload-directory-name>
<staging-mode>nostage</staging-mode>
<graceful-shutdown-timeout>30</graceful-shutdown-timeout>
<msi-file-replication-enabled>true</msi-file-replication-enabled>
<client-cert-proxy-enabled>false</client-cert-proxy-enabled>
<custom-identity-key-store-file-name>piaconfig/keystore/pskey</custom-identity-key-store-file-name>
<custom-identity-key-store-type>JKS</custom-identity-key-store-type>
<custom-trust-key-store-file-name>piaconfig/keystore/pskey</custom-trust-key-store-file-name>
<custom-trust-key-store-type>JKS</custom-trust-key-store-type>
<server-diagnostic-config>
<wldf-diagnostic-volume>Off</wldf-diagnostic-volume>
</server-diagnostic-config>
</server>
<server>
<name>RPS</name>
<ssl>
<name>RPS</name>
<enabled>true</enabled>
<listen-port>8443</listen-port>
<identity-and-trust-locations>KeyStores</identity-and-trust-locations>
</ssl>
<log>
<name>RPS</name>
<file-name>./logs/RPS_weblogic.log</file-name>
<log-file-severity>Info</log-file-severity>
<redirect-stdout-to-server-log-enabled>true</redirect-stdout-to-server-log-enabled>
</log>
<instrument-stack-trace-enabled>false</instrument-stack-trace-enabled>
<execute-queue>
<name>weblogic.kernel.Default</name>
<thread-count>50</thread-count>
</execute-queue>
<listen-port>8080</listen-port>
<web-server>
<name>RPS</name>
<web-server-log>
<name>RPS</name>
<file-name>./logs/RPS_access.log</file-name>
<logging-enabled>false</logging-enabled>
</web-server-log>
<https-keep-alive-secs>120</https-keep-alive-secs>
</web-server>
<iiop-enabled>false</iiop-enabled>
<listen-address></listen-address>
<staging-directory-name>./stage</staging-directory-name>
<upload-directory-name>./upload</upload-directory-name>
<staging-mode>nostage</staging-mode>
<msi-file-replication-enabled>true</msi-file-replication-enabled>
<custom-identity-key-store-file-name>piaconfig/keystore/pskey</custom-identity-key-store-file-name>
<custom-identity-key-store-type>JKS</custom-identity-key-store-type>
<custom-trust-key-store-file-name>piaconfig/keystore/pskey</custom-trust-key-store-file-name>
<custom-trust-key-store-type>JKS</custom-trust-key-store-type>
</server>
<server>
<name>PSEMHUB</name>
<ssl>
<name>PSEMHUB</name>
<enabled>false</enabled>
<listen-port>8002</listen-port>
<identity-and-trust-locations>KeyStores</identity-and-trust-locations>
</ssl>
<log>
<name>PSEMHUB</name>
<file-name>./logs/PSEMHUB_weblogic.log</file-name>
<log-file-severity>Info</log-file-severity>
<redirect-stdout-to-server-log-enabled>true</redirect-stdout-to-server-log-enabled>
</log>
<instrument-stack-trace-enabled>false</instrument-stack-trace-enabled>
<execute-queue>
<name>weblogic.kernel.Default</name>
<thread-count>50</thread-count>
</execute-queue>
<listen-port>8081</listen-port>
<web-server>
<name>PSEMHUB</name>
<web-server-log>
<name>PSEMHUB</name>
<file-name>./logs/PSEMHUB_access.log</file-name>
<logging-enabled>false</logging-enabled>
</web-server-log>
</web-server>
<iiop-enabled>false</iiop-enabled>
<listen-address></listen-address>
<staging-directory-name>./stage</staging-directory-name>
<upload-directory-name>./upload</upload-directory-name>
<staging-mode>nostage</staging-mode>
<msi-file-replication-enabled>true</msi-file-replication-enabled>
<custom-identity-key-store-file-name>piaconfig/keystore/pskey</custom-identity-key-store-file-name>
<custom-identity-key-store-type>JKS</custom-identity-key-store-type>
<custom-trust-key-store-file-name>piaconfig/keystore/pskey</custom-trust-key-store-file-name>
<custom-trust-key-store-type>JKS</custom-trust-key-store-type>
</server>
<server>
<name>PSOL</name>
<ssl>
<name>PSOL</name>
<enabled>false</enabled>
<listen-port>6002</listen-port>
<identity-and-trust-locations>KeyStores</identity-and-trust-locations>
</ssl>
<log>
<name>PSOL</name>
<file-name>./logs/PSOL_weblogic.log</file-name>
<log-file-severity>Info</log-file-severity>
<redirect-stdout-to-server-log-enabled>true</redirect-stdout-to-server-log-enabled>
</log>
<instrument-stack-trace-enabled>false</instrument-stack-trace-enabled>
<execute-queue>
<name>weblogic.kernel.Default</name>
<thread-count>50</thread-count>
</execute-queue>
<listen-port>6001</listen-port>
<web-server>
<name>PSOL</name>
<web-server-log>
<name>PSOL</name>
<file-name>./logs/PSOL_access.log</file-name>
<logging-enabled>false</logging-enabled>
</web-server-log>
</web-server>
<iiop-enabled>false</iiop-enabled>
<listen-address></listen-address>
<staging-directory-name>./stage</staging-directory-name>
<upload-directory-name>./upload</upload-directory-name>
<staging-mode>nostage</staging-mode>
<graceful-shutdown-timeout>30</graceful-shutdown-timeout>
<msi-file-replication-enabled>true</msi-file-replication-enabled>
<custom-identity-key-store-file-name>piaconfig/keystore/pskey</custom-identity-key-store-file-name>
<custom-identity-key-store-type>JKS</custom-identity-key-store-type>
<custom-trust-key-store-file-name>piaconfig/keystore/pskey</custom-trust-key-store-file-name>
<custom-trust-key-store-type>JKS</custom-trust-key-store-type>
</server>
<cluster>
<name>peoplesoftCluster</name>
<multicast-address>239.192.0.0</multicast-address>
<multicast-port>7001</multicast-port>
<cluster-messaging-mode>unicast</cluster-messaging-mode>
</cluster>
<embedded-ldap>
<name>peoplesoft</name>
<credential-encrypted>{AES}C41eNE8xTc8w1i/+kZblVFUqK+vW9GheuNpZX96kJb0jd2UuAnYZqwewV32L76H3</credential-encrypted>
</embedded-ldap>
<configuration-version>10.3.3.0</configuration-version>
<app-deployment>
<name>peoplesoft</name>
<target>PIA,PIA1,PIA2</target>
<module-type>ear</module-type>
<source-path>applications/peoplesoft</source-path>
<sub-deployment>
<name>PORTAL.war</name>
<target>peoplesoftCluster</target>
</sub-deployment>
<sub-deployment>
<name>/PSIGW</name>
<target>peoplesoftCluster,PIA</target>
</sub-deployment>
<sub-deployment>
<name>/PSINTERLINKS</name>
<target>peoplesoftCluster,PIA</target>
</sub-deployment>
<sub-deployment>
<name>/PSOL</name>
<target>PIA,PSOL</target>
</sub-deployment>
<sub-deployment>
<name>/PSEMHUB</name>
<target>PIA,PSEMHUB</target>
</sub-deployment>
<sub-deployment>
<name>/pspc</name>
<target>PIA</target>
</sub-deployment>
<sub-deployment>
<name>/testsuite</name>
<target>PIA</target>
</sub-deployment>
<sub-deployment>
<name>/wsrptest</name>
<target>PIA</target>
</sub-deployment>
<sub-deployment>
<name>/helloportletapp</name>
<target>PIA</target>
</sub-deployment>
<deployment-order>1</deployment-order>
<security-dd-model>DDOnly</security-dd-model>
<staging-mode>nostage</staging-mode>
</app-deployment>
<app-deployment>
<name>HttpClusterServlet</name>
<target>RPS</target>
<module-type>war</module-type>
<source-path>applications/HttpClusterServlet</source-path>
<deployment-order>1</deployment-order>
<security-dd-model>DDOnly</security-dd-model>
<staging-mode>nostage</staging-mode>
</app-deployment>
<app-deployment>
<name>HttpProxyServlet</name>
<target>RPS</target>
<module-type>war</module-type>
<source-path>applications/HttpProxyServlet</source-path>
<deployment-order>1</deployment-order>
<security-dd-model>DDOnly</security-dd-model>
<staging-mode>nostage</staging-mode>
</app-deployment>
<app-deployment>
<name>PORTAL</name>
<target>PIA,PIA1,PIA2</target>
<module-type>war</module-type>
<source-path>applications/peoplesoft/PORTAL.war</source-path>
<security-dd-model>DDOnly</security-dd-model>
</app-deployment>
<machine xsi:type="unix-machineType">
<name>Crm-Test-Web</name>
<node-manager>
<nm-type>SSL</nm-type>
<listen-port>5556</listen-port>
<debug-enabled>false</debug-enabled>
</node-manager>
</machine>
<admin-server-name>WebLogicAdmin</admin-server-name>
</domain>


Thank you very much!

Moderator's Comments:
Mod Comment Please use code tags <- click the link!

Last edited by zaxxon; 11-10-2011 at 08:00 AM.. Reason: code tags, see PM
# 2  
Old 11-10-2011
What about if you'd mark at least the places in this small xml snippet (maybe marking bold) where the values are that you need?
While we are at it - what have you tried so far?
# 3  
Old 11-10-2011
Moderator's Comments:
Mod Comment xml content attached


We have a script that works for a previous version of weblogic (config.xml file looks completly different). We tried to change the old script, or use awk command. But it was unsuccessfull.

Thank you for your fast feedback.

Last edited by radoulov; 11-10-2011 at 08:20 AM..
# 4  
Old 11-10-2011
If you can install XMLgawk:

Code:
xgawk -lxml 'XMLCHARDATA { 
  data[XMLPATH] = $0 
  }
  XMLENDELEM ~ /machine|listen-port/ &&
  XMLPATH ~ /domain\/server\/(listen-port|machine)/ { 
    print data["/domain/server/machine"], data["/domain/server/listen-port"],
    data["/domain/server/name"], data["/domain/name"]
    }' OFS=: sample.xml

I get this output with your xml:

Code:
:9999:WebLogicAdmin:peoplesoft
Crm-Test-Web:9999:PIA:peoplesoft
Crm-Test-Web:8001:PIA:peoplesoft
Crm-Test-Web:8001:PIA:peoplesoft
Crm-Test-Web:8001:PIA1:peoplesoft
Crm-Test-Web:8011:PIA1:peoplesoft
Crm-Test-Web:8011:PIA1:peoplesoft
Crm-Test-Web:8011:PIA2:peoplesoft
Crm-Test-Web:8021:PIA2:peoplesoft
Crm-Test-Web:8021:PIA2:peoplesoft
Crm-Test-Web:8080:RPS:peoplesoft
Crm-Test-Web:8081:PSEMHUB:peoplesoft
Crm-Test-Web:6001:PSOL:peoplesoft

# 5  
Old 11-16-2011
Hello!
We installed XMLgawk and ran your script.
We get wrong results and too many rows:
Code:
:9999:WebLogicAdmineoplesoft
Crm-Test-Web:9999:PIA: peoplesoft
Crm-Test-Web:8001:PIA: peoplesoft
Crm-Test-Web:8001:PIA: peoplesoft
Crm-Test-Web:8001:PIA1: peoplesoft
Crm-Test-Web:8011:PIA1: peoplesoft
Crm-Test-Web:8011:PIA1: peoplesoft
Crm-Test-Web:8011:PIA2: peoplesoft
Crm-Test-Web:8021:PIA2: peoplesoft
Crm-Test-Web:8021:PIA2: peoplesoft
Crm-Test-Web:8080:RPS: peoplesoft
Crm-Test-Web:8081:PSEMHUB: peoplesoft
Crm-Test-Web:6001:PSOL: peoplesoft

We expecting to get only 4 next rows:

Code:
:9999:WebLogicAdmin: peoplesoft
Crm-Test-Web:8001:PIA: peoplesoft
Crm-Test-Web:8011:PIA1: peoplesoft
Crm-Test-Web:8021:PIA2: peoplesoft


What we need to change in the script?

Thank you

Last edited by radoulov; 11-16-2011 at 05:29 AM.. Reason: Added code tags.
# 6  
Old 11-16-2011
Yes, the code need to be corrected.
Using the latest xml attached to your post the following code produces the following result:

Code:
xgawk -lxml 'XMLCHARDATA {
  d[XMLPATH] = $0
  }
XMLENDELEM == "name" {
  XMLPATH == "/domain/server/name" && name = d["/domain/server/name"]
  XMLPATH == "/domain/name"        && domain_name = d["/domain/name"]
  }
XMLENDELEM == "listen-port" && XMLPATH == "/domain/server/listen-port" {
  listen_port = d["/domain/server/listen-port"]
  }
XMLENDELEM == "machine" && XMLPATH == "/domain/server/machine" {
  machine = d["/domain/server/machine"]
  }
XMLENDELEM == "server" {  
  print machine, listen_port, name, domain_name
  }' OFS=: sample.xml

Output:

Code:
:9999:WebLogicAdmin:peoplesoft
Crm-Test-Web:8001:PIA:peoplesoft
Crm-Test-Web:8011:PIA1:peoplesoft
Crm-Test-Web:8021:PIA2:peoplesoft
Crm-Test-Web:8080:RPS:peoplesoft
Crm-Test-Web:8081:PSEMHUB:peoplesoft
Crm-Test-Web:6001:PSOL:peoplesoft

Is it wrong?

Edit: rewritten using the switch statement:

Code:
xgawk -lxml 'XMLCHARDATA { d[XMLPATH] = $0 }
{ 
  switch (XMLENDELEM) {
    case "name": 
      switch (XMLPATH) { 
        case "/domain/server/name":  
          name = d["/domain/server/name"]
          break
        case "/domain/name":
          domain_name = d["/domain/name"]
          break
        }
    case "listen-port":
      XMLPATH == "/domain/server/listen-port" && 
        listen_port = d["/domain/server/listen-port"]
      break
    case "machine": 
      XMLPATH == "/domain/server/machine" && 
        machine = d["/domain/server/machine"]
      break
    case "server":  
      print machine, listen_port, name, domain_name
      break  
    }
  }' OFS=: sample.xml


Last edited by radoulov; 11-16-2011 at 07:08 AM..
# 7  
Old 11-16-2011
Hi!
Yes, this is wrong, because:

only PIA listen to port 8001
only PIA1 listen to port 8011
only PIA2 listen to port 8021
and only WeblogicAdmin listen to port 9999.

So we expecting to get only 4 rows.

---------- Post updated at 10:28 AM ---------- Previous update was at 10:27 AM ----------

Also, we need only PIA, PIA1,PIA2, admin.

Thank you.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with parsing xml file

Hi, Need help with parsing xml data in unix and place it in a csv file. My xml file looks like this: <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> <iwgroups> <nextid value="128"> </nextid> <iwgroup name="RXapproval" id="124" display-name="RXapproval"... (11 Replies)
Discussion started by: ajayakunuri
11 Replies

2. UNIX for Dummies Questions & Answers

Parsing XML file

I want to parse xml file sample file....... <name locale="en">my_name<>/name><lastChanged>somedate</lastChanged><some more code here> <name locale="en">tablename1<>/name><lastChanged>somedate</lastChanged> <definition><dbquery><sources><sql type="cognos">select * from... (10 Replies)
Discussion started by: ms2001
10 Replies

3. Shell Programming and Scripting

XML: parsing of the Google contacts XML file

I am trying to parse the XML Google contact file using tools like xmllint and I even dived into the XSL Style Sheets using xsltproc but I get nowhere. I can not supply any sample file as it contains private data but you can download your own contacts using this script: #!/bin/sh # imports... (9 Replies)
Discussion started by: ripat
9 Replies

4. Shell Programming and Scripting

Help in parsing XML output file in perl.

Hi I have an XML output like : <?xml version="1.0" encoding="ISO-8859-1" ?> - <envelope> - <body> - <outputGetUsageSummary> - <usgSumm rerateDone="5"> - <usageAccum accumId="269" accumCaptn="VD_DP_AR" inclUnits="9999999.00" inclUnitsUsed="0.00" shared="false" pooled="false"... (7 Replies)
Discussion started by: rkrish
7 Replies

5. Shell Programming and Scripting

Parsing an XML file

Hello, I have the following xml file as an input. <?xml version="1.0" encoding="UTF-8"?> <RECORDS PS3_VERSION="1104_01"><RECORD> <POI_ID>931</POI_ID> <SUPPLIER_ID>2</SUPPLIER_ID> <POI_PVID>997920846</POI_PVID> <DB_ID>1366650925</DB_ID> <REGION>H1</REGION> <POI_NAME NAME_TYPE="Official"... (4 Replies)
Discussion started by: ramky79
4 Replies

6. Shell Programming and Scripting

Help in parsing xml file (sed/nawk)

I have a large xml file as shown below: <input> <blah> <blah> <atr="blah blah value = ""> <blah> <blah> </input> ..2nd chunk... ..3rd chunk... ...4th chunk... All lines between <input> and </input> is one 'order' and this 'order' is repeated... (14 Replies)
Discussion started by: shekhar2010us
14 Replies

7. Shell Programming and Scripting

Parsing xml file

hi guys, great help to the original question, can i expand please? i have large files filled with blocks like this <Placemark> network type: hot line1 line2 line3 <styleUrl>red.png</styleUrl> </Placemark> <Placemark> network type: cold line1 line2 line3... (3 Replies)
Discussion started by: garvald
3 Replies

8. UNIX for Dummies Questions & Answers

Help parsing a XML file ....

Well I have read several threads on the subject ... but being a newbie like me makes it hard to understand ... What I need is the following: Input data: ------- snip --------- <FavouriteLocations> <FavouriteLocations class="FavouriteList"><Item... (6 Replies)
Discussion started by: misak
6 Replies

9. Shell Programming and Scripting

XML file parsing using script

Hi I need some help with XML file parsing. I have an XML file with the below tag, I need a script to identify the value of srvcName which is this case is "AAA srvc name". I need to put contents of this value which is AAA srvc and name into different variables using an array and then reformat it... (6 Replies)
Discussion started by: zmfcat1
6 Replies

10. UNIX for Advanced & Expert Users

Parsing xml file using Sed

Hi All, I have this(.xml) file as: <!-- define your instance here --> <instance name='ins_C2Londondev' user='' group='' fullname='B2%20-%20London%20(dev)' > <property> </property> </instance> I want output as: <!-- define your instance here --> <instance... (3 Replies)
Discussion started by: kapilkinha
3 Replies
Login or Register to Ask a Question