Beacons all go away at one time

Posted on
Wed Aug 30, 2017 7:52 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Beacons all go away at one time

kind of, just select the 2 states: status and last status change
and with value = up and down for status
as in the screen shot

Posted on
Wed Aug 30, 2017 8:05 pm
Sharek326 offline
User avatar
Posts: 377
Joined: Jul 20, 2014
Location: Lansford, PA

Re: Beacons all go away at one time

Karle's Down

Aug 30, 2017, 10:03:47 PM
SQL-OUTPUT:
id strftime('%Y-%m-%d-%H:%M:%S',ts,'localtime') status laststatuschange
---------- -------------------------------------------- ---------- -------------------
112 2017-08-25-23:59:19 down 2017-08-25 23:59:19
619 2017-08-26-08:12:18 down 2017-08-26 08:12:18
1067 2017-08-26-19:35:47 down 2017-08-26 19:35:47
1072 2017-08-26-19:54:41 down 2017-08-26 19:54:41
1730 2017-08-27-06:53:00 down 2017-08-27 06:53:00
1766 2017-08-27-14:53:47 down 2017-08-27 14:53:47
1828 2017-08-27-16:26:35 down 2017-08-27 16:26:35
1830 2017-08-27-16:29:10 down 2017-08-27 16:29:10
1839 2017-08-27-16:38:27 down 2017-08-27 16:38:27
1841 2017-08-27-16:41:02 down 2017-08-27 16:41:02
1846 2017-08-27-16:51:44 down 2017-08-27 16:51:44
1852 2017-08-27-16:58:00 down 2017-08-27 16:58:00
1856 2017-08-27-17:02:26 down 2017-08-27 17:02:26
1870 2017-08-27-17:16:34 down 2017-08-27 17:16:34
1905 2017-08-27-17:52:32 down 2017-08-27 17:52:32
1918 2017-08-27-18:05:37 down 2017-08-27 18:05:37
1931 2017-08-27-18:20:55 down 2017-08-27 18:20:54
1934 2017-08-27-18:36:03 down 2017-08-27 18:36:03
1937 2017-08-27-18:46:35 down 2017-08-27 18:46:35
1939 2017-08-27-18:48:28 down 2017-08-27 18:48:28
1942 2017-08-27-18:52:53 down 2017-08-27 18:52:53
1944 2017-08-27-18:55:52 down 2017-08-27 18:55:52
1946 2017-08-27-18:57:37 down 2017-08-27 18:57:37
2001 2017-08-27-19:53:17 down 2017-08-27 19:53:17
2008 2017-08-27-20:01:20 down 2017-08-27 20:01:20
2012 2017-08-27-20:05:15 down 2017-08-27 20:05:15
2035 2017-08-27-20:28:35 down 2017-08-27 20:28:35
2037 2017-08-27-20:31:25 down 2017-08-27 20:31:25
2040 2017-08-27-20:37:35 down 2017-08-27 20:37:35
2044 2017-08-27-20:42:00 down 2017-08-27 20:42:00
2048 2017-08-27-20:45:34 down 2017-08-27 20:45:34
2164 2017-08-27-22:41:38 down 2017-08-27 22:41:38
2168 2017-08-27-22:46:08 down 2017-08-27 22:46:08
2173 2017-08-27-22:50:42 down 2017-08-27 22:50:42
2184 2017-08-27-23:02:27 down 2017-08-27 23:02:27
2186 2017-08-27-23:05:57 down 2017-08-27 23:05:26
2197 2017-08-27-23:16:13 down 2017-08-27 23:16:13
2206 2017-08-27-23:25:04 down 2017-08-27 23:25:04
2208 2017-08-27-23:26:58 down 2017-08-27 23:26:58
2625 2017-08-28-06:29:35 down 2017-08-28 06:29:35
2732 2017-08-28-08:17:30 down 2017-08-28 08:17:30
2745 2017-08-28-08:31:33 down 2017-08-28 08:31:33
2750 2017-08-28-08:36:08 down 2017-08-28 08:36:08
2830 2017-08-28-09:54:29 down 2017-08-28 09:54:28
2851 2017-08-28-10:14:29 down 2017-08-28 10:14:29
2982 2017-08-28-12:23:33 down 2017-08-28 12:23:33
2987 2017-08-29-00:45:48 down 2017-08-29 00:45:48
2992 2017-08-29-00:51:28 down 2017-08-29 00:51:28
3002 2017-08-29-01:01:50 down 2017-08-29 01:01:50
3575 2017-08-29-10:42:28 down 2017-08-29 10:42:28
3580 2017-08-29-10:47:14 down 2017-08-29 10:47:14
3592 2017-08-29-14:54:46 down 2017-08-29 14:54:45
3861 2017-08-29-19:24:33 down 2017-08-29 19:24:33
4667 2017-08-30-08:34:42 down 2017-08-30 08:34:42
4781 2017-08-30-10:28:01 down 2017-08-30 10:28:00
4959 2017-08-30-13:26:58 down 2017-08-30 13:26:58
4984 2017-08-30-18:38:04 down 2017-08-30 18:38:04
4994 2017-08-30-18:47:52 down 2017-08-30 18:47:52
4999 2017-08-30-18:52:43 down 2017-08-30 18:52:43
5005 2017-08-30-18:59:39 down 2017-08-30 18:59:39
5033 2017-08-30-19:28:38 down 2017-08-30 19:28:38
5050 2017-08-30-19:45:39 down 2017-08-30 19:45:39
5057 2017-08-30-19:52:50 down 2017-08-30 19:52:50
5064 2017-08-30-20:01:12 down 2017-08-30 20:01:12
5110 2017-08-30-20:46:38 down 2017-08-30 20:46:38
5116 2017-08-30-20:52:36 down 2017-08-30 20:52:35
5185 2017-08-30-22:00:23 down 2017-08-30 22:00:23


