Deathrace
asked on
Logparser to parser informatica log file
Hi Experts,
Below is sample authentication log, how can i use logparser to manage these information to sql server DB.
any help...please
Below is sample authentication log, how can i use logparser to manage these information to sql server DB.
any help...please
2009-09-23 02:18:43 : WARNING : (5044 | 699) : (RS | PowerCenter2) : node01_uxs2mp13 : CNX_53080 : Client connected to repserver with unknown client host name.
2009-09-23 02:18:43 : INFO : (5044 | 699) : (RS | PowerCenter2) : node01_uxs2mp13 : CNX_53039 : Received TCP connection from host *UNKNOWN* (10.12.88.155), port 1454. Connection ID: 692.
2009-09-23 02:18:44 : INFO : (5044 | 699) : (RS | PowerCenter2) : node01_uxs2mp13 : CNX_53130 : Client repository version is 179, data version is 88, and product version is 8.6.0.
2009-09-23 02:18:44 : INFO : (5044 | 699) : (RS | PowerCenter2) : node01_uxs2mp13 : CNX_53032 : User inuser01 using application Designer on host *UNKNOWN* (10.12.88.155), port 1454, logged in successfully.
2009-09-23 02:18:44 : INFO : (5044 | 699) : (RS | PowerCenter2) : node01_uxs2mp13 : CNX_53124 : High availability is turned on for this connection. The max resilience timeout is set to 180. The heartbeat interval is set to 60.
2009-09-23 02:34:06 : INFO : (2210 | 448) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53039 : Received TCP connection from host usmumgjoshi1.us.deloitte.com (10.12.90.116), port 4775. Connection ID: 441.
2009-09-23 02:34:06 : INFO : (2210 | 448) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53130 : Client repository version is 179, data version is 88, and product version is 8.6.0 HotFix8.
2009-09-23 02:34:07 : INFO : (2210 | 448) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53032 : User jpurkayastha using application Repository Manager on host usmumgjoshi1.us.deloitte.com (10.12.90.116), port 4775, logged in successfully.
2009-09-23 02:34:07 : INFO : (2210 | 448) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53124 : High availability is turned on for this connection. The max resilience timeout is set to 180. The heartbeat interval is set to 60.
2009-09-23 02:35:30 : INFO : (5044 | 699) : (RS | PowerCenter2) : node01_uxs2mp13 : CNX_53117 : Repository service process failed to process request ID 107, request operation code 447, reply operation code 447. Return Status: 2.
2009-09-23 02:35:30 : INFO : (5044 | 699) : (RS | PowerCenter2) : node01_uxs2mp13 : CNX_53117 : Repository service process failed to process request ID 107, request operation code 447, reply operation code 447. Return Status: 2.
2009-09-23 02:39:23 : INFO : (5044 | 699) : (RS | PowerCenter2) : node01_uxs2mp13 : CNX_53035 : Received logout request from user inuser01 on host *UNKNOWN* (10.12.88.155) port 1454.
2009-09-23 02:42:19 : WARNING : (5044 | 700) : (RS | PowerCenter2) : node01_uxs2mp13 : CNX_53080 : Client connected to repserver with unknown client host name.
2009-09-23 02:42:19 : INFO : (5044 | 700) : (RS | PowerCenter2) : node01_uxs2mp13 : CNX_53039 : Received TCP connection from host *UNKNOWN* (10.12.88.155), port 3010. Connection ID: 693.
2009-09-23 02:42:19 : INFO : (5044 | 700) : (RS | PowerCenter2) : node01_uxs2mp13 : CNX_53130 : Client repository version is 179, data version is 88, and product version is 8.6.0.
2009-09-23 02:42:20 : INFO : (5044 | 700) : (RS | PowerCenter2) : node01_uxs2mp13 : CNX_53032 : User inuser01 using application Designer on host *UNKNOWN* (10.12.88.155), port 3010, logged in successfully.
2009-09-23 02:42:20 : INFO : (5044 | 700) : (RS | PowerCenter2) : node01_uxs2mp13 : CNX_53124 : High availability is turned on for this connection. The max resilience timeout is set to 180. The heartbeat interval is set to 60.
2009-09-23 03:01:27 : INFO : (5044 | 700) : (RS | PowerCenter2) : node01_uxs2mp13 : CNX_53035 : Received logout request from user inuser01 on host *UNKNOWN* (10.12.88.155) port 3010.
2009-09-23 03:15:56 : INFO : (2210 | 448) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53035 : Received logout request from user jpurkayastha on host usmumgjoshi1.us.deloitte.com (10.12.90.116) port 4775.
2009-09-23 03:26:39 : INFO : (2210 | 449) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53039 : Received TCP connection from host uxs2mp13 (10.233.9.163), port 49983. Connection ID: 442.
2009-09-23 03:26:39 : INFO : (2210 | 449) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53130 : Client repository version is 179, data version is 88, and product version is 8.6.1.
2009-09-23 03:26:40 : INFO : (2210 | 449) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53032 : User rispandya using application pmrep on host uxs2mp13 (10.233.9.163), port 49983, logged in successfully.
2009-09-23 03:26:40 : INFO : (2210 | 449) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53124 : High availability is turned on for this connection. The max resilience timeout is set to 180. The heartbeat interval is set to 60.
2009-09-23 03:26:44 : INFO : (2210 | 449) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53035 : Received logout request from user rispandya on host uxs2mp13 (10.233.9.163) port 49983.
2009-09-23 03:26:58 : INFO : (2210 | 450) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53039 : Received TCP connection from host uxs2mp13 (10.233.9.163), port 49992. Connection ID: 443.
2009-09-23 03:26:58 : INFO : (2210 | 450) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53130 : Client repository version is 179, data version is 88, and product version is 8.6.1.
2009-09-23 03:26:58 : INFO : (2210 | 450) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53032 : User rispandya using application pmrep on host uxs2mp13 (10.233.9.163), port 49992, logged in successfully.
2009-09-23 03:26:58 : INFO : (2210 | 450) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53124 : High availability is turned on for this connection. The max resilience timeout is set to 180. The heartbeat interval is set to 60.
2009-09-23 03:26:59 : INFO : (2210 | 450) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53035 : Received logout request from user rispandya on host uxs2mp13 (10.233.9.163) port 49992.
2009-09-23 03:28:09 : INFO : (2210 | 451) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53039 : Received TCP connection from host uxs2mp13 (10.233.9.163), port 50018. Connection ID: 444.
2009-09-23 03:28:09 : INFO : (2210 | 451) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53130 : Client repository version is 179, data version is 88, and product version is 8.6.1.
2009-09-23 03:28:11 : INFO : (2210 | 451) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53032 : User rispandya using application pmrep on host uxs2mp13 (10.233.9.163), port 50018, logged in successfully.
2009-09-23 03:28:11 : INFO : (2210 | 451) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53124 : High availability is turned on for this connection. The max resilience timeout is set to 180. The heartbeat interval is set to 60.
2009-09-23 03:28:14 : INFO : (2210 | 451) : (RS | snetcoe) : node01_uxs2mp13 : CNX_53035 : Received logout request from user rispandya on host uxs2mp13 (10.233.9.163) port 50018.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
where will it "parse" it to?
ASKER
basically it parses the whole .log file, and displays on screen the main idea is to use -i:tsv with separator..
i thought your goal was to parse it to an SQL BD...
then:
Open in new window