Hi,
I have a notepad with unstructured data and i want to get structured data like (server name, user name and commands) and store it in excel.
please find the attached notepad data and below sample structured excel data.
structured Excel Data:
Notepad Data:
HEARTBEAT failed TWICE for psmanager.jar on server brrpappbib01 !!!
The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40.
---> Please logon as user cognos on brrpappbib01, do a cd $HOME, execute the script $HOME/start_psmanager and make sure that the java process is running.
---------------------------------------------------------------------------------------------------
HEARTBEAT failed TWICE for psmanager.jar on server brrpappbib02 !!!
The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40.
---> Please logon as user cognos on brrpappbib02, do a cd $HOME, execute the script $HOME/start_psmanager and make sure that the java process is running.
---------------------------------------------------------------------------------------------------
HEARTBEAT failed TWICE for psmanager.jar on server brpsappcab01 !!!
The reason is : host error: unknown host brpsappcab01 at /opt/oracle/scripts/do_remote_task line 30. .. host error: unknown host brpsappcab01 at /opt/oracle/scripts/do_remote_task line 30.
---> Please execute the script $COMMON_SCRIPTS/start_psmanager as user psoft on brpsappcab01 and make sure that the java process is running.
---------------------------------------------------------------------------------------------------
HEARTBEAT failed TWICE for psmanager.jar on server brpsappcab02 !!!
The reason is : host error: unknown host brpsappcab02 at /opt/oracle/scripts/do_remote_task line 30. .. host error: unknown host brpsappcab02 at /opt/oracle/scripts/do_remote_task line 30.
---> Please execute the script $COMMON_SCRIPTS/start_psmanager as user psoft on brpsappcab02 and make sure that the java process is running.
---------------------------------------------------------------------------------------------------
HEARTBEAT failed TWICE for psmanager.jar on server brpsappint1 !!!
The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40.
---> Please execute the script $COMMON_SCRIPTS/start_psmanager as user psoft on brpsappint1 and make sure that the java process is running.
---------------------------------------------------------------------------------------------------
HEARTBEAT failed TWICE for psmanager.jar on server brdiappcaa2 !!!
The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40.
---> Please logon as user oracle on brdiappcaa2, do a cd $HOME, execute the script $HOME/start_psmanager and make sure that the java process is running.
---------------------------------------------------------------------------------------------------
HEARTBEAT failed TWICE for psmanager.jar on server brdiappcab1 !!!
The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40.
---> Please logon as user oracle on brdiappcab1, do a cd $HOME, execute the script $HOME/start_psmanager and make sure that the java process is running.
---------------------------------------------------------------------------------------------------
HEARTBEAT failed TWICE for psmanager.jar on server brdiappcab2 !!!
The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40.
---> Please logon as user oracle on brdiappcab2, do a cd $HOME, execute the script $HOME/start_psmanager and make sure that the java process is running.
---------------------------------------------------------------------------------------------------
HEARTBEAT failed TWICE for psmanager.jar on server brdiappint1 !!!
The reason is : connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40. .. connect error: Connection refused at /opt/oracle/scripts/do_remote_task line 40.
---> Please logon as user oracle on brdiappint1, do a cd $HOME, execute the script $HOME/start_psmanager and make sure that the java process is running.
---------------------------------------------------------------------------------------------------
Thanks,
Mounika