Aug 30, 2017, 10:05:18 PM
SQL-OUTPUT:
id strftime('%Y-%m-%d-%H:%M:%S',ts,'localtime') status laststatuschange
---------- -------------------------------------------- ---------- ----------------
2 2017-08-25-22:38:05 up
3 2017-08-25-22:38:05 up
4 2017-08-25-22:38:06 up 2017-08-25 22:38
5 2017-08-25-22:38:06 up 2017-08-25 22:38
6 2017-08-25-22:38:08 up 2017-08-25 22:38
7 2017-08-25-22:38:36 up 2017-08-25 22:38
8 2017-08-25-22:38:37 up 2017-08-25 22:38
9 2017-08-25-22:38:38 up 2017-08-25 22:38
10 2017-08-25-22:39:03 up 2017-08-25 22:38
11 2017-08-25-22:39:38 up 2017-08-25 22:38
12 2017-08-25-22:40:06 up 2017-08-25 22:38
13 2017-08-25-22:41:06 up 2017-08-25 22:38
14 2017-08-25-22:42:06 up 2017-08-25 22:38
15 2017-08-25-22:43:06 up 2017-08-25 22:38
16 2017-08-25-22:44:06 up 2017-08-25 22:38
17 2017-08-25-22:45:07 up 2017-08-25 22:38
18 2017-08-25-22:45:42 up 2017-08-25 22:38
19 2017-08-25-22:46:42 up 2017-08-25 22:38
20 2017-08-25-22:47:16 up 2017-08-25 22:38
21 2017-08-25-22:48:17 up 2017-08-25 22:38
22 2017-08-25-22:48:33 up 2017-08-25 22:38
23 2017-08-25-22:48:42 up 2017-08-25 22:38
24 2017-08-25-22:49:20 up 2017-08-25 22:38
25 2017-08-25-22:49:37 up 2017-08-25 22:38
26 2017-08-25-22:50:21 up 2017-08-25 22:38
27 2017-08-25-22:51:06 up 2017-08-25 22:38
28 2017-08-25-22:51:52 up 2017-08-25 22:38
29 2017-08-25-22:52:52 up 2017-08-25 22:38
30 2017-08-25-22:53:44 up 2017-08-25 22:38
31 2017-08-25-22:54:44 up 2017-08-25 22:38
32 2017-08-25-22:55:27 up 2017-08-25 22:38
33 2017-08-25-22:56:25 up 2017-08-25 22:38
34 2017-08-25-22:56:29 up 2017-08-25 22:38
35 2017-08-25-22:57:15 up 2017-08-25 22:38
36 2017-08-25-22:57:59 up 2017-08-25 22:38
37 2017-08-25-22:58:47 up 2017-08-25 22:38
38 2017-08-25-22:59:36 up 2017-08-25 22:38
39 2017-08-25-23:00:28 up 2017-08-25 22:38
40 2017-08-25-23:01:14 up 2017-08-25 22:38
41 2017-08-25-23:02:14 up 2017-08-25 22:38
42 2017-08-25-23:03:33 up 2017-08-25 22:38
43 2017-08-25-23:04:15 up 2017-08-25 22:38
44 2017-08-25-23:04:37 up 2017-08-25 22:38
45 2017-08-25-23:05:37 up 2017-08-25 22:38
46 2017-08-25-23:06:37 up 2017-08-25 22:38
47 2017-08-25-23:07:37 up 2017-08-25 22:38
48 2017-08-25-23:07:44 up 2017-08-25 22:38
49 2017-08-25-23:08:44 up 2017-08-25 22:38
50 2017-08-25-23:09:44 up 2017-08-25 22:38
51 2017-08-25-23:10:23 up 2017-08-25 22:38
52 2017-08-25-23:10:23 up 2017-08-25 22:38
53 2017-08-25-23:11:00 up 2017-08-25 22:38
54 2017-08-25-23:11:44 up 2017-08-25 22:38
55 2017-08-25-23:12:31 up 2017-08-25 22:38
56 2017-08-25-23:13:24 up 2017-08-25 22:38
57 2017-08-25-23:14:25 up 2017-08-25 22:38
58 2017-08-25-23:15:25 up 2017-08-25 22:38
59 2017-08-25-23:16:10 up 2017-08-25 22:38
60 2017-08-25-23:16:12 up 2017-08-25 22:38
61 2017-08-25-23:17:00 up 2017-08-25 22:38
62 2017-08-25-23:18:04 up 2017-08-25 22:38
63 2017-08-25-23:18:58 up 2017-08-25 22:38
64 2017-08-25-23:19:37 up 2017-08-25 22:38
65 2017-08-25-23:20:37 up 2017-08-25 22:38
66 2017-08-25-23:21:05 up 2017-08-25 22:38
67 2017-08-25-23:21:37 up 2017-08-25 22:38
68 2017-08-25-23:22:37 up 2017-08-25 22:38
69 2017-08-25-23:23:38 up 2017-08-25 22:38
70 2017-08-25-23:24:38 up 2017-08-25 22:38
71 2017-08-25-23:25:38 up 2017-08-25 22:38
72 2017-08-25-23:26:38 up 2017-08-25 22:38
73 2017-08-25-23:27:38 up 2017-08-25 22:38
74 2017-08-25-23:28:39 up 2017-08-25 22:38
75 2017-08-25-23:29:39 up 2017-08-25 22:38
76 2017-08-25-23:29:51 up 2017-08-25 22:38
77 2017-08-25-23:30:40 up 2017-08-25 22:38
78 2017-08-25-23:31:39 up 2017-08-25 22:38
79 2017-08-25-23:32:30 up 2017-08-25 22:38
80 2017-08-25-23:33:26 up 2017-08-25 22:38
81 2017-08-25-23:34:18 up 2017-08-25 22:38
82 2017-08-25-23:34:37 up 2017-08-25 22:38
83 2017-08-25-23:35:19 up 2017-08-25 22:38
84 2017-08-25-23:36:07 up 2017-08-25 22:38
85 2017-08-25-23:36:57 up 2017-08-25 22:38
86 2017-08-25-23:37:52 up 2017-08-25 22:38
87 2017-08-25-23:38:15 up 2017-08-25 22:38
88 2017-08-25-23:39:15 up 2017-08-25 22:38
89 2017-08-25-23:40:02 up 2017-08-25 22:38
90 2017-08-25-23:41:03 up 2017-08-25 22:38
91 2017-08-25-23:41:44 up 2017-08-25 22:38
92 2017-08-25-23:42:31 up 2017-08-25 22:38
93 2017-08-25-23:43:31 up 2017-08-25 22:38
94 2017-08-25-23:44:14 up 2017-08-25 22:38
95 2017-08-25-23:45:00 up 2017-08-25 22:38
96 2017-08-25-23:45:42 up 2017-08-25 22:38
97 2017-08-25-23:46:33 up 2017-08-25 22:38
98 2017-08-25-23:47:34 up 2017-08-25 22:38
99 2017-08-25-23:48:34 up 2017-08-25 22:38
100 2017-08-25-23:48:42 up 2017-08-25 22:38
101 2017-08-25-23:49:25 up 2017-08-25 22:38

