MAO-JAN
asked on
netflow log problem
Hi!!!
Need advice, to solve problem with netflow log analyze !!!
Have some logs from Cisco netflow, but didn't find programs to analyze it:
SawMill 7.2.10 (Windows) gives some error:
Profile Summary
Profile: Untitled
Database: LogAnalysisInfo\Databases\ untitled\
Last modified: -
Last operation: -
Log data format: Cisco NetFlow (flow-export)
Earliest log entry: -
Latest log entry: -
__________________________ ____
Sawmill Alert
Syntax error: Unknown variable 'unix_secs' in expression while processing :0
Error occurred while parsing at the following location:
-------------------------- ---------- ---------- ---------- ---------- ---------- ----
date_time = unix_secs;
^
__________________________ ____
Log Format:
unix_secs,unix_nsecs,sysup time,exadd r,dpkts,do ctets,firs t,last,eng ine_type,
engine_id,srcaddr,dstaddr, nexthop,in put,output ,srcport,d stport,pro t,tos,
tcp_flags,src_mask,dst_mas k,src_as,d st_as
__________________________ ____
Log Example:
1178470834,244875642,22563 1412,192.1 68.0.127,1 ,61,225488 228,225488 228,0,0,66 .103.41.16 3,217.29.2 2.207,217. 29.16.2,1, 3,0,2048,1 ,0,16,19,2 4,9198,0
1178470892,797093178,22568 9968,192.1 68.0.127,4 7399,24652 64,2253710 56,2256885 00,0,0,77. 179.133.87 ,217.29.22 .205,217.2 9.16.2,1,3 ,62475,20, 6,0,19,13, 24,9198,0
1178470929,36298782,225726 208,192.16 8.0.127,2, 122,225570 316,225572 588,0,0,66 .103.41.16 3,217.29.2 2.198,217. 29.16.2,1, 3,0,2048,1 ,0,16,19,2 4,9198,0
1178470939,376155474,22573 6548,192.1 68.0.127,2 ,96,225552 332,225555 348,0,0,21 2.112.101. 58,217.29. 22.62,217. 29.16.2,11 ,3,2192,16 384,6,0,2, 20,24,6550 0,0
1178470954,436043124,22575 1608,192.1 68.0.127,7 2815,10863 5152,22537 0876,22568 8500,0,0,2 17.29.22.2 05,77.179. 133.87,212 .154.217.6 1,3,1,20,6 2475,6,0,2 7,24,13,0, 9198
1178470954,436043124,22575 1608,192.1 68.0.127,5 ,238,22568 8500,22568 8716,0,0,2 17.29.22.2 05,77.179. 133.87,212 .154.217.6 1,3,1,21,6 2473,6,0,2 5,24,13,0, 9198
1178470954,436043124,22575 1608,192.1 68.0.127,3 ,126,22568 8704,22568 8888,0,0,7 7.179.133. 87,217.29. 22.205,217 .29.16.2,1 ,3,62473,2 1,6,0,29,1 3,24,9198, 0
1178470957,448020654,22575 4620,192.1 68.0.127,5 ,1832,2256 92040,2256 92412,0,0, 217.29.22. 205,77.179 .133.87,21 2.154.217. 61,3,1,20, 62477,6,0, 27,24,13,0 ,9198
1178470957,448020654,22575 4620,192.1 68.0.127,3 ,168,22569 2220,22569 2408,0,0,7 7.179.133. 87,217.29. 22.205,217 .29.16.2,1 ,3,62477,2 0,6,0,19,1 3,24,9198, 0
1178470964,475988568,22576 1648,192.1 68.0.127,7 2973,10886 9448,22521 4092,22574 5328,0,0,2 17.29.22.2 05,77.179. 133.87,212 .154.217.6 1,3,1,20,6 2472,6,0,2 7,24,13,0, 9198
1178470964,475988568,22576 1648,192.1 68.0.127,4 9027,26045 52,2252142 72,2257453 28,0,0,77. 179.133.87 ,217.29.22 .205,217.2 9.16.2,1,3 ,62472,20, 6,0,19,13, 24,9198,0
1178470998,224002698,22579 5396,192.1 68.0.127,5 ,238,22574 5328,22574 5540,0,0,2 17.29.22.2 05,77.179. 133.87,212 .154.217.6 1,3,1,21,6 2470,6,0,2 5,24,13,0, 9198
1178470998,224002698,22579 5396,192.1 68.0.127,4 ,166,22574 5532,22574 5716,0,0,7 7.179.133. 87,217.29. 22.205,217 .29.16.2,1 ,3,62470,2 1,6,0,29,1 3,24,9198, 0
1178471001,236010744,22579 8408,192.1 68.0.127,5 ,1832,2257 48872,2257 49240,0,0, 217.29.22. 205,77.179 .133.87,21 2.154.217. 61,3,1,20, 62480,6,0, 27,24,13,0 ,9198
1178471001,236010744,22579 8408,192.1 68.0.127,3 ,168,22574 9056,22574 9240,0,0,7 7.179.133. 87,217.29. 22.205,217 .29.16.2,1 ,3,62480,2 0,6,0,19,1 3,24,9198, 0
Plz help find some soft or script to analyze this logs !!!
p.s. can give full log and sorry for english
Need advice, to solve problem with netflow log analyze !!!
Have some logs from Cisco netflow, but didn't find programs to analyze it:
SawMill 7.2.10 (Windows) gives some error:
Profile Summary
Profile: Untitled
Database: LogAnalysisInfo\Databases\
Last modified: -
Last operation: -
Log data format: Cisco NetFlow (flow-export)
Earliest log entry: -
Latest log entry: -
__________________________
Sawmill Alert
Syntax error: Unknown variable 'unix_secs' in expression while processing :0
Error occurred while parsing at the following location:
--------------------------
date_time = unix_secs;
^
__________________________
Log Format:
unix_secs,unix_nsecs,sysup
engine_id,srcaddr,dstaddr,
tcp_flags,src_mask,dst_mas
__________________________
Log Example:
1178470834,244875642,22563
1178470892,797093178,22568
1178470929,36298782,225726
1178470939,376155474,22573
1178470954,436043124,22575
1178470954,436043124,22575
1178470954,436043124,22575
1178470957,448020654,22575
1178470957,448020654,22575
1178470964,475988568,22576
1178470964,475988568,22576
1178470998,224002698,22579
1178470998,224002698,22579
1178471001,236010744,22579
1178471001,236010744,22579
Plz help find some soft or script to analyze this logs !!!
p.s. can give full log and sorry for english
ASKER
ManageEngine NetFlow Analyzer - This soft is very poverfully, but I don't have Cisco devices. Just Log in TXT format !!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
Hi there,
try netflow analyzer from manageengine : http://manageengine.adventnet.com/products/netflow/index.html
you can use its full functionality for 30 days.
regards,