SGNET Query Results

Query summary

Selected options: date, code_injection

Grouped options: date, environment

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_, environment.nom AS Environment FROM source,tiny_session,scriptgen_session,injection_attack,large_session,environment 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 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 large_session.source_id=source.source_id AND large_session.environment_id=environment.environment_id GROUP BY floor((cast(tiny_session.begin_at as date)-to_date('19-MAR-8'))/1), environment.nom 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)

Environment	Number of sources
Environment 1	25
Environment 2	13
Environment 3	6
Environment 15	3
Environment 4	2
Others	2

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

Environment	Number of sources
Environment 1	18
Environment 2	16
Environment 3	4
Environment 15	12
Supelec	5
Environment 4	1
Others

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

Environment	Number of sources
Environment 1	32
Environment 2	16
Environment 3	2
Environment 15	7
Supelec	25
Environment 4	6
Others	1

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

Environment	Number of sources
Environment 1	32
Environment 2	21
Environment 15	49
Supelec	16
Environment 4	8
Others

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

Environment	Number of sources
Environment 1	22
Environment 2	11
Environment 15	74
Supelec	16
Environment 4	5
Others

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

Environment	Number of sources
Environment 1	18
Environment 2	15
Environment 15	97
Supelec	12
Environment 4	5
Others

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

Environment	Number of sources
Environment 1	13
Environment 2	10
Environment 3	2
Environment 15	55
Supelec	6
Environment 4	2
Others	1

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

Environment	Number of sources
Environment 1	10
Environment 2	11
Environment 3	4
Environment 15	31
Environment 4	2
Others

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

Environment	Number of sources
Environment 1	5
Environment 2	2
Environment 15	19
Others

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

Environment	Number of sources
Environment 1	6
Environment 2	7
Environment 15	6
Others	1

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

Environment	Number of sources
Environment 1	24
Environment 2	11
Environment 3	4
Environment 15	18
Environment 4	3
Others

31,Mar-2008 -> (11)

Environment	Number of sources
Environment 1	3
Environment 2	2
Environment 15	2
Environment 4	4
Others