Posted on
Wed Aug 30, 2017 8:06 pm
Sharek326 offline
User avatar
Posts: 377
Joined: Jul 20, 2014
Location: Lansford, PA

Re: Beacons all go away at one time

Joes Beacon

Aug 30, 2017, 10:06:18 PM
SQL-OUTPUT:
id strftime('%Y-%m-%d-%H:%M:%S',ts,'localtime') status laststatuschange
---------- -------------------------------------------- ---------- ----------------
2 2017-08-25-22:38:05 up
3 2017-08-25-22:38:06 up
4 2017-08-25-22:38:06 up 2017-08-25 22:38
6 2017-08-25-22:38:38 up 2017-08-25 22:38
7 2017-08-25-22:39:03 up 2017-08-25 22:38
8 2017-08-25-22:39:38 up 2017-08-25 22:38
9 2017-08-25-22:40:06 up 2017-08-25 22:38
10 2017-08-25-22:41:06 up 2017-08-25 22:38
12 2017-08-25-22:43:06 up 2017-08-25 22:43
13 2017-08-25-22:44:06 up 2017-08-25 22:43
14 2017-08-25-22:45:07 up 2017-08-25 22:43
17 2017-08-25-22:48:17 up 2017-08-25 22:48
18 2017-08-25-22:48:33 up 2017-08-25 22:48
19 2017-08-25-22:48:42 up 2017-08-25 22:48
21 2017-08-25-22:49:37 up 2017-08-25 22:49
22 2017-08-25-22:50:21 up 2017-08-25 22:49
23 2017-08-25-22:51:06 up 2017-08-25 22:49
24 2017-08-25-22:51:52 up 2017-08-25 22:49
25 2017-08-25-22:52:52 up 2017-08-25 22:49
26 2017-08-25-22:53:44 up 2017-08-25 22:49
27 2017-08-25-22:54:44 up 2017-08-25 22:49
29 2017-08-25-22:56:29 up 2017-08-25 22:56
30 2017-08-25-22:57:15 up 2017-08-25 22:56
31 2017-08-25-22:57:59 up 2017-08-25 22:56
32 2017-08-25-22:58:47 up 2017-08-25 22:56
33 2017-08-25-22:59:35 up 2017-08-25 22:56
34 2017-08-25-23:00:28 up 2017-08-25 22:56
39 2017-08-25-23:04:37 up 2017-08-25 23:04
40 2017-08-25-23:05:37 up 2017-08-25 23:04
41 2017-08-25-23:06:37 up 2017-08-25 23:04
42 2017-08-25-23:07:37 up 2017-08-25 23:04
43 2017-08-25-23:07:44 up 2017-08-25 23:04
44 2017-08-25-23:08:44 up 2017-08-25 23:04
45 2017-08-25-23:09:44 up 2017-08-25 23:04
46 2017-08-25-23:10:23 up 2017-08-25 23:04
47 2017-08-25-23:11:00 up 2017-08-25 23:04
48 2017-08-25-23:11:44 up 2017-08-25 23:04
49 2017-08-25-23:12:31 up 2017-08-25 23:04
50 2017-08-25-23:13:24 up 2017-08-25 23:04
51 2017-08-25-23:14:25 up 2017-08-25 23:04
52 2017-08-25-23:15:25 up 2017-08-25 23:04
53 2017-08-25-23:16:10 up 2017-08-25 23:04
54 2017-08-25-23:16:59 up 2017-08-25 23:04
55 2017-08-25-23:18:02 up 2017-08-25 23:04
56 2017-08-25-23:18:58 up 2017-08-25 23:04
57 2017-08-25-23:19:37 up 2017-08-25 23:04
58 2017-08-25-23:20:37 up 2017-08-25 23:04
59 2017-08-25-23:21:22 up 2017-08-25 23:04
60 2017-08-25-23:21:37 up 2017-08-25 23:04
61 2017-08-25-23:22:37 up 2017-08-25 23:04
62 2017-08-25-23:23:38 up 2017-08-25 23:04
63 2017-08-25-23:24:38 up 2017-08-25 23:04
64 2017-08-25-23:25:38 up 2017-08-25 23:04
65 2017-08-25-23:26:38 up 2017-08-25 23:04
66 2017-08-25-23:27:39 up 2017-08-25 23:04
67 2017-08-25-23:28:39 up 2017-08-25 23:04
68 2017-08-25-23:29:39 up 2017-08-25 23:04
69 2017-08-25-23:29:51 up 2017-08-25 23:04
70 2017-08-25-23:30:39 up 2017-08-25 23:04
71 2017-08-25-23:31:39 up 2017-08-25 23:04
72 2017-08-25-23:32:30 up 2017-08-25 23:04
73 2017-08-25-23:33:26 up 2017-08-25 23:04
74 2017-08-25-23:34:18 up 2017-08-25 23:04
75 2017-08-25-23:34:37 up 2017-08-25 23:04
76 2017-08-25-23:35:19 up 2017-08-25 23:04
77 2017-08-25-23:36:07 up 2017-08-25 23:04
78 2017-08-25-23:36:57 up 2017-08-25 23:04
79 2017-08-25-23:37:52 up 2017-08-25 23:04
80 2017-08-25-23:38:15 up 2017-08-25 23:04
81 2017-08-25-23:39:15 up 2017-08-25 23:04
82 2017-08-25-23:40:02 up 2017-08-25 23:04
83 2017-08-25-23:41:03 up 2017-08-25 23:04
84 2017-08-25-23:41:44 up 2017-08-25 23:04
85 2017-08-25-23:42:30 up 2017-08-25 23:04
86 2017-08-25-23:43:31 up 2017-08-25 23:04
87 2017-08-25-23:44:14 up 2017-08-25 23:04
88 2017-08-25-23:45:00 up 2017-08-25 23:04
89 2017-08-25-23:45:42 up 2017-08-25 23:04
90 2017-08-25-23:46:33 up 2017-08-25 23:04
91 2017-08-25-23:47:34 up 2017-08-25 23:04
92 2017-08-25-23:48:34 up 2017-08-25 23:04
93 2017-08-25-23:48:42 up 2017-08-25 23:04
94 2017-08-25-23:49:25 up 2017-08-25 23:04
95 2017-08-25-23:49:37 up 2017-08-25 23:04
96 2017-08-25-23:50:23 up 2017-08-25 23:04
97 2017-08-25-23:51:23 up 2017-08-25 23:04
98 2017-08-25-23:52:13 up 2017-08-25 23:04
99 2017-08-25-23:53:13 up 2017-08-25 23:04
100 2017-08-25-23:54:02 up 2017-08-25 23:04
101 2017-08-25-23:54:53 up 2017-08-25 23:04
102 2017-08-25-23:55:44 up 2017-08-25 23:04
103 2017-08-25-23:56:44 up 2017-08-25 23:04
104 2017-08-25-23:57:44 up 2017-08-25 23:04
106 2017-08-25-23:59:29 up 2017-08-25 23:59
107 2017-08-26-00:00:29 up 2017-08-25 23:59
108 2017-08-26-00:01:30 up 2017-08-25 23:59
109 2017-08-26-00:02:26 up 2017-08-25 23:59
110 2017-08-26-00:03:08 up 2017-08-25 23:59
111 2017-08-26-00:04:04 up 2017-08-25 23:59
112 2017-08-26-00:04:37 up 2017-08-25 23:59

