SGNET Query Results

Query summary

Selected options: date, environment, code_injection

Grouped options: date, path

Rate threshold: 3

---

SELECT count(distinct(source.source_id)) AS nbs, floor((cast(tiny_session.begin_at as date)-to_date('19-MAR-8'))/1) AS Date_, path.name AS Path FROM source,tiny_session,large_session,environment,scriptgen_session,injection_attack,path WHERE tiny_session.source_id=source.source_id AND tiny_session.begin_at>to_date('19-MAR-8') AND tiny_session.begin_at<to_date('31-MAR-8') AND large_session.source_id=source.source_id AND large_session.environment_id=environment.environment_id AND (large_session.environment_id='15') AND scriptgen_session.tiny_session_id=tiny_session.tiny_session_id AND injection_attack.session_id=scriptgen_session.session_id AND scriptgen_session.type='SG' AND scriptgen_session.path_id=path.path_id GROUP BY floor((cast(tiny_session.begin_at as date)-to_date('19-MAR-8'))/1), path.name ORDER BY floor((cast(tiny_session.begin_at as date)-to_date('19-MAR-8'))/1), count(distinct(source.source_id)) DESC

20,Mar-2008 -> 21,Mar-2008(0)

Path	Number of sources
win2krich:135T:473:21	3
Others

21,Mar-2008 -> 22,Mar-2008(1)

Path	Number of sources
win2krich:135T:473:21	11
Others	1

22,Mar-2008 -> 23,Mar-2008(2)

Path	Number of sources
win2krich:135T:473:21	7
Others

23,Mar-2008 -> 24,Mar-2008(3)

Path	Number of sources
win2krich:135T:473:21	10
win2krich:135T:1050:16	39
Others

24,Mar-2008 -> 25,Mar-2008(4)

Path	Number of sources
win2krich:135T:473:21	6
win2krich:135T:1050:16	68
Others

25,Mar-2008 -> 26,Mar-2008(5)

Path	Number of sources
win2krich:135T:473:21	5
win2krich:135T:1050:16	89
win2krich:135T:460:1	3
Others

26,Mar-2008 -> 27,Mar-2008(6)

Path	Number of sources
win2krich:135T:473:21	6
win2krich:135T:1050:16	48
win2krich:135T:460:1	1
Others

27,Mar-2008 -> 28,Mar-2008(7)

Path	Number of sources
win2krich:135T:473:21	7
win2krich:135T:1050:16	22
win2krich:135T:460:1	2
Others

28,Mar-2008 -> 29,Mar-2008(8)

Path	Number of sources
win2krich:135T:473:21	3
win2krich:135T:1050:16	15
win2krich:135T:460:1	1
Others

29,Mar-2008 -> 30,Mar-2008(9)

Path	Number of sources
win2krich:135T:473:21	5
win2krich:135T:1050:16	1
Others

30,Mar-2008 -> 31,Mar-2008(10)

Path	Number of sources
win2krich:135T:473:21	17
win2krich:135T:460:1	1
Others

31,Mar-2008 -> (11)

Path	Number of sources
win2krich:135T:473:21	1
Others	1