Just released version 1.2.0 which includes Login_First, and Login_Last. (Unfortunately, the query is now even more Oracle specific, which was until now, iiuc, not so hard to change.) This allows querying age, though without much granularity. (The queries used are in the script. NodeReaper "never" first logged in, but last logged in 110 years ago. So, it gets a NULL.)
Years logged in:
YEARS AMOUNT
----- ----------
0 1
1 4
2 8
3 16
4 29
5 38
6 45
7 40
8 61
9 65
10 42
11 45
12 70
13 57
14 70
15 68
16 34
1
Years logged in be level
MONK_LEVEL YEARS AMOUNT
---------- ---------- ----------
13 1 2
13 2 5
13 3 7
13 4 9
13 5 12
13 6 19
13 7 14
13 8 24
13 9 22
13 10 14
13 11 11
13 12 19
13 13 10
13 14 10
13 15 20
13 16 6
13 1
14 1 1
14 2 3
14 3 6
14 4 6
14 5 14
14 6 12
14 7 5
14 8 11
14 9 12
14 10 10
14 11 10
14 12 19
14 13 9
14 14 12
14 15 14
14 16 1
15 1 1
15 3 1
15 4 1
15 5 4
15 6 3
15 7 7
15 8 4
15 9 9
15 10 5
15 11 3
15 12 10
15 13 7
15 14 13
15 15 8
15 16 4
16 0 1
16 3 1
16 4 4
16 5 3
16 6 5
16 7 6
16 8 8
16 9 8
16 10 1
16 11 3
16 12 6
16 13 12
16 14 7
16 15 7
16 16 5
17 3 1
17 5 3
17 6 2
17 7 2
17 8 5
17 9 1
17 10 2
17 11 6
17 12 4
17 13 7
17 14 5
17 15 4
17 16 2
18 4 2
18 5 1
18 6 1
18 7 5
18 8 3
18 9 3
18 10 2
18 11 3
18 12 3
18 13 5
18 14 5
18 15 6
18 16 3
19 4 1
19 5 1
19 6 1
19 8 4
19 9 3
19 10 2
19 11 6
19 12 3
19 13 3
19 14 5
19 15 2
19 16 3
20 4 5
20 6 1
20 9 4
20 10 3
20 11 1
20 12 1
20 13 1
20 14 6
20 15 3
20 16 1
21 4 1
21 6 1
21 8 1
21 10 3
21 11 1
21 12 2
21 13 1
21 14 3
21 15 3
21 16 2
22 7 1
22 9 2
22 12 2
22 13 1
22 14 1
22 16 1
23 8 1
23 13 1
23 14 2
23 15 1
23 16 1
24 9 1
24 16 1
25 11 1
25 16 2
28 12 1
28 14 1
28 16 2
(Oops. Forgot in ORDER BY in that second query. Added it for this run. I'll have to add that to the script with the next update.)
Anyway, a lot of the monks have been here quite some time. Just more food for though when working out efficiencies.