SQL-OUTPUT:
id strftime('%Y-%m-%d-%H:%M:%S',ts,'localtime') status laststatuschange
---------- -------------------------------------------- ---------- -------------------
15 2017-08-25-22:46:41 down 2017-08-25 22:46:41
28 2017-08-25-22:56:16 down 2017-08-25 22:56:16
105 2017-08-25-23:59:19 down 2017-08-25 23:59:19
612 2017-08-26-08:12:18 down 2017-08-26 08:12:18
616 2017-08-26-18:57:05 down 2017-08-26 18:57:05
618 2017-08-26-18:59:11 down 2017-08-26 18:59:11
622 2017-08-26-19:14:45 down 2017-08-26 19:14:45
642 2017-08-26-19:38:44 down 2017-08-26 19:38:44
665 2017-08-26-20:15:11 down 2017-08-26 20:15:11
1304 2017-08-27-06:49:31 down 2017-08-27 06:49:31
1307 2017-08-27-06:53:00 down 2017-08-27 06:53:00
1312 2017-08-27-14:25:24 down 2017-08-27 14:25:24
1862 2017-08-27-23:16:13 down 2017-08-27 23:16:13
2291 2017-08-28-06:29:35 down 2017-08-28 06:29:35
2398 2017-08-28-08:17:30 down 2017-08-28 08:17:30
2411 2017-08-28-08:31:33 down 2017-08-28 08:31:33
2416 2017-08-28-08:36:08 down 2017-08-28 08:36:08
2430 2017-08-28-08:50:26 down 2017-08-28 08:50:26
2463 2017-08-28-09:54:29 down 2017-08-28 09:54:28
2484 2017-08-28-10:14:29 down 2017-08-28 10:14:29
2614 2017-08-28-12:23:33 down 2017-08-28 12:23:33
2619 2017-08-29-00:45:48 down 2017-08-29 00:45:48
2624 2017-08-29-00:51:28 down 2017-08-29 00:51:28
2634 2017-08-29-01:01:50 down 2017-08-29 01:01:50
3221 2017-08-29-10:56:19 down 2017-08-29 10:56:19
3327 2017-08-29-12:55:17 down 2017-08-29 12:55:17
3338 2017-08-29-14:54:45 down 2017-08-29 14:54:45
3551 2017-08-29-18:28:25 down 2017-08-29 18:28:25
3585 2017-08-29-19:05:18 down 2017-08-29 19:05:18
3595 2017-08-29-19:24:33 down 2017-08-29 19:24:33
4401 2017-08-30-08:34:42 down 2017-08-30 08:34:42
4515 2017-08-30-10:28:00 down 2017-08-30 10:28:00
4693 2017-08-30-13:26:58 down 2017-08-30 13:26:58
4717 2017-08-30-18:38:04 down 2017-08-30 18:38:04
4727 2017-08-30-18:47:52 down 2017-08-30 18:47:52
4732 2017-08-30-18:52:43 down 2017-08-30 18:52:43
4738 2017-08-30-18:59:39 down 2017-08-30 18:59:39
4766 2017-08-30-19:28:38 down 2017-08-30 19:28:38
4783 2017-08-30-19:45:39 down 2017-08-30 19:45:39
4790 2017-08-30-19:52:50 down 2017-08-30 19:52:50
4797 2017-08-30-20:01:12 down 2017-08-30 20:01:12
4843 2017-08-30-20:46:38 down 2017-08-30 20:46:38
4849 2017-08-30-20:52:35 down 2017-08-30 20:52:35
4918 2017-08-30-22:00:23 down 2017-08-30 22:00:23

