API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 25th, 2012
48
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 13.61 KB | None | 0 0
raw download clone embed print report
  1. SELECT from_unixtime(stime), saddr, sport, dir, daddr, dport, sbytes, dbytes FROM argus.argus2012K17 WHERE dir='?>' OR dir='<?' LIMIT 50;
  2.  
  3.  
  4. '2012-05-16 19:01:07', '74.85.246.22', '993', '?>', '192.168.100.21', '58537', 60, 0
  5. '2012-05-16 19:01:09', '74.85.246.22', '993', '?>', '192.168.100.24', '2016', 60, 0
  6. '2012-05-16 19:01:27', '192.168.100.21', '55851', '?>', '157.55.235.155', '443', 60, 0
  7. '2012-05-16 19:03:31', '192.168.100.21', '55851', '?>', '157.55.235.155', '443', 60, 0
  8. '2012-05-16 19:05:31', '74.85.246.22', '993', '?>', '192.168.100.24', '2106', 60, 0
  9. '2012-05-16 19:07:07', '74.85.246.22', '993', '?>', '192.168.100.23', '54889', 60, 0
  10. '2012-05-16 19:11:26', '74.85.246.22', '993', '?>', '192.168.100.21', '58727', 60, 0
  11. '2012-05-16 19:11:35', '74.85.246.22', '993', '?>', '192.168.100.24', '2270', 60, 0
  12. '2012-05-16 19:11:59', '192.168.100.21', '58748', '?>', '212.243.210.201', '80', 60, 0
  13. '2012-05-16 19:12:48', '2.19.66.110', '8616', '?>', '192.168.100.23', '55016', 60, 0
  14. '2012-05-16 19:12:50', '2.19.66.110', '8618', '?>', '192.168.100.23', '55039', 60, 0
  15. '2012-05-16 19:14:01', '192.168.100.21', '55851', '?>', '157.55.235.155', '443', 60, 0
  16. '2012-05-16 19:14:27', '2.19.66.110', '8632', '?>', '192.168.100.23', '55068', 60, 0
  17. '2012-05-16 19:17:28', '74.85.246.22', '993', '?>', '192.168.100.23', '55085', 60, 0
  18. '2012-05-16 19:19:35', '192.168.100.23', '55153', '?>', '212.243.210.153', '80', 60, 0
  19. '2012-05-16 19:20:27', '74.85.246.22', '993', '?>', '192.168.100.21', '58765', 60, 0
  20. '2012-05-16 19:21:08', '74.85.246.22', '993', '?>', '192.168.100.24', '2417', 60, 0
  21. '2012-05-16 19:21:24', '74.85.246.22', '993', '?>', '192.168.100.21', '58772', 60, 0
  22. '2012-05-16 19:25:55', '192.168.100.21', '55851', '?>', '157.55.235.155', '443', 60, 0
  23. '2012-05-16 19:30:16', '74.85.246.22', '443', '<?', '192.168.100.25', '1606', 0, 60
  24. '2012-05-16 19:30:17', '74.85.246.22', '443', '<?', '192.168.100.25', '1616', 0, 60
  25. '2012-05-16 19:30:17', '192.168.100.25', '1610', '?>', '74.85.246.22', '443', 60, 0
  26. '2012-05-16 19:30:17', '74.85.246.22', '443', '<?', '192.168.100.25', '1612', 0, 60
  27. '2012-05-16 19:30:17', '192.168.100.25', '1613', '?>', '74.85.246.22', '443', 60, 0
  28. '2012-05-16 19:30:17', '74.85.246.22', '443', '<?', '192.168.100.25', '1614', 0, 60
  29. '2012-05-16 19:30:17', '192.168.100.25', '1617', '?>', '74.85.246.22', '443', 60, 0
  30. '2012-05-16 19:30:17', '74.85.246.22', '443', '<?', '192.168.100.25', '1618', 0, 60
  31. '2012-05-16 19:30:22', '192.168.100.25', '1645', '?>', '74.85.246.22', '443', 60, 0
  32. '2012-05-16 19:30:22', '74.85.246.22', '443', '<?', '192.168.100.25', '1646', 0, 60
  33. '2012-05-16 19:30:25', '74.85.246.22', '993', '?>', '192.168.100.23', '55293', 60, 0
  34. '2012-05-16 19:30:46', '74.85.246.22', '993', '?>', '192.168.100.23', '55352', 60, 0
  35. '2012-05-16 19:30:48', '74.85.246.22', '993', '?>', '192.168.100.24', '2774', 60, 0
  36. '2012-05-16 19:31:31', '74.85.246.22', '993', '?>', '192.168.100.21', '58990', 60, 0
  37. '2012-05-16 19:32:51', '192.168.100.25', '1120', '?>', '12.179.134.24', '443', 60, 0
  38. '2012-05-16 19:33:29', '192.168.100.25', '1604', '?>', '2.19.73.83', '443', 273, 0
  39. '2012-05-16 19:33:29', '192.168.100.25', '1600', '?>', '2.19.73.83', '443', 273, 0
  40. '2012-05-16 19:33:29', '192.168.100.25', '1601', '?>', '2.19.73.83', '443', 333, 0
  41. '2012-05-16 19:33:29', '192.168.100.25', '1059', '?>', '2.19.73.83', '443', 273, 0
  42. '2012-05-16 19:33:29', '192.168.100.25', '1619', '?>', '2.19.73.83', '443', 273, 0
  43. '2012-05-16 19:33:34', '192.168.100.25', '1604', '?>', '2.19.73.83', '443', 60, 0
  44. '2012-05-16 19:33:34', '192.168.100.25', '1619', '?>', '2.19.73.83', '443', 60, 0
  45. '2012-05-16 19:33:34', '192.168.100.25', '1600', '?>', '2.19.73.83', '443', 60, 0
  46. '2012-05-16 19:33:34', '192.168.100.25', '1059', '?>', '2.19.73.83', '443', 60, 0
  47. '2012-05-16 19:37:18', '74.85.246.22', '993', '?>', '192.168.100.23', '55433', 60, 0
  48. '2012-05-16 19:38:29', '2.19.66.110', '8809', '?>', '192.168.100.24', '2991', 60, 0
  49. '2012-05-16 19:41:03', '192.168.100.24', '3071', '?>', '212.243.210.93', '80', 60, 0
  50. '2012-05-16 19:41:23', '74.85.246.22', '993', '?>', '192.168.100.24', '3001', 60, 0
  51. '2012-05-16 19:41:25', '74.85.246.22', '993', '?>', '192.168.100.23', '55448', 60, 0
  52. '2012-05-16 19:42:05', '74.85.246.22', '993', '?>', '192.168.100.21', '59069', 60, 0
  53. '2012-05-16 19:47:36', '74.85.246.22', '993', '?>', '192.168.100.23', '55586', 60, 0
  54.  
  55.  
  56.  
  57.  
  58.  
  59.  
  60. SELECT from_unixtime(stime), saddr, sport, dir, daddr, dport, sbytes, dbytes FROM argus.argus2012K17 WHERE (stime BETWEEN unix_timestamp('2012-05-16 19:21:00') AND unix_timestamp('2012-05-16 19:45:00')) AND saddr='74.85.246.22' LIMIT 50;
  61.  
  62. '2012-05-16 19:21:05', '74.85.246.22', '443', '<?>', '192.168.100.25', '1618', 621, 180
  63. '2012-05-16 19:21:08', '74.85.246.22', '993', '?>', '192.168.100.24', '2417', 60, 0
  64. '2012-05-16 19:21:12', '74.85.246.22', '443', '<?>', '192.168.100.25', '1618', 5302, 360
  65. '2012-05-16 19:21:18', '74.85.246.22', '443', '<?>', '192.168.100.25', '1618', 526, 180
  66. '2012-05-16 19:21:23', '74.85.246.22', '443', '<?>', '192.168.100.25', '1612', 99, 60
  67. '2012-05-16 19:21:24', '74.85.246.22', '993', '?>', '192.168.100.21', '58772', 60, 0
  68. '2012-05-16 19:21:25', '74.85.246.22', '443', '<?>', '192.168.100.25', '1614', 99, 60
  69. '2012-05-16 19:21:27', '74.85.246.22', '443', '<?>', '192.168.100.25', '1618', 1547, 300
  70. '2012-05-16 19:21:30', '74.85.246.22', '443', '<?>', '192.168.100.25', '1616', 99, 60
  71. '2012-05-16 19:21:53', '74.85.246.22', '443', '<?>', '192.168.100.25', '1646', 99, 60
  72. '2012-05-16 19:21:57', '74.85.246.22', '443', '<?>', '192.168.100.25', '1606', 99, 60
  73. '2012-05-16 19:22:01', '74.85.246.22', '443', '<?>', '192.168.100.25', '1616', 143, 60
  74. '2012-05-16 19:22:23', '74.85.246.22', '443', '<?>', '192.168.100.25', '1612', 99, 60
  75. '2012-05-16 19:22:25', '74.85.246.22', '443', '<?>', '192.168.100.25', '1614', 99, 60
  76. '2012-05-16 19:22:32', '74.85.246.22', '443', '<?>', '192.168.100.25', '1618', 99, 60
  77. '2012-05-16 19:22:35', '74.85.246.22', '443', '<?>', '192.168.100.25', '1616', 3512, 480
  78. '2012-05-16 19:22:37', '74.85.246.22', '443', '<?>', '192.168.100.25', '1618', 669, 180
  79. '2012-05-16 19:22:42', '74.85.246.22', '443', '<?>', '192.168.100.25', '1606', 143, 60
  80. '2012-05-16 19:22:53', '74.85.246.22', '443', '<?>', '192.168.100.25', '1646', 99, 60
  81. '2012-05-16 19:22:55', '74.85.246.22', '443', '<?>', '192.168.100.25', '1618', 3894, 600
  82. '2012-05-16 19:23:23', '74.85.246.22', '443', '<?>', '192.168.100.25', '1612', 99, 60
  83. '2012-05-16 19:23:25', '74.85.246.22', '443', '<?>', '192.168.100.25', '1614', 99, 60
  84. '2012-05-16 19:23:29', '74.85.246.22', '443', '<?>', '192.168.100.25', '1616', 99, 60
  85. '2012-05-16 19:23:32', '74.85.246.22', '443', '<?>', '192.168.100.25', '1618', 99, 60
  86. '2012-05-16 19:23:53', '74.85.246.22', '443', '<?>', '192.168.100.25', '1646', 99, 60
  87. '2012-05-16 19:23:57', '74.85.246.22', '443', '<?>', '192.168.100.25', '1606', 99, 60
  88. '2012-05-16 19:24:22', '74.85.246.22', '443', '<?>', '192.168.100.25', '1612', 99, 60
  89. '2012-05-16 19:24:25', '74.85.246.22', '443', '<?>', '192.168.100.25', '1614', 99, 60
  90. '2012-05-16 19:24:30', '74.85.246.22', '443', '<?>', '192.168.100.25', '1616', 1023, 300
  91. '2012-05-16 19:24:32', '74.85.246.22', '443', '<?>', '192.168.100.25', '1618', 720, 240
  92. '2012-05-16 19:24:53', '74.85.246.22', '443', '<?>', '192.168.100.25', '1646', 99, 60
  93. '2012-05-16 19:24:57', '74.85.246.22', '443', '<?>', '192.168.100.25', '1606', 99, 60
  94. '2012-05-16 19:25:23', '74.85.246.22', '443', '<?>', '192.168.100.25', '1612', 99, 60
  95. '2012-05-16 19:25:25', '74.85.246.22', '443', '<?>', '192.168.100.25', '1614', 99, 60
  96. '2012-05-16 19:25:30', '74.85.246.22', '443', '<?>', '192.168.100.25', '1616', 99, 60
  97. '2012-05-16 19:25:32', '74.85.246.22', '443', '<?>', '192.168.100.25', '1618', 99, 60
  98. '2012-05-16 19:25:53', '74.85.246.22', '443', '<?>', '192.168.100.25', '1646', 99, 60
  99. '2012-05-16 19:25:56', '74.85.246.22', '443', '<?>', '192.168.100.25', '1606', 99, 60
  100. '2012-05-16 19:26:23', '74.85.246.22', '443', '<?>', '192.168.100.25', '1612', 99, 60
  101. '2012-05-16 19:26:25', '74.85.246.22', '443', '<?>', '192.168.100.25', '1614', 99, 60
  102. '2012-05-16 19:26:30', '74.85.246.22', '443', '<?>', '192.168.100.25', '1616', 99, 60
  103. '2012-05-16 19:26:32', '74.85.246.22', '443', '<?>', '192.168.100.25', '1618', 99, 60
  104. '2012-05-16 19:26:53', '74.85.246.22', '443', '<?>', '192.168.100.25', '1646', 99, 60
  105. '2012-05-16 19:26:57', '74.85.246.22', '443', '<?>', '192.168.100.25', '1606', 99, 60
  106. '2012-05-16 19:27:23', '74.85.246.22', '443', '<?>', '192.168.100.25', '1612', 99, 60
  107. '2012-05-16 19:27:25', '74.85.246.22', '443', '<?>', '192.168.100.25', '1614', 99, 60
  108. '2012-05-16 19:27:30', '74.85.246.22', '443', '<?>', '192.168.100.25', '1616', 99, 60
  109. '2012-05-16 19:27:32', '74.85.246.22', '443', '<?>', '192.168.100.25', '1618', 99, 60
  110. '2012-05-16 19:27:53', '74.85.246.22', '443', '<?>', '192.168.100.25', '1646', 99, 60
  111. '2012-05-16 19:27:57', '74.85.246.22', '443', '<?>', '192.168.100.25', '1606', 99, 60
  112.  
  113.  
  114.  
  115. SELECT from_unixtime(stime), saddr, sport, dir, daddr, dport, sbytes, dbytes FROM argus.argus2012K17 WHERE (stime BETWEEN unix_timestamp('2012-05-16 00:00:00') AND unix_timestamp('2012-05-16 19:45:00')) AND (saddr='74.85.246.22' AND daddr='192.168.100.21') OR (saddr='192.168.100.21' AND daddr='74.85.246.22') LIMIT 50;
  116.  
  117.  
  118.  
  119. '2012-05-16 19:01:07', '74.85.246.22', '993', '?>', '192.168.100.21', '58537', 60, 0
  120. '2012-05-16 19:08:58', '192.168.100.21', '58727', '->', '74.85.246.22', '993', 3859, 78780
  121. '2012-05-16 19:09:03', '192.168.100.21', '58727', '->', '74.85.246.22', '993', 5880, 208315
  122. '2012-05-16 19:09:08', '192.168.100.21', '58727', '->', '74.85.246.22', '993', 6240, 207354
  123. '2012-05-16 19:09:13', '192.168.100.21', '58727', '->', '74.85.246.22', '993', 2588, 87288
  124. '2012-05-16 19:11:26', '74.85.246.22', '993', '?>', '192.168.100.21', '58727', 60, 0
  125. '2012-05-16 19:17:54', '192.168.100.21', '58765', '->', '74.85.246.22', '993', 2719, 7136
  126. '2012-05-16 19:17:59', '192.168.100.21', '58765', '->', '74.85.246.22', '993', 2144, 2255
  127. '2012-05-16 19:18:04', '192.168.100.21', '58765', '->', '74.85.246.22', '993', 252, 187
  128. '2012-05-16 19:18:58', '192.168.100.21', '58772', '->', '74.85.246.22', '993', 4099, 86806
  129. '2012-05-16 19:19:03', '192.168.100.21', '58772', '->', '74.85.246.22', '993', 6660, 212582
  130. '2012-05-16 19:19:08', '192.168.100.21', '58772', '->', '74.85.246.22', '993', 6720, 200506
  131. '2012-05-16 19:19:13', '192.168.100.21', '58772', '->', '74.85.246.22', '993', 2528, 83580
  132. '2012-05-16 19:20:27', '74.85.246.22', '993', '?>', '192.168.100.21', '58765', 60, 0
  133. '2012-05-16 19:21:24', '74.85.246.22', '993', '?>', '192.168.100.21', '58772', 60, 0
  134. '2012-05-16 19:28:58', '192.168.100.21', '58990', '->', '74.85.246.22', '993', 4279, 89196
  135. '2012-05-16 19:29:03', '192.168.100.21', '58990', '->', '74.85.246.22', '993', 5100, 190213
  136. '2012-05-16 19:29:08', '192.168.100.21', '58990', '->', '74.85.246.22', '993', 6060, 199672
  137. '2012-05-16 19:29:13', '192.168.100.21', '58990', '->', '74.85.246.22', '993', 4224, 110890
  138. '2012-05-16 19:31:31', '74.85.246.22', '993', '?>', '192.168.100.21', '58990', 60, 0
  139. '2012-05-16 19:33:02', '192.168.100.21', '59025', '->', '74.85.246.22', '587', 1436, 1498
  140. '2012-05-16 19:38:58', '192.168.100.21', '59069', '->', '74.85.246.22', '993', 3859, 64892
  141. '2012-05-16 19:39:03', '192.168.100.21', '59069', '->', '74.85.246.22', '993', 5580, 158760
  142. '2012-05-16 19:39:08', '192.168.100.21', '59069', '->', '74.85.246.22', '993', 6180, 179399
  143. '2012-05-16 19:39:13', '192.168.100.21', '59069', '->', '74.85.246.22', '993', 5160, 146990
  144. '2012-05-16 19:39:18', '192.168.100.21', '59069', '->', '74.85.246.22', '993', 1328, 34361
  145. '2012-05-16 19:42:05', '74.85.246.22', '993', '?>', '192.168.100.21', '59069', 60, 0
  146. '2012-05-16 19:48:58', '192.168.100.21', '59134', '->', '74.85.246.22', '993', 2539, 24235
  147. '2012-05-16 19:49:03', '192.168.100.21', '59134', '->', '74.85.246.22', '993', 4560, 132081
  148. '2012-05-16 19:49:08', '192.168.100.21', '59134', '->', '74.85.246.22', '993', 4680, 136105
  149. '2012-05-16 19:49:13', '192.168.100.21', '59134', '->', '74.85.246.22', '993', 5100, 159208
  150. '2012-05-16 19:49:18', '192.168.100.21', '59134', '->', '74.85.246.22', '993', 4748, 131814
  151. '2012-05-16 19:58:58', '192.168.100.21', '59332', '->', '74.85.246.22', '993', 1411, 6091
  152. '2012-05-16 19:59:08', '192.168.100.21', '59332', '->', '74.85.246.22', '993', 3288, 82569
  153. '2012-05-16 19:59:13', '192.168.100.21', '59332', '->', '74.85.246.22', '993', 3660, 103023
  154. '2012-05-16 19:59:18', '192.168.100.21', '59332', '->', '74.85.246.22', '993', 5580, 170788
  155. '2012-05-16 19:59:23', '192.168.100.21', '59332', '->', '74.85.246.22', '993', 4740, 142760
  156. '2012-05-16 19:59:28', '192.168.100.21', '59332', '->', '74.85.246.22', '993', 3916, 88128
  157. '2012-05-16 19:59:33', '192.168.100.21', '59332', '->', '74.85.246.22', '993', 188, 230
  158. '2012-05-16 20:03:23', '192.168.100.21', '59372', '->', '74.85.246.22', '993', 2427, 6854
  159. '2012-05-16 20:03:28', '192.168.100.21', '59372', '->', '74.85.246.22', '993', 2308, 2239
  160. '2012-05-16 20:03:33', '192.168.100.21', '59372', '->', '74.85.246.22', '993', 620, 545
  161. '2012-05-16 20:07:17', '192.168.100.21', '59390', '->', '74.85.246.22', '993', 4099, 84065
  162. '2012-05-16 20:07:22', '192.168.100.21', '59390', '->', '74.85.246.22', '993', 5880, 207109
  163. '2012-05-16 20:07:27', '192.168.100.21', '59390', '->', '74.85.246.22', '993', 4860, 192412
  164. '2012-05-16 20:07:32', '192.168.100.21', '59390', '->', '74.85.246.22', '993', 2688, 95351
  165. '2012-05-16 20:08:57', '192.168.100.21', '59390', '<?>', '74.85.246.22', '993', 648, 567
  166. '2012-05-16 20:18:57', '192.168.100.21', '59566', '->', '74.85.246.22', '993', 4099, 85403
  167. '2012-05-16 20:19:03', '192.168.100.21', '59566', '->', '74.85.246.22', '993', 6180, 209744
  168. '2012-05-16 20:19:08', '192.168.100.21', '59566', '->', '74.85.246.22', '993', 7020, 206746
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!