Link to home
Start Free TrialLog in
Avatar of Deathrace
DeathraceFlag for India

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
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.

Open in new window

Avatar of x-men
x-men
Flag of Portugal image

First, Replace the ":" for "," (comma separated)
 then:

LogParser "SELECT * INTO myTable FROM myLog.csv" -i:CSV -o:SQL -server:MyServer -database:MyDatabase -driver:"SQL Server" -username:TestSQLUser -password:TestSQLPassword -createTable:ON

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Deathrace
Deathrace
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
where will it "parse" it to?
Avatar of Deathrace

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...