Posted on
Wed Aug 30, 2017 8:47 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Beacons all go away at one time

it looks as if it does not go to UP , just down in the last days ..

what its the "status" right now in the device state listing?

Posted on
Wed Aug 30, 2017 8:50 pm
Sharek326 offline
User avatar
Posts: 377
Joined: Jul 20, 2014
Location: Lansford, PA

Re: Beacons all go away at one time

It was up a few minutes ago then went expired now its up

Posted on
Wed Aug 30, 2017 9:23 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Beacons all go away at one time

the last Up is
112 2017-08-26-00:04:37 up 2017-08-25 23:59
that is several days ago

.. could you run the same report with "expired".. just on ibeacon is fine

Posted on
Wed Aug 30, 2017 9:26 pm
Sharek326 offline
User avatar
Posts: 377
Joined: Jul 20, 2014
Location: Lansford, PA

Re: Beacons all go away at one time

Joe Beacon Expired

Aug 30, 2017, 11:24:48 PM
SQL-OUTPUT:
id strftime('%Y-%m-%d-%H:%M:%S',ts,'localtime') status laststatuschange
---------- -------------------------------------------- ---------- -------------------
5 2017-08-25-22:38:08 expired 2017-08-25 22:38:08
11 2017-08-25-22:42:06 expired 2017-08-25 22:42:06
16 2017-08-25-22:47:16 expired 2017-08-25 22:47:16
20 2017-08-25-22:49:20 expired 2017-08-25 22:49:20
35 2017-08-25-23:01:14 expired 2017-08-25 23:01:14
36 2017-08-25-23:02:14 expired 2017-08-25 23:01:14
37 2017-08-25-23:03:33 expired 2017-08-25 23:01:14
38 2017-08-25-23:04:15 expired 2017-08-25 23:01:14
613 2017-08-26-08:13:49 expired 2017-08-26 08:13:49
619 2017-08-26-19:00:42 expired 2017-08-26 19:00:42
623 2017-08-26-19:16:16 expired 2017-08-26 19:16:16
643 2017-08-26-19:41:26 expired 2017-08-26 19:41:26
645 2017-08-26-19:57:10 expired 2017-08-26 19:57:10
646 2017-08-26-19:58:06 expired 2017-08-26 19:57:10
647 2017-08-26-19:59:06 expired 2017-08-26 19:57:10
648 2017-08-26-20:00:06 expired 2017-08-26 19:57:10
649 2017-08-26-20:00:47 expired 2017-08-26 19:57:10
650 2017-08-26-20:01:47 expired 2017-08-26 19:57:10
651 2017-08-26-20:02:47 expired 2017-08-26 19:57:10
652 2017-08-26-20:03:29 expired 2017-08-26 19:57:10
1308 2017-08-27-06:54:29 expired 2017-08-27 06:54:29
2431 2017-08-28-08:51:54 expired 2017-08-28 08:51:54
2615 2017-08-28-12:25:07 expired 2017-08-28 12:25:02
2620 2017-08-29-00:47:21 expired 2017-08-29 00:47:21
3222 2017-08-29-10:57:48 expired 2017-08-29 10:57:48
3328 2017-08-29-12:56:49 expired 2017-08-29 12:56:49
3552 2017-08-29-18:29:54 expired 2017-08-29 18:29:54
3586 2017-08-29-19:07:11 expired 2017-08-29 19:06:46
4402 2017-08-30-08:36:12 expired 2017-08-30 08:36:12
4694 2017-08-30-13:28:25 expired 2017-08-30 13:28:25
4719 2017-08-30-18:39:12 expired 2017-08-30 18:39:12
4798 2017-08-30-20:02:42 expired 2017-08-30 20:02:42
4799 2017-08-30-20:03:31 expired 2017-08-30 20:02:42
4972 2017-08-30-22:48:35 expired 2017-08-30 22:48:35




