select * from tcpflow where packetTime

TCPFlow Definition and Ouput

Data Dictionary

TCPFlow - TCP Packet keyed with a session ID

packetTime: java.sql.timestamp - The time the packet was captured
sensorName: String - The configured name of the DNASensor that captured this session
interface: String - The name of the network interface this packet was captured on
session: String - The unique key that descibes the session of the packet
srcAddress: String - The IP address from which this packet originated
srcPort: Integer - The port from which this packet originated
dstAddress: String - The IP address to which this packet destined
dstPort: Integer - The port to which this packet is destined
PacketLen: Integer - The size in bytes of the packet
ProtocolName: String - Literal name of TCP
IPIdent: Integer - muted in current release
IPflags: Short - muted in current release
IPfragOffset: Integer- muted in current release
IPttl: Integer - The TTL in the packet
TCPSeq: Long - The TCP sequence number of the packets
TCPAck: Long - The TCP acknowlege number of the packet
tcpFlags: Longs - The tcp flags for this packet

TCPFlow Output

packetTime	sensorName	interface	sessionKey	srcAddr	srcPort	dstAddr	dstPort	pktLen	protoNam	ttl	tcpSeq	tcpAck	tcpFlags
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	192.168.56.103	58445	209.132.177.100	443	60	tcp	63	839068555	0	2
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58445	52	tcp	82	2512064304	839068556	18
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	192.168.56.103	58445	209.132.177.100	443	40	tcp	63	839068556	2512064305	16
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	192.168.56.103	58445	209.132.177.100	443	182	tcp	63	839068556	2512064305	24
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58445	40	tcp	82	2512064305	839068698	16
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58445	1255	tcp	82	2512064305	839068698	24
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	192.168.56.103	58445	209.132.177.100	443	40	tcp	63	839068698	2512065520	16
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	192.168.56.103	58445	209.132.177.100	443	238	tcp	63	839068698	2512065520	24
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58445	99	tcp	82	2512065520	839068896	24
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	192.168.56.103	58445	209.132.177.100	443	461	tcp	63	839068896	2512065579	24
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58445	40	tcp	82	2512065579	839069317	16
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	192.168.56.103	58445	209.132.177.100	443	189	tcp	63	839069317	2512065579	24
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58445	40	tcp	82	2512065579	839069466	16
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58445	1293	tcp	82	2512065579	839069466	24
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	192.168.56.103	58445	209.132.177.100	443	77	tcp	63	839069466	2512066832	24
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	192.168.56.103	58445	209.132.177.100	443	40	tcp	63	839069503	2512066832	17
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44effffffffd184b1641bb6	192.168.56.103	58446	209.132.177.100	443	60	tcp	63	846295901	0	2
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58445	77	tcp	82	2512066832	839069503	24
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	192.168.56.103	58445	209.132.177.100	443	40	tcp	63	839069503	0	4
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58445	40	tcp	82	2512066869	839069503	17
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	192.168.56.103	58445	209.132.177.100	443	40	tcp	63	839069503	0	4
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58445	40	tcp	82	2512066870	839069504	16
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	192.168.56.103	58445	209.132.177.100	443	40	tcp	63	839069504	0	4
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44effffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58446	52	tcp	82	2486435417	846295902	18
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44effffffffd184b1641bb6	192.168.56.103	58446	209.132.177.100	443	40	tcp	63	846295902	2486435418	16
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44effffffffd184b1641bb6	192.168.56.103	58446	209.132.177.100	443	182	tcp	63	846295902	2486435418	24
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58445	40	tcp	93	2512066869	839069504	16
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	192.168.56.103	58445	209.132.177.100	443	40	tcp	63	839069504	0	4
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58445	40	tcp	93	2512066869	839069504	16
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44dffffffffd184b1641bb6	192.168.56.103	58445	209.132.177.100	443	40	tcp	63	839069504	0	4
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44effffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58446	40	tcp	82	2486435418	846296044	16
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44effffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58446	1255	tcp	82	2486435418	846296044	24
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44effffffffd184b1641bb6	192.168.56.103	58446	209.132.177.100	443	40	tcp	63	846296044	2486436633	16
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44effffffffd184b1641bb6	192.168.56.103	58446	209.132.177.100	443	238	tcp	63	846296044	2486436633	24
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44effffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58446	99	tcp	82	2486436633	846296242	24
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44effffffffd184b1641bb6	192.168.56.103	58446	209.132.177.100	443	461	tcp	63	846296242	2486436692	24
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44effffffffd184b1641bb6	209.132.177.100	443	192.168.56.103	58446	40	tcp	82	2486436692	846296663	16
2005-12-29 06:19:48	home.lan	eth1	ffffffffc0a83867e44effffffffd184b1641bb6	192.168.56.103	58446	209.132.177.100	443	429	tcp	63	846296663	2486436692	24

