1 | 2017-09-23 01:41:47 | system | 4 | warning | 7212 | Administrator | TX-WS087 | ::1 | discoveries | create | create | HTTP/1.1 400 Bad Request | Required attributes not supplied (m_collection::create (discoveries)). | When attempting to create a resource, some attributes are required but missing. |
2 | 2017-09-26 06:09:13 | system | 3 | error | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | read | HTTP/1.1 404 Not Found | No object could be retrieved (configuration:read, ID:888889). | When calling this function an identifier (usually but not always an integer based id) should be supplied. The supplied item was either blank, not an integer based id or we could not determine the corresponding object based on the details provided. Please check the log file for the controller and model this occurred on and report the issue to Opmantek. |
3 | 2017-09-26 06:09:23 | system | 3 | error | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | read | HTTP/1.1 404 Not Found | No object could be retrieved (configuration:read, ID:888889). | When calling this function an identifier (usually but not always an integer based id) should be supplied. The supplied item was either blank, not an integer based id or we could not determine the corresponding object based on the details provided. Please check the log file for the controller and model this occurred on and report the issue to Opmantek. |
4 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
5 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
6 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
7 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
8 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
9 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
11 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
12 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | | input_helper::inputread | parsing input | Set collection to devices, according to URI. | |
13 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | input_helper::inputread | parsing input | Set action to collection, because GET, no id, no action. | |
14 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
15 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
16 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | input_helper::inputread | parsing input | Set properties to system.id, system.icon, system.type, system.name, system.domain, system.ip, system.description, system.manufacturer, system.os_family, system.status, because devices default. | |
17 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | m_roles::collection | reading data | | |
18 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
19 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
20 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | m_roles::collection | reading data | | |
21 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
22 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | m_devices::collection | success | running sql | /* m_devices::collection */ /* m_devices::collection */ SELECT count(*) as total FROM system WHERE system.org_id IN (1) |
23 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | m_devices::collection | success | running sql | /* m_devices::collection */ /* m_devices::collection */ SELECT system.id AS `system.id`, system.icon AS `system.icon`, system.type AS `system.type`, system.name AS `system.name`, system.domain AS `system.domain`, system.ip AS `system.ip`, system.description AS `system.description`, system.manufacturer AS `system.manufacturer`, system.os_family AS `system.os_family`, system.status AS `system.status` FROM system WHERE system.org_id IN (1) ORDER BY system.id LIMIT 0,1000 |
24 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | m_queries::collection | reading data | | |
25 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
26 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
27 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
28 | 2017-09-26 23:06:23 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | devices | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
30 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
31 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
32 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
33 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
34 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
35 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
37 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
38 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
39 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set action to collection, because GET, no id, no action. | |
40 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
41 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
42 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
43 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | reading data | | |
44 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
45 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
46 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | reading data | | |
47 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
48 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
49 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
50 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT discoveries.*, orgs.name AS `org_name` FROM `discoveries` LEFT JOIN orgs ON (`discoveries`.org_id = orgs.id) WHERE orgs.id IN (1) ORDER BY discoveries.id LIMIT 1000 |
51 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_queries::collection | reading data | | |
52 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
53 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
54 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
55 | 2017-09-26 23:06:30 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
57 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
58 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
59 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
60 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
61 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
62 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
64 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
65 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
66 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set ID to 5, according to URI. | |
67 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set action to read, because GET, id and no action. | |
68 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
69 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
70 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
71 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
72 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
73 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
74 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
75 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
76 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_collection_org_permission | retrieving collection orgs | retrieving parent orgs | |
77 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | reading data | | |
78 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | success | running sql | /* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 5 |
79 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | reading data | | |
80 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | success | running sql | /* m_orgs::collection */ SELECT orgs.*, o2.name as `parent_name`, count(DISTINCT system.id) as device_count FROM orgs LEFT JOIN orgs o2 ON orgs.parent_id = o2.id LEFT JOIN system ON (orgs.id = system.org_id) WHERE orgs.id IN (1) GROUP BY orgs.id |
81 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | reading data | | |
82 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | success | running sql | /* m_locations::collection */ SELECT locations.*, COUNT(DISTINCT system.id) AS `device_count`, COUNT(DISTINCT system.id) AS `device_count`, orgs.name AS `org_name` FROM `locations` LEFT JOIN system ON (locations.id = system.location_id) LEFT JOIN orgs ON (locations.org_id = orgs.id) WHERE orgs.id IN (1) GROUP BY locations.id |
83 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | reading data | | |
84 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | success | running sql | /* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 5 ORDER BY `id` |
85 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | reading data | | |
86 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
87 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
88 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
89 | 2017-09-26 23:06:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
91 | 2017-09-26 23:06:56 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
92 | 2017-09-26 23:06:56 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
93 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
94 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
95 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
96 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
98 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
99 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
100 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set action to collection, because GET, no id, no action. | |
101 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
102 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
103 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
104 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | reading data | | |
105 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
106 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
107 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | reading data | | |
108 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
109 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
110 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
111 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT discoveries.*, orgs.name AS `org_name` FROM `discoveries` LEFT JOIN orgs ON (`discoveries`.org_id = orgs.id) WHERE orgs.id IN (1) ORDER BY discoveries.id LIMIT 1000 |
112 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_queries::collection | reading data | | |
113 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
114 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
115 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
116 | 2017-09-26 23:06:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
118 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
119 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
120 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
121 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
122 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
123 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
125 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
126 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
127 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set ID to 5, according to URI. | |
128 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set action to execute, according to GET. | |
129 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | input_helper::inputread | parsing input | Set action to execute, because GET, id and action = execute. | |
130 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
131 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
132 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
133 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_roles::collection | reading data | | |
134 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
135 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
136 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_roles::collection | reading data | | |
137 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
138 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_users::get_user_collection_org_permission | retrieving collection orgs | retrieving parent orgs | |
139 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_discoveries::execute | executing discovery | | |
140 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_discoveries::execute | success | running sql | /* m_discoveries::execute */ SELECT * FROM discoveries WHERE id = 5 |
141 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_discoveries::execute | success | running sql | /* m_discoveries::execute */ DELETE FROM `discovery_log` WHERE `discovery_id` = 5 |
142 | 2017-09-26 23:07:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_discoveries::execute | success | running sql | /* m_discoveries::execute */ UPDATE `discoveries` SET `device_count` = 0, `complete` = 'n', `last_run` = NOW(), `limit` = 1000 WHERE id = 5 |
143 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
144 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
145 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
146 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
147 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
148 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
150 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
151 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
152 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set ID to 5, according to URI. | |
153 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set action to read, because GET, id and no action. | |
154 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
155 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
156 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
157 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
158 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
159 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
160 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
161 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
162 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_collection_org_permission | retrieving collection orgs | retrieving parent orgs | |
163 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | reading data | | |
164 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | success | running sql | /* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 5 |
165 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | reading data | | |
166 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | success | running sql | /* m_orgs::collection */ SELECT orgs.*, o2.name as `parent_name`, count(DISTINCT system.id) as device_count FROM orgs LEFT JOIN orgs o2 ON orgs.parent_id = o2.id LEFT JOIN system ON (orgs.id = system.org_id) WHERE orgs.id IN (1) GROUP BY orgs.id |
167 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | reading data | | |
168 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | success | running sql | /* m_locations::collection */ SELECT locations.*, COUNT(DISTINCT system.id) AS `device_count`, COUNT(DISTINCT system.id) AS `device_count`, orgs.name AS `org_name` FROM `locations` LEFT JOIN system ON (locations.id = system.location_id) LEFT JOIN orgs ON (locations.org_id = orgs.id) WHERE orgs.id IN (1) GROUP BY locations.id |
169 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | reading data | | |
170 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | success | running sql | /* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 5 ORDER BY `id` |
171 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | reading data | | |
172 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
173 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
174 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
175 | 2017-09-26 23:07:01 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
177 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
178 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
179 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
180 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
181 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
182 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
184 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
185 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
186 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set ID to 5, according to URI. | |
187 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set action to read, because GET, id and no action. | |
188 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
189 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
190 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
191 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
192 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
193 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
194 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
195 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
196 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_collection_org_permission | retrieving collection orgs | retrieving parent orgs | |
197 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | reading data | | |
198 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | success | running sql | /* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 5 |
199 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | reading data | | |
200 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | success | running sql | /* m_orgs::collection */ SELECT orgs.*, o2.name as `parent_name`, count(DISTINCT system.id) as device_count FROM orgs LEFT JOIN orgs o2 ON orgs.parent_id = o2.id LEFT JOIN system ON (orgs.id = system.org_id) WHERE orgs.id IN (1) GROUP BY orgs.id |
201 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | reading data | | |
202 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | success | running sql | /* m_locations::collection */ SELECT locations.*, COUNT(DISTINCT system.id) AS `device_count`, COUNT(DISTINCT system.id) AS `device_count`, orgs.name AS `org_name` FROM `locations` LEFT JOIN system ON (locations.id = system.location_id) LEFT JOIN orgs ON (locations.org_id = orgs.id) WHERE orgs.id IN (1) GROUP BY locations.id |
203 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | reading data | | |
204 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | success | running sql | /* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 5 ORDER BY `id` |
205 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | reading data | | |
206 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
207 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
208 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
209 | 2017-09-26 23:07:03 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
211 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
212 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
213 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
214 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
215 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
216 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
218 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
219 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
220 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set action to collection, because GET, no id, no action. | |
221 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
222 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
223 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
224 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | reading data | | |
225 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
226 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
227 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | reading data | | |
228 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
229 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
230 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
231 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT discoveries.*, orgs.name AS `org_name` FROM `discoveries` LEFT JOIN orgs ON (`discoveries`.org_id = orgs.id) WHERE orgs.id IN (1) ORDER BY discoveries.id LIMIT 1000 |
232 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_queries::collection | reading data | | |
233 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
234 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
235 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
236 | 2017-09-26 23:07:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
238 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
239 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
240 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
241 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
242 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
243 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
245 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
246 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
247 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set ID to 9, according to URI. | |
248 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set action to execute, according to GET. | |
249 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | input_helper::inputread | parsing input | Set action to execute, because GET, id and action = execute. | |
250 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
251 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
252 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
253 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_roles::collection | reading data | | |
254 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
255 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
256 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_roles::collection | reading data | | |
257 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
258 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_users::get_user_collection_org_permission | retrieving collection orgs | retrieving parent orgs | |
259 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_discoveries::execute | executing discovery | | |
260 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_discoveries::execute | success | running sql | /* m_discoveries::execute */ SELECT * FROM discoveries WHERE id = 9 |
261 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_discoveries::execute | success | running sql | /* m_discoveries::execute */ DELETE FROM `discovery_log` WHERE `discovery_id` = 9 |
262 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_discoveries::execute | success | running sql | /* m_discoveries::execute */ UPDATE `discoveries` SET `device_count` = 0, `complete` = 'n', `last_run` = NOW(), `limit` = 1000 WHERE id = 9 |
263 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_credentials::collection | reading data | | |
264 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_credentials::collection | success | running sql | /* m_credentials::collection */ SELECT credentials.*, orgs.name AS `org_name` FROM `credentials` LEFT JOIN orgs ON (`credentials`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
265 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_discoveries::execute | success | running sql | /* m_discoveries::execute */ UPDATE `discoveries` SET `complete` = 'y' WHERE id = '9' |
266 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
267 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
268 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
269 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
270 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
271 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
273 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
274 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
275 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set ID to 9, according to URI. | |
276 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set action to read, because GET, id and no action. | |
277 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
278 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
279 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
280 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
281 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
282 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
283 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
284 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
285 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_collection_org_permission | retrieving collection orgs | retrieving parent orgs | |
286 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | reading data | | |
287 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | success | running sql | /* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 9 |
288 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | reading data | | |
289 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | success | running sql | /* m_orgs::collection */ SELECT orgs.*, o2.name as `parent_name`, count(DISTINCT system.id) as device_count FROM orgs LEFT JOIN orgs o2 ON orgs.parent_id = o2.id LEFT JOIN system ON (orgs.id = system.org_id) WHERE orgs.id IN (1) GROUP BY orgs.id |
290 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | reading data | | |
291 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | success | running sql | /* m_locations::collection */ SELECT locations.*, COUNT(DISTINCT system.id) AS `device_count`, COUNT(DISTINCT system.id) AS `device_count`, orgs.name AS `org_name` FROM `locations` LEFT JOIN system ON (locations.id = system.location_id) LEFT JOIN orgs ON (locations.org_id = orgs.id) WHERE orgs.id IN (1) GROUP BY locations.id |
292 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | reading data | | |
293 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | success | running sql | /* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 9 ORDER BY `id` |
294 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | reading data | | |
295 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
296 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
297 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
298 | 2017-09-26 23:07:08 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
300 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
301 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
302 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
303 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
304 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
305 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
307 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
308 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
309 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set ID to 9, according to URI. | |
310 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set action to execute, according to GET. | |
311 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | input_helper::inputread | parsing input | Set action to execute, because GET, id and action = execute. | |
312 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
313 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
314 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
315 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_roles::collection | reading data | | |
316 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
317 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
318 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_roles::collection | reading data | | |
319 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
320 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_users::get_user_collection_org_permission | retrieving collection orgs | retrieving parent orgs | |
321 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_discoveries::execute | executing discovery | | |
322 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_discoveries::execute | success | running sql | /* m_discoveries::execute */ SELECT * FROM discoveries WHERE id = 9 |
323 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_discoveries::execute | success | running sql | /* m_discoveries::execute */ DELETE FROM `discovery_log` WHERE `discovery_id` = 9 |
324 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_discoveries::execute | success | running sql | /* m_discoveries::execute */ UPDATE `discoveries` SET `device_count` = 0, `complete` = 'n', `last_run` = NOW(), `limit` = 1000 WHERE id = 9 |
325 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_credentials::collection | reading data | | |
326 | 2017-09-26 23:07:10 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_credentials::collection | success | running sql | /* m_credentials::collection */ SELECT credentials.*, orgs.name AS `org_name` FROM `credentials` LEFT JOIN orgs ON (`credentials`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
327 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | execute | m_discoveries::execute | success | running sql | /* m_discoveries::execute */ UPDATE `discoveries` SET `complete` = 'y' WHERE id = '9' |
328 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
329 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
330 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
331 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
332 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
333 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
335 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
336 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
337 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set ID to 9, according to URI. | |
338 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set action to read, because GET, id and no action. | |
339 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
340 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
341 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
342 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
343 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
344 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
345 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
346 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
347 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_collection_org_permission | retrieving collection orgs | retrieving parent orgs | |
348 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | reading data | | |
349 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | success | running sql | /* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 9 |
350 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | reading data | | |
351 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | success | running sql | /* m_orgs::collection */ SELECT orgs.*, o2.name as `parent_name`, count(DISTINCT system.id) as device_count FROM orgs LEFT JOIN orgs o2 ON orgs.parent_id = o2.id LEFT JOIN system ON (orgs.id = system.org_id) WHERE orgs.id IN (1) GROUP BY orgs.id |
352 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | reading data | | |
353 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | success | running sql | /* m_locations::collection */ SELECT locations.*, COUNT(DISTINCT system.id) AS `device_count`, COUNT(DISTINCT system.id) AS `device_count`, orgs.name AS `org_name` FROM `locations` LEFT JOIN system ON (locations.id = system.location_id) LEFT JOIN orgs ON (locations.org_id = orgs.id) WHERE orgs.id IN (1) GROUP BY locations.id |
354 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | reading data | | |
355 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | success | running sql | /* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 9 ORDER BY `id` |
356 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | reading data | | |
357 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
358 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
359 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
360 | 2017-09-26 23:07:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
362 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
363 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
364 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
365 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
366 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
367 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
369 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
370 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
371 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set ID to 9, according to URI. | |
372 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set action to read, because GET, id and no action. | |
373 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
374 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
375 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
376 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
377 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
378 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
379 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
380 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
381 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_collection_org_permission | retrieving collection orgs | retrieving parent orgs | |
382 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | reading data | | |
383 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | success | running sql | /* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 9 |
384 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | reading data | | |
385 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | success | running sql | /* m_orgs::collection */ SELECT orgs.*, o2.name as `parent_name`, count(DISTINCT system.id) as device_count FROM orgs LEFT JOIN orgs o2 ON orgs.parent_id = o2.id LEFT JOIN system ON (orgs.id = system.org_id) WHERE orgs.id IN (1) GROUP BY orgs.id |
386 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | reading data | | |
387 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | success | running sql | /* m_locations::collection */ SELECT locations.*, COUNT(DISTINCT system.id) AS `device_count`, COUNT(DISTINCT system.id) AS `device_count`, orgs.name AS `org_name` FROM `locations` LEFT JOIN system ON (locations.id = system.location_id) LEFT JOIN orgs ON (locations.org_id = orgs.id) WHERE orgs.id IN (1) GROUP BY locations.id |
388 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | reading data | | |
389 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | success | running sql | /* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 9 ORDER BY `id` |
390 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | reading data | | |
391 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
392 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
393 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
394 | 2017-09-26 23:07:24 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
396 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
397 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
398 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
399 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
400 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
401 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
403 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
404 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
405 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set ID to 9, according to URI. | |
406 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set action to read, because GET, id and no action. | |
407 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
408 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
409 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
410 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
411 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
412 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
413 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
414 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
415 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_collection_org_permission | retrieving collection orgs | retrieving parent orgs | |
416 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | reading data | | |
417 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | success | running sql | /* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 9 |
418 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | reading data | | |
419 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | success | running sql | /* m_orgs::collection */ SELECT orgs.*, o2.name as `parent_name`, count(DISTINCT system.id) as device_count FROM orgs LEFT JOIN orgs o2 ON orgs.parent_id = o2.id LEFT JOIN system ON (orgs.id = system.org_id) WHERE orgs.id IN (1) GROUP BY orgs.id |
420 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | reading data | | |
421 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | success | running sql | /* m_locations::collection */ SELECT locations.*, COUNT(DISTINCT system.id) AS `device_count`, COUNT(DISTINCT system.id) AS `device_count`, orgs.name AS `org_name` FROM `locations` LEFT JOIN system ON (locations.id = system.location_id) LEFT JOIN orgs ON (locations.org_id = orgs.id) WHERE orgs.id IN (1) GROUP BY locations.id |
422 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | reading data | | |
423 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | success | running sql | /* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 9 ORDER BY `id` |
424 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | reading data | | |
425 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
426 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
427 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
428 | 2017-09-26 23:07:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
430 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
431 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
432 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
433 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
434 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
435 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
437 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
438 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
439 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set action to collection, because GET, no id, no action. | |
440 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
441 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
442 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
443 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | reading data | | |
444 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
445 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
446 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | reading data | | |
447 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
448 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
449 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
450 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT discoveries.*, orgs.name AS `org_name` FROM `discoveries` LEFT JOIN orgs ON (`discoveries`.org_id = orgs.id) WHERE orgs.id IN (1) ORDER BY discoveries.id LIMIT 1000 |
451 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_queries::collection | reading data | | |
452 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
453 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
454 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
455 | 2017-09-26 23:10:00 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
457 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
458 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
459 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
460 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
461 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
462 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
464 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
465 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
466 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set ID to 8, according to URI. | |
467 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set action to read, because GET, id and no action. | |
468 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
469 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
470 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
471 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
472 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
473 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
474 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
475 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
476 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_collection_org_permission | retrieving collection orgs | retrieving parent orgs | |
477 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | reading data | | |
478 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | success | running sql | /* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 8 |
479 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | reading data | | |
480 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | success | running sql | /* m_orgs::collection */ SELECT orgs.*, o2.name as `parent_name`, count(DISTINCT system.id) as device_count FROM orgs LEFT JOIN orgs o2 ON orgs.parent_id = o2.id LEFT JOIN system ON (orgs.id = system.org_id) WHERE orgs.id IN (1) GROUP BY orgs.id |
481 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | reading data | | |
482 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | success | running sql | /* m_locations::collection */ SELECT locations.*, COUNT(DISTINCT system.id) AS `device_count`, COUNT(DISTINCT system.id) AS `device_count`, orgs.name AS `org_name` FROM `locations` LEFT JOIN system ON (locations.id = system.location_id) LEFT JOIN orgs ON (locations.org_id = orgs.id) WHERE orgs.id IN (1) GROUP BY locations.id |
483 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | reading data | | |
484 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | success | running sql | /* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 8 ORDER BY `id` |
485 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | reading data | | |
486 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
487 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
488 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
489 | 2017-09-26 23:10:46 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
491 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
492 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
493 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
494 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
495 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
496 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
498 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
499 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
500 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set action to collection, because GET, no id, no action. | |
501 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
502 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
503 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
504 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | reading data | | |
505 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
506 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
507 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | reading data | | |
508 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
509 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
510 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
511 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT discoveries.*, orgs.name AS `org_name` FROM `discoveries` LEFT JOIN orgs ON (`discoveries`.org_id = orgs.id) WHERE orgs.id IN (1) ORDER BY discoveries.id LIMIT 1000 |
512 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_queries::collection | reading data | | |
513 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
514 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
515 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
516 | 2017-09-26 23:10:59 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
518 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
519 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
520 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
521 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
522 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
523 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
525 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
526 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
527 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set ID to 7, according to URI. | |
528 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | delete | input_helper::inputread | parsing input | Set action to delete, because DELETE, id. | |
529 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | delete | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
530 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | delete | input_helper::inputread | parsing input | Set format to json, according to HEADERS. | |
531 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | delete | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
532 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | delete | m_roles::collection | reading data | | |
533 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | delete | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
534 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | delete | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
535 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | delete | m_roles::collection | reading data | | |
536 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | delete | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
537 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | delete | m_users::get_user_collection_org_permission | retrieving collection orgs | retrieving parent orgs | |
538 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | delete | m_discoveries::delete | deleting data | | |
539 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | delete | m_discoveries::delete | success | running sql | /* m_discoveries::delete */ /* discoveries::delete */ DELETE FROM `discoveries` WHERE id = 7 |
541 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
542 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
543 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
544 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
545 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
546 | 2017-09-26 23:11:06 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
548 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
549 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
550 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set action to collection, because GET, no id, no action. | |
551 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
552 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
553 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
554 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | reading data | | |
555 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
556 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
557 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | reading data | | |
558 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
559 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
560 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
561 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT discoveries.*, orgs.name AS `org_name` FROM `discoveries` LEFT JOIN orgs ON (`discoveries`.org_id = orgs.id) WHERE orgs.id IN (1) ORDER BY discoveries.id LIMIT 1000 |
562 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_queries::collection | reading data | | |
563 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
564 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
565 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
566 | 2017-09-26 23:11:07 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
568 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
569 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
570 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
571 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
572 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
573 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
575 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
576 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | | input_helper::inputread | parsing input | Set collection to logs, according to URI. | |
577 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set action to collection, because GET, no id, no action. | |
578 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
579 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
580 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
581 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | reading data | | |
582 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
583 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
584 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | reading data | | |
585 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
586 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
587 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
588 | 2017-09-26 23:19:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT logs.* FROM `logs` WHERE logs.type = "system" ORDER BY logs.id LIMIT 100 |
589 | 2017-09-26 23:19:58 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_queries::collection | reading data | | |
590 | 2017-09-26 23:19:58 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
591 | 2017-09-26 23:19:58 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
592 | 2017-09-26 23:19:58 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
593 | 2017-09-26 23:19:58 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
595 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
596 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
597 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
598 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
599 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
600 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
602 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
603 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
604 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set action to collection, because GET, no id, no action. | |
605 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
606 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
607 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
608 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | reading data | | |
609 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
610 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
611 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | reading data | | |
612 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
613 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
614 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
615 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT discoveries.*, orgs.name AS `org_name` FROM `discoveries` LEFT JOIN orgs ON (`discoveries`.org_id = orgs.id) WHERE orgs.id IN (1) ORDER BY discoveries.id LIMIT 1000 |
616 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_queries::collection | reading data | | |
617 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
618 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
619 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
620 | 2017-09-26 23:25:45 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
622 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
623 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
624 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
625 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
626 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
627 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
629 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
630 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
631 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set ID to 5, according to URI. | |
632 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set action to read, because GET, id and no action. | |
633 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
634 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
635 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
636 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
637 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
638 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
639 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
640 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
641 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_collection_org_permission | retrieving collection orgs | retrieving parent orgs | |
642 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | reading data | | |
643 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | success | running sql | /* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 5 |
644 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | reading data | | |
645 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | success | running sql | /* m_orgs::collection */ SELECT orgs.*, o2.name as `parent_name`, count(DISTINCT system.id) as device_count FROM orgs LEFT JOIN orgs o2 ON orgs.parent_id = o2.id LEFT JOIN system ON (orgs.id = system.org_id) WHERE orgs.id IN (1) GROUP BY orgs.id |
646 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | reading data | | |
647 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | success | running sql | /* m_locations::collection */ SELECT locations.*, COUNT(DISTINCT system.id) AS `device_count`, COUNT(DISTINCT system.id) AS `device_count`, orgs.name AS `org_name` FROM `locations` LEFT JOIN system ON (locations.id = system.location_id) LEFT JOIN orgs ON (locations.org_id = orgs.id) WHERE orgs.id IN (1) GROUP BY locations.id |
648 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | reading data | | |
649 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | success | running sql | /* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 5 ORDER BY `id` |
650 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | reading data | | |
651 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
652 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
653 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
654 | 2017-09-26 23:25:51 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
656 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
657 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
658 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
659 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
660 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
661 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
663 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
664 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set collection to discoveries, according to URI. | |
665 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | | input_helper::inputread | parsing input | Set ID to 5, according to URI. | |
666 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set action to read, because GET, id and no action. | |
667 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
668 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
669 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
670 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
671 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
672 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
673 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | reading data | | |
674 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
675 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_users::get_user_collection_org_permission | retrieving collection orgs | retrieving parent orgs | |
676 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | reading data | | |
677 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read | success | running sql | /* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 5 |
678 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | reading data | | |
679 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_orgs::collection | success | running sql | /* m_orgs::collection */ SELECT orgs.*, o2.name as `parent_name`, count(DISTINCT system.id) as device_count FROM orgs LEFT JOIN orgs o2 ON orgs.parent_id = o2.id LEFT JOIN system ON (orgs.id = system.org_id) WHERE orgs.id IN (1) GROUP BY orgs.id |
680 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | reading data | | |
681 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_locations::collection | success | running sql | /* m_locations::collection */ SELECT locations.*, COUNT(DISTINCT system.id) AS `device_count`, COUNT(DISTINCT system.id) AS `device_count`, orgs.name AS `org_name` FROM `locations` LEFT JOIN system ON (locations.id = system.location_id) LEFT JOIN orgs ON (locations.org_id = orgs.id) WHERE orgs.id IN (1) GROUP BY locations.id |
682 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | reading data | | |
683 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_discoveries::read_sub_resource | success | running sql | /* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 5 ORDER BY `id` |
684 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | reading data | | |
685 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
686 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
687 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
688 | 2017-09-26 23:25:57 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | discoveries | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
690 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
691 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
692 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
693 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
694 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
695 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
697 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
698 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | | input_helper::inputread | parsing input | Set collection to configuration, according to URI. | |
699 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | input_helper::inputread | parsing input | Set action to collection, because GET, no id, no action. | |
700 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
701 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
702 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
703 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_roles::collection | reading data | | |
704 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
705 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
706 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_roles::collection | reading data | | |
707 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
708 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
709 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
710 | 2017-09-26 23:26:11 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT configuration.* FROM configuration ORDER BY configuration.id LIMIT 1000 |
711 | 2017-09-26 23:26:12 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_queries::collection | reading data | | |
712 | 2017-09-26 23:26:12 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
713 | 2017-09-26 23:26:12 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
714 | 2017-09-26 23:26:12 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
715 | 2017-09-26 23:26:12 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
717 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
718 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
719 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
720 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
721 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
722 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
724 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
725 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | | input_helper::inputread | parsing input | Set collection to configuration, according to URI. | |
726 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | | input_helper::inputread | parsing input | Set ID to 26, according to URI. | |
727 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | input_helper::inputread | parsing input | Set action to read, because GET, id and no action. | |
728 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
729 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
730 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
731 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | m_roles::collection | reading data | | |
732 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
733 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
734 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | m_roles::collection | reading data | | |
735 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
736 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | m_configuration::read | loading data | | |
737 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | m_configuration::read | success | running sql | /* m_configuration::read */ SELECT * FROM configuration WHERE id = 26 |
738 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | m_orgs::collection | reading data | | |
739 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | m_orgs::collection | success | running sql | /* m_orgs::collection */ SELECT orgs.*, o2.name as `parent_name`, count(DISTINCT system.id) as device_count FROM orgs LEFT JOIN orgs o2 ON orgs.parent_id = o2.id LEFT JOIN system ON (orgs.id = system.org_id) WHERE orgs.id IN (1) GROUP BY orgs.id |
740 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | m_queries::collection | reading data | | |
741 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
742 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
743 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
744 | 2017-09-26 23:26:38 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | read | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
746 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
747 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
748 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
749 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
750 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
751 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
753 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
754 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | | input_helper::inputread | parsing input | Set collection to configuration, according to URI. | |
755 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | input_helper::inputread | parsing input | Set action to collection, because GET, no id, no action. | |
756 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
757 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
758 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
759 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_roles::collection | reading data | | |
760 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
761 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
762 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_roles::collection | reading data | | |
763 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
764 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
765 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
766 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT configuration.* FROM configuration ORDER BY configuration.id LIMIT 1000 |
767 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_queries::collection | reading data | | |
768 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
769 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
770 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
771 | 2017-09-26 23:26:41 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | configuration | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
773 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
774 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
775 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
776 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
777 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
778 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
780 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
781 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | | input_helper::inputread | parsing input | Set collection to logs, according to URI. | |
782 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set action to collection, because GET, no id, no action. | |
783 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
784 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
785 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
786 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | reading data | | |
787 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
788 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
789 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | reading data | | |
790 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
791 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
792 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
793 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT logs.* FROM `logs` WHERE logs.type = "access" ORDER BY logs.id LIMIT 100 |
794 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_queries::collection | reading data | | |
795 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
796 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
797 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
798 | 2017-09-26 23:27:28 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
800 | 2017-09-26 23:27:31 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
801 | 2017-09-26 23:27:31 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
802 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
803 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
804 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
805 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
807 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
808 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | | input_helper::inputread | parsing input | Set collection to logs, according to URI. | |
809 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set action to collection, because GET, no id, no action. | |
810 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
811 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
812 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
813 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | reading data | | |
814 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
815 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
816 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | reading data | | |
817 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
818 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
819 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
820 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT logs.* FROM `logs` WHERE logs.type = "system" ORDER BY logs.id LIMIT 100 |
821 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_queries::collection | reading data | | |
822 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_queries::collection | success | running sql | /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (1) GROUP BY queries.name |
823 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
824 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |
825 | 2017-09-26 23:27:32 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (1) OR orgs.id IN (1)) |
827 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT NOW() as `timestamp` |
828 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_configuration::load | success | running sql | /* m_configuration::load */ SELECT count(*) as device_count FROM system |
829 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | | TX-WS087 | ::1 | | | m_users::validate | pre | validating user | |
830 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_orgs | pre | retrieving orgs | |
831 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_org | pre | retrieving org | |
832 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | m_users::get_parent_orgs | pre | retrieving parent orgs | |
834 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | | | input_helper::inputread | parsing input | | |
835 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | | input_helper::inputread | parsing input | Set collection to logs, according to URI. | |
836 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set action to collection, because GET, no id, no action. | |
837 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set current to y, because in reserved words. | |
838 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set format to screen, according to HEADERS. | |
839 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set format to html, according to GET. | |
840 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | input_helper::inputread | parsing input | Set properties to *, because non-devices default. | |
841 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | reading data | | |
842 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
843 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_users::get_user_permission | success | running sql | /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1 |
844 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | reading data | | |
845 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_roles::collection | success | running sql | /* m_roles::collection */ SELECT * FROM `roles` |
846 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM orgs |
847 | 2017-09-26 23:28:16 | system | 7 | debug | 7212 | Administrator | TX-WS087 | ::1 | logs | collection | m_collection::collection | success | running sql | /* m_collection::collection */ SELECT id, name FROM locations |