Karle Beacon



SQL-OUTPUT:
id strftime('%Y-%m-%d-%H:%M:%S',ts,'localtime') status laststatuschange
---------- -------------------------------------------- ---------- -------------------
620 2017-08-26-08:13:49 expired 2017-08-26 08:13:49
1068 2017-08-26-19:37:18 expired 2017-08-26 19:37:18
1069 2017-08-26-19:42:59 expired 2017-08-26 19:37:18
1073 2017-08-26-19:56:12 expired 2017-08-26 19:56:11
1731 2017-08-27-06:54:29 expired 2017-08-27 06:54:29
1767 2017-08-27-14:55:15 expired 2017-08-27 14:55:15
1842 2017-08-27-16:42:30 expired 2017-08-27 16:42:30
1847 2017-08-27-16:53:13 expired 2017-08-27 16:53:13
1919 2017-08-27-18:07:06 expired 2017-08-27 18:07:06
1932 2017-08-27-18:22:23 expired 2017-08-27 18:22:23
1935 2017-08-27-18:37:31 expired 2017-08-27 18:37:31
1940 2017-08-27-18:49:57 expired 2017-08-27 18:49:57
1947 2017-08-27-18:59:06 expired 2017-08-27 18:59:06
2002 2017-08-27-19:54:45 expired 2017-08-27 19:54:45
2013 2017-08-27-20:06:44 expired 2017-08-27 20:06:43
2038 2017-08-27-20:32:53 expired 2017-08-27 20:32:53
2041 2017-08-27-20:39:04 expired 2017-08-27 20:39:04
2209 2017-08-27-23:28:27 expired 2017-08-27 23:28:27
2983 2017-08-28-12:25:07 expired 2017-08-28 12:25:02
2988 2017-08-29-00:47:21 expired 2017-08-29 00:47:21
3581 2017-08-29-10:48:47 expired 2017-08-29 10:48:42
4960 2017-08-30-13:28:25 expired 2017-08-30 13:28:25
5065 2017-08-30-20:02:42 expired 2017-08-30 20:02:42