packetTime

sensorName

interface

sessionKey

srcAddr

srcPort

dstAddr

dstPort

pktLen

protoNam

ident

flags

fragOffset

ttl

tcpSeq

tcpAck

tcpFlags

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

192.168.56.103

58445

209.132.177.100

443

tcp

839068555

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58445

tcp

2512064304

839068556

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

192.168.56.103

58445

209.132.177.100

443

tcp

839068556

2512064305

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

192.168.56.103

58445

209.132.177.100

443

182

tcp

839068556

2512064305

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58445

tcp

2512064305

839068698

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58445

1255

tcp

2512064305

839068698

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

192.168.56.103

58445

209.132.177.100

443

tcp

839068698

2512065520

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

192.168.56.103

58445

209.132.177.100

443

238

tcp

839068698

2512065520

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58445

tcp

2512065520

839068896

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

192.168.56.103

58445

209.132.177.100

443

461

tcp

839068896

2512065579

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58445

tcp

2512065579

839069317

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

192.168.56.103

58445

209.132.177.100

443

189

tcp

839069317

2512065579

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58445

tcp

2512065579

839069466

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58445

1293

tcp

2512065579

839069466

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

192.168.56.103

58445

209.132.177.100

443

tcp

839069466

2512066832

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

192.168.56.103

58445

209.132.177.100

443

tcp

839069503

2512066832

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44effffffffd184b1641bb6

192.168.56.103

58446

209.132.177.100

443

tcp

846295901

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58445

tcp

2512066832

839069503

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

192.168.56.103

58445

209.132.177.100

443

tcp

839069503

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58445

tcp

2512066869

839069503

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

192.168.56.103

58445

209.132.177.100

443

tcp

839069503

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58445

tcp

2512066870

839069504

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

192.168.56.103

58445

209.132.177.100

443

tcp

839069504

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44effffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58446

tcp

2486435417

846295902

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44effffffffd184b1641bb6

192.168.56.103

58446

209.132.177.100

443

tcp

846295902

2486435418

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44effffffffd184b1641bb6

192.168.56.103

58446

209.132.177.100

443

182

tcp

846295902

2486435418

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58445

tcp

2512066869

839069504

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

192.168.56.103

58445

209.132.177.100

443

tcp

839069504

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58445

tcp

2512066869

839069504

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44dffffffffd184b1641bb6

192.168.56.103

58445

209.132.177.100

443

tcp

839069504

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44effffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58446

tcp

2486435418

846296044

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44effffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58446

1255

tcp

2486435418

846296044

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44effffffffd184b1641bb6

192.168.56.103

58446

209.132.177.100

443

tcp

846296044

2486436633

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44effffffffd184b1641bb6

192.168.56.103

58446

209.132.177.100

443

238

tcp

846296044

2486436633

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44effffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58446

tcp

2486436633

846296242

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44effffffffd184b1641bb6

192.168.56.103

58446

209.132.177.100

443

461

tcp

846296242

2486436692

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44effffffffd184b1641bb6

209.132.177.100

443

192.168.56.103

58446

tcp

2486436692

846296663

2005-12-29 06:19:48

home.lan

eth1

ffffffffc0a83867e44effffffffd184b1641bb6

192.168.56.103

58446

209.132.177.100

443

429

tcp

846296663

2486436692