Posted on
Thu Aug 31, 2017 4:44 am
Sharek326 offline
User avatar
Posts: 377
Joined: Jul 20, 2014
Location: Lansford, PA

Re: Beacons all go away at one time

You had me thinking last night after you said it was a few days since Joes Beacon last up. Do you think it is possible I have the wrong beacon named "Joes Beacon"? When I first added the plugin there were about 6 different Beacons. The XY was easy to figure out but the Tile Mate wasn't since I had a few with 01 in the beginning. I turned on add new beacons to see what will populate. A few seconds later I got a new one.


This is Joes Beacon 01060303edfe05-2388-26988

This is the new beacon 011a07ff4c-16-522

Mine is a Tile Mate

Posted on
Thu Aug 31, 2017 5:14 am
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Beacons all go away at one time

I believe tiles start with 01-x-y and 01060303.....-x-y But let me double check.
If you want to re- add it( if it is deleted)
Enable new ibeacon in config
Then in menu delete old junk etc

Then it will accept new and old ibeacons.

You then need to put the tile next to the rpi let it run for 2 minutes an then turn off new ibeacon
Find the one with the highest signal. Move far away. After 2 minutes that one should go to down.
Then put it back next to the rpi. And repeat to be sure.


Sent from my iPhone using Tapatalk

Posted on
Thu Aug 31, 2017 5:47 am
Sharek326 offline
User avatar
Posts: 377
Joined: Jul 20, 2014
Location: Lansford, PA

Re: Beacons all go away at one time

sending you an email

Posted on
Thu Aug 31, 2017 10:21 am
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Beacons all go away at one time

just for everyone:

beacons with UUID starting with: 011a07ff4c are not ibeacons,
I have MANNNNY of them driving by over the last year, have not figured out what they are

Karl

Posted on
Thu Aug 31, 2017 4:39 pm
johnpolasek offline
Posts: 911
Joined: Aug 05, 2011
Location: Aggieland, Texas

Re: Beacons all go away at one time

kw123 wrote:
just for everyone:

beacons with UUID starting with: 011a07ff4c are not ibeacons,
I have MANNNNY of them driving by over the last year, have not figured out what they are

Karl


They are IPhones doing their "I change all my information every time I connect" thing. I tried mapping them because the 3 digit value afterward seems to be constant for at least my brother's and mine, but one in a thousand didn't seem secure enough to me, so I ignore them.

Posted on
Thu Aug 31, 2017 4:43 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Beacons all go away at one time

ok thanks, how did you find out?

Posted on
Sun Sep 03, 2017 12:48 pm
johnpolasek offline
Posts: 911
Joined: Aug 05, 2011
Location: Aggieland, Texas

Re: Beacons all go away at one time

kw123 wrote:
ok thanks, how did you find out?


Observation during the early days before we could block out new beacons... My house is a long way from any stray bluetooth sources (quarter mile down a private drive), so I have a fairly sterile environment to being new devices into the fold and a pretty good idea of what caused new beacons to appear whenever they'd show up, and every time I got home, a new beacon with a random MAC and that fragment of a UUID ending with-916- would appear and then go down about 5 minutes later. And any time I powered up my phone to check email or answer a text a similar "new" beacon would appear and then vanish a few minutes after I quit using my phone... and the same thing kept happening with my brother except his included a -346- in the UUID.

Who is online

Users browsing this forum: No registered users and 6 guests