idtimestamptypeseverityseverity_textpiduserserveripcollectionactionfunctionstatussummarydetail
12017-09-23 01:41:47system4warning7212AdministratorTX-WS087::1discoveriescreatecreateHTTP/1.1 400 Bad RequestRequired attributes not supplied (m_collection::create (discoveries)).When attempting to create a resource, some attributes are required but missing.
22017-09-26 06:09:13system3error7212AdministratorTX-WS087::1configurationreadreadHTTP/1.1 404 Not FoundNo 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.
32017-09-26 06:09:23system3error7212AdministratorTX-WS087::1configurationreadreadHTTP/1.1 404 Not FoundNo 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.
42017-09-26 23:06:23system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
52017-09-26 23:06:23system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
62017-09-26 23:06:23system7debug7212TX-WS087::1m_users::validateprevalidating user
72017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
82017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
92017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
112017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
122017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicesinput_helper::inputreadparsing inputSet collection to devices, according to URI.
132017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectioninput_helper::inputreadparsing inputSet action to collection, because GET, no id, no action.
142017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectioninput_helper::inputreadparsing inputSet current to y, because in reserved words.
152017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectioninput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
162017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectioninput_helper::inputreadparsing inputSet 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.
172017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectionm_roles::collectionreading data
182017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
192017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectionm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
202017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectionm_roles::collectionreading data
212017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
222017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectionm_devices::collectionsuccessrunning sql/* m_devices::collection */ /* m_devices::collection */ SELECT count(*) as total FROM system WHERE system.org_id IN (1)
232017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectionm_devices::collectionsuccessrunning 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
242017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectionm_queries::collectionreading data
252017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectionm_queries::collectionsuccessrunning 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
262017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
272017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
282017-09-26 23:06:23system7debug7212AdministratorTX-WS087::1devicescollectionm_collection::collectionsuccessrunning 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))
302017-09-26 23:06:30system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
312017-09-26 23:06:30system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
322017-09-26 23:06:30system7debug7212TX-WS087::1m_users::validateprevalidating user
332017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
342017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
352017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
372017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
382017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
392017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet action to collection, because GET, no id, no action.
402017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet current to y, because in reserved words.
412017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
422017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet properties to *, because non-devices default.
432017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionreading data
442017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
452017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectionm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
462017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionreading data
472017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
482017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
492017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
502017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning 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
512017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectionm_queries::collectionreading data
522017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectionm_queries::collectionsuccessrunning 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
532017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
542017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
552017-09-26 23:06:30system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning 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))
572017-09-26 23:06:46system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
582017-09-26 23:06:46system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
592017-09-26 23:06:46system7debug7212TX-WS087::1m_users::validateprevalidating user
602017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
612017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
622017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
642017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
652017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
662017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet ID to 5, according to URI.
672017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet action to read, because GET, id and no action.
682017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet current to y, because in reserved words.
692017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
702017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
712017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
722017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
732017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
742017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
752017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
762017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_collection_org_permissionretrieving collection orgsretrieving parent orgs
772017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readreading data
782017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readsuccessrunning sql/* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 5
792017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionreading data
802017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionsuccessrunning 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
812017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionreading data
822017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionsuccessrunning 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
832017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcereading data
842017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcesuccessrunning sql/* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 5 ORDER BY `id`
852017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionreading data
862017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionsuccessrunning 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
872017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
882017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
892017-09-26 23:06:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning 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))
912017-09-26 23:06:56system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
922017-09-26 23:06:56system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
932017-09-26 23:06:57system7debug7212TX-WS087::1m_users::validateprevalidating user
942017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
952017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
962017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
982017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
992017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
1002017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet action to collection, because GET, no id, no action.
1012017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet current to y, because in reserved words.
1022017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
1032017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet properties to *, because non-devices default.
1042017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionreading data
1052017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
1062017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectionm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
1072017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionreading data
1082017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
1092017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
1102017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
1112017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning 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
1122017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectionm_queries::collectionreading data
1132017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectionm_queries::collectionsuccessrunning 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
1142017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
1152017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
1162017-09-26 23:06:57system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning 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))
1182017-09-26 23:07:00system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
1192017-09-26 23:07:00system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
1202017-09-26 23:07:00system7debug7212TX-WS087::1m_users::validateprevalidating user
1212017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
1222017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
1232017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
1252017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
1262017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
1272017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet ID to 5, according to URI.
1282017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet action to execute, according to GET.
1292017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesexecuteinput_helper::inputreadparsing inputSet action to execute, because GET, id and action = execute.
1302017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesexecuteinput_helper::inputreadparsing inputSet current to y, because in reserved words.
1312017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesexecuteinput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
1322017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesexecuteinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
1332017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesexecutem_roles::collectionreading data
1342017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesexecutem_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
1352017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesexecutem_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
1362017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesexecutem_roles::collectionreading data
1372017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesexecutem_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
1382017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesexecutem_users::get_user_collection_org_permissionretrieving collection orgsretrieving parent orgs
1392017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesexecutem_discoveries::executeexecuting discovery
1402017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesexecutem_discoveries::executesuccessrunning sql/* m_discoveries::execute */ SELECT * FROM discoveries WHERE id = 5
1412017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesexecutem_discoveries::executesuccessrunning sql/* m_discoveries::execute */ DELETE FROM `discovery_log` WHERE `discovery_id` = 5
1422017-09-26 23:07:00system7debug7212AdministratorTX-WS087::1discoveriesexecutem_discoveries::executesuccessrunning sql/* m_discoveries::execute */ UPDATE `discoveries` SET `device_count` = 0, `complete` = 'n', `last_run` = NOW(), `limit` = 1000 WHERE id = 5
1432017-09-26 23:07:01system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
1442017-09-26 23:07:01system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
1452017-09-26 23:07:01system7debug7212TX-WS087::1m_users::validateprevalidating user
1462017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
1472017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
1482017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
1502017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
1512017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
1522017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet ID to 5, according to URI.
1532017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet action to read, because GET, id and no action.
1542017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet current to y, because in reserved words.
1552017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
1562017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
1572017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
1582017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
1592017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
1602017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
1612017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
1622017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_collection_org_permissionretrieving collection orgsretrieving parent orgs
1632017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readreading data
1642017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readsuccessrunning sql/* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 5
1652017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionreading data
1662017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionsuccessrunning 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
1672017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionreading data
1682017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionsuccessrunning 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
1692017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcereading data
1702017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcesuccessrunning sql/* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 5 ORDER BY `id`
1712017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionreading data
1722017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionsuccessrunning 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
1732017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
1742017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
1752017-09-26 23:07:01system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning 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))
1772017-09-26 23:07:03system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
1782017-09-26 23:07:03system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
1792017-09-26 23:07:03system7debug7212TX-WS087::1m_users::validateprevalidating user
1802017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
1812017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
1822017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
1842017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
1852017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
1862017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet ID to 5, according to URI.
1872017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet action to read, because GET, id and no action.
1882017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet current to y, because in reserved words.
1892017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
1902017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
1912017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
1922017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
1932017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
1942017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
1952017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
1962017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_collection_org_permissionretrieving collection orgsretrieving parent orgs
1972017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readreading data
1982017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readsuccessrunning sql/* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 5
1992017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionreading data
2002017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionsuccessrunning 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
2012017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionreading data
2022017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionsuccessrunning 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
2032017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcereading data
2042017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcesuccessrunning sql/* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 5 ORDER BY `id`
2052017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionreading data
2062017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionsuccessrunning 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
2072017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
2082017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
2092017-09-26 23:07:03system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning 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))
2112017-09-26 23:07:06system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
2122017-09-26 23:07:06system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
2132017-09-26 23:07:06system7debug7212TX-WS087::1m_users::validateprevalidating user
2142017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
2152017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
2162017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
2182017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
2192017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
2202017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet action to collection, because GET, no id, no action.
2212017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet current to y, because in reserved words.
2222017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
2232017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet properties to *, because non-devices default.
2242017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionreading data
2252017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
2262017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectionm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
2272017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionreading data
2282017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
2292017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
2302017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
2312017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning 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
2322017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectionm_queries::collectionreading data
2332017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectionm_queries::collectionsuccessrunning 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
2342017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
2352017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
2362017-09-26 23:07:06system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning 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))
2382017-09-26 23:07:08system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
2392017-09-26 23:07:08system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
2402017-09-26 23:07:08system7debug7212TX-WS087::1m_users::validateprevalidating user
2412017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
2422017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
2432017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
2452017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
2462017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
2472017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet ID to 9, according to URI.
2482017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet action to execute, according to GET.
2492017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecuteinput_helper::inputreadparsing inputSet action to execute, because GET, id and action = execute.
2502017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecuteinput_helper::inputreadparsing inputSet current to y, because in reserved words.
2512017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecuteinput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
2522017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecuteinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
2532017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecutem_roles::collectionreading data
2542017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecutem_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
2552017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecutem_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
2562017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecutem_roles::collectionreading data
2572017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecutem_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
2582017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecutem_users::get_user_collection_org_permissionretrieving collection orgsretrieving parent orgs
2592017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecutem_discoveries::executeexecuting discovery
2602017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecutem_discoveries::executesuccessrunning sql/* m_discoveries::execute */ SELECT * FROM discoveries WHERE id = 9
2612017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecutem_discoveries::executesuccessrunning sql/* m_discoveries::execute */ DELETE FROM `discovery_log` WHERE `discovery_id` = 9
2622017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecutem_discoveries::executesuccessrunning sql/* m_discoveries::execute */ UPDATE `discoveries` SET `device_count` = 0, `complete` = 'n', `last_run` = NOW(), `limit` = 1000 WHERE id = 9
2632017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecutem_credentials::collectionreading data
2642017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecutem_credentials::collectionsuccessrunning 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))
2652017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesexecutem_discoveries::executesuccessrunning sql/* m_discoveries::execute */ UPDATE `discoveries` SET `complete` = 'y' WHERE id = '9'
2662017-09-26 23:07:08system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
2672017-09-26 23:07:08system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
2682017-09-26 23:07:08system7debug7212TX-WS087::1m_users::validateprevalidating user
2692017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
2702017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
2712017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
2732017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
2742017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
2752017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet ID to 9, according to URI.
2762017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet action to read, because GET, id and no action.
2772017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet current to y, because in reserved words.
2782017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
2792017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
2802017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
2812017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
2822017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
2832017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
2842017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
2852017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_collection_org_permissionretrieving collection orgsretrieving parent orgs
2862017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readreading data
2872017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readsuccessrunning sql/* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 9
2882017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionreading data
2892017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionsuccessrunning 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
2902017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionreading data
2912017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionsuccessrunning 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
2922017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcereading data
2932017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcesuccessrunning sql/* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 9 ORDER BY `id`
2942017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionreading data
2952017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionsuccessrunning 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
2962017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
2972017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
2982017-09-26 23:07:08system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning 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))
3002017-09-26 23:07:10system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
3012017-09-26 23:07:10system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
3022017-09-26 23:07:10system7debug7212TX-WS087::1m_users::validateprevalidating user
3032017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
3042017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
3052017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
3072017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
3082017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
3092017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet ID to 9, according to URI.
3102017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet action to execute, according to GET.
3112017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecuteinput_helper::inputreadparsing inputSet action to execute, because GET, id and action = execute.
3122017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecuteinput_helper::inputreadparsing inputSet current to y, because in reserved words.
3132017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecuteinput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
3142017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecuteinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
3152017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecutem_roles::collectionreading data
3162017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecutem_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
3172017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecutem_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
3182017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecutem_roles::collectionreading data
3192017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecutem_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
3202017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecutem_users::get_user_collection_org_permissionretrieving collection orgsretrieving parent orgs
3212017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecutem_discoveries::executeexecuting discovery
3222017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecutem_discoveries::executesuccessrunning sql/* m_discoveries::execute */ SELECT * FROM discoveries WHERE id = 9
3232017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecutem_discoveries::executesuccessrunning sql/* m_discoveries::execute */ DELETE FROM `discovery_log` WHERE `discovery_id` = 9
3242017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecutem_discoveries::executesuccessrunning sql/* m_discoveries::execute */ UPDATE `discoveries` SET `device_count` = 0, `complete` = 'n', `last_run` = NOW(), `limit` = 1000 WHERE id = 9
3252017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecutem_credentials::collectionreading data
3262017-09-26 23:07:10system7debug7212AdministratorTX-WS087::1discoveriesexecutem_credentials::collectionsuccessrunning 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))
3272017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesexecutem_discoveries::executesuccessrunning sql/* m_discoveries::execute */ UPDATE `discoveries` SET `complete` = 'y' WHERE id = '9'
3282017-09-26 23:07:11system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
3292017-09-26 23:07:11system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
3302017-09-26 23:07:11system7debug7212TX-WS087::1m_users::validateprevalidating user
3312017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
3322017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
3332017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
3352017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
3362017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
3372017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet ID to 9, according to URI.
3382017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet action to read, because GET, id and no action.
3392017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet current to y, because in reserved words.
3402017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
3412017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
3422017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
3432017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
3442017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
3452017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
3462017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
3472017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_collection_org_permissionretrieving collection orgsretrieving parent orgs
3482017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readreading data
3492017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readsuccessrunning sql/* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 9
3502017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionreading data
3512017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionsuccessrunning 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
3522017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionreading data
3532017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionsuccessrunning 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
3542017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcereading data
3552017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcesuccessrunning sql/* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 9 ORDER BY `id`
3562017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionreading data
3572017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionsuccessrunning 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
3582017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
3592017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
3602017-09-26 23:07:11system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning 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))
3622017-09-26 23:07:24system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
3632017-09-26 23:07:24system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
3642017-09-26 23:07:24system7debug7212TX-WS087::1m_users::validateprevalidating user
3652017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
3662017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
3672017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
3692017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
3702017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
3712017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet ID to 9, according to URI.
3722017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet action to read, because GET, id and no action.
3732017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet current to y, because in reserved words.
3742017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
3752017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
3762017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
3772017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
3782017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
3792017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
3802017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
3812017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_collection_org_permissionretrieving collection orgsretrieving parent orgs
3822017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readreading data
3832017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readsuccessrunning sql/* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 9
3842017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionreading data
3852017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionsuccessrunning 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
3862017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionreading data
3872017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionsuccessrunning 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
3882017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcereading data
3892017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcesuccessrunning sql/* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 9 ORDER BY `id`
3902017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionreading data
3912017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionsuccessrunning 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
3922017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
3932017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
3942017-09-26 23:07:24system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning 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))
3962017-09-26 23:07:28system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
3972017-09-26 23:07:28system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
3982017-09-26 23:07:28system7debug7212TX-WS087::1m_users::validateprevalidating user
3992017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
4002017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
4012017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
4032017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
4042017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
4052017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet ID to 9, according to URI.
4062017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet action to read, because GET, id and no action.
4072017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet current to y, because in reserved words.
4082017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
4092017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
4102017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
4112017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
4122017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
4132017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
4142017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
4152017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_collection_org_permissionretrieving collection orgsretrieving parent orgs
4162017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readreading data
4172017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readsuccessrunning sql/* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 9
4182017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionreading data
4192017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionsuccessrunning 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
4202017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionreading data
4212017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionsuccessrunning 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
4222017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcereading data
4232017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcesuccessrunning sql/* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 9 ORDER BY `id`
4242017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionreading data
4252017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionsuccessrunning 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
4262017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
4272017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
4282017-09-26 23:07:28system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning 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))
4302017-09-26 23:10:00system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
4312017-09-26 23:10:00system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
4322017-09-26 23:10:00system7debug7212TX-WS087::1m_users::validateprevalidating user
4332017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
4342017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
4352017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
4372017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
4382017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
4392017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet action to collection, because GET, no id, no action.
4402017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet current to y, because in reserved words.
4412017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
4422017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet properties to *, because non-devices default.
4432017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionreading data
4442017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
4452017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectionm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
4462017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionreading data
4472017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
4482017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
4492017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
4502017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning 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
4512017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectionm_queries::collectionreading data
4522017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectionm_queries::collectionsuccessrunning 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
4532017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
4542017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
4552017-09-26 23:10:00system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning 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))
4572017-09-26 23:10:46system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
4582017-09-26 23:10:46system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
4592017-09-26 23:10:46system7debug7212TX-WS087::1m_users::validateprevalidating user
4602017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
4612017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
4622017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
4642017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
4652017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
4662017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet ID to 8, according to URI.
4672017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet action to read, because GET, id and no action.
4682017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet current to y, because in reserved words.
4692017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
4702017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
4712017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
4722017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
4732017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
4742017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
4752017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
4762017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_collection_org_permissionretrieving collection orgsretrieving parent orgs
4772017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readreading data
4782017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readsuccessrunning sql/* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 8
4792017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionreading data
4802017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionsuccessrunning 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
4812017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionreading data
4822017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionsuccessrunning 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
4832017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcereading data
4842017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcesuccessrunning sql/* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 8 ORDER BY `id`
4852017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionreading data
4862017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionsuccessrunning 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
4872017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
4882017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
4892017-09-26 23:10:46system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning 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))
4912017-09-26 23:10:59system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
4922017-09-26 23:10:59system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
4932017-09-26 23:10:59system7debug7212TX-WS087::1m_users::validateprevalidating user
4942017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
4952017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
4962017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
4982017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
4992017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
5002017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet action to collection, because GET, no id, no action.
5012017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet current to y, because in reserved words.
5022017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
5032017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet properties to *, because non-devices default.
5042017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionreading data
5052017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
5062017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectionm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
5072017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionreading data
5082017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
5092017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
5102017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
5112017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning 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
5122017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectionm_queries::collectionreading data
5132017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectionm_queries::collectionsuccessrunning 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
5142017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
5152017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
5162017-09-26 23:10:59system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning 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))
5182017-09-26 23:11:06system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
5192017-09-26 23:11:06system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
5202017-09-26 23:11:06system7debug7212TX-WS087::1m_users::validateprevalidating user
5212017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
5222017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
5232017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
5252017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
5262017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
5272017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet ID to 7, according to URI.
5282017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1discoveriesdeleteinput_helper::inputreadparsing inputSet action to delete, because DELETE, id.
5292017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1discoveriesdeleteinput_helper::inputreadparsing inputSet current to y, because in reserved words.
5302017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1discoveriesdeleteinput_helper::inputreadparsing inputSet format to json, according to HEADERS.
5312017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1discoveriesdeleteinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
5322017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1discoveriesdeletem_roles::collectionreading data
5332017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1discoveriesdeletem_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
5342017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1discoveriesdeletem_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
5352017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1discoveriesdeletem_roles::collectionreading data
5362017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1discoveriesdeletem_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
5372017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1discoveriesdeletem_users::get_user_collection_org_permissionretrieving collection orgsretrieving parent orgs
5382017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1discoveriesdeletem_discoveries::deletedeleting data
5392017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1discoveriesdeletem_discoveries::deletesuccessrunning sql/* m_discoveries::delete */ /* discoveries::delete */ DELETE FROM `discoveries` WHERE id = 7
5412017-09-26 23:11:06system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
5422017-09-26 23:11:06system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
5432017-09-26 23:11:06system7debug7212TX-WS087::1m_users::validateprevalidating user
5442017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
5452017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
5462017-09-26 23:11:06system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
5482017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
5492017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
5502017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet action to collection, because GET, no id, no action.
5512017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet current to y, because in reserved words.
5522017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
5532017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet properties to *, because non-devices default.
5542017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionreading data
5552017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
5562017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectionm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
5572017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionreading data
5582017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
5592017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
5602017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
5612017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning 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
5622017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectionm_queries::collectionreading data
5632017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectionm_queries::collectionsuccessrunning 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
5642017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
5652017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
5662017-09-26 23:11:07system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning 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))
5682017-09-26 23:19:57system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
5692017-09-26 23:19:57system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
5702017-09-26 23:19:57system7debug7212TX-WS087::1m_users::validateprevalidating user
5712017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
5722017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
5732017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
5752017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
5762017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1logsinput_helper::inputreadparsing inputSet collection to logs, according to URI.
5772017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet action to collection, because GET, no id, no action.
5782017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet current to y, because in reserved words.
5792017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
5802017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet properties to *, because non-devices default.
5812017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionreading data
5822017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
5832017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1logscollectionm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
5842017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionreading data
5852017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
5862017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
5872017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
5882017-09-26 23:19:57system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT logs.* FROM `logs` WHERE logs.type = "system" ORDER BY logs.id LIMIT 100
5892017-09-26 23:19:58system7debug7212AdministratorTX-WS087::1logscollectionm_queries::collectionreading data
5902017-09-26 23:19:58system7debug7212AdministratorTX-WS087::1logscollectionm_queries::collectionsuccessrunning 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
5912017-09-26 23:19:58system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
5922017-09-26 23:19:58system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
5932017-09-26 23:19:58system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning 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))
5952017-09-26 23:25:45system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
5962017-09-26 23:25:45system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
5972017-09-26 23:25:45system7debug7212TX-WS087::1m_users::validateprevalidating user
5982017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
5992017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
6002017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
6022017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
6032017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
6042017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet action to collection, because GET, no id, no action.
6052017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet current to y, because in reserved words.
6062017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
6072017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectioninput_helper::inputreadparsing inputSet properties to *, because non-devices default.
6082017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionreading data
6092017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
6102017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectionm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
6112017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionreading data
6122017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
6132017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
6142017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
6152017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning 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
6162017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectionm_queries::collectionreading data
6172017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectionm_queries::collectionsuccessrunning 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
6182017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
6192017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
6202017-09-26 23:25:45system7debug7212AdministratorTX-WS087::1discoveriescollectionm_collection::collectionsuccessrunning 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))
6222017-09-26 23:25:51system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
6232017-09-26 23:25:51system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
6242017-09-26 23:25:51system7debug7212TX-WS087::1m_users::validateprevalidating user
6252017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
6262017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
6272017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
6292017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
6302017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
6312017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet ID to 5, according to URI.
6322017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet action to read, because GET, id and no action.
6332017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet current to y, because in reserved words.
6342017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
6352017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
6362017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
6372017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
6382017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
6392017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
6402017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
6412017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_collection_org_permissionretrieving collection orgsretrieving parent orgs
6422017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readreading data
6432017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readsuccessrunning sql/* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 5
6442017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionreading data
6452017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionsuccessrunning 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
6462017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionreading data
6472017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionsuccessrunning 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
6482017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcereading data
6492017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcesuccessrunning sql/* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 5 ORDER BY `id`
6502017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionreading data
6512017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionsuccessrunning 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
6522017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
6532017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
6542017-09-26 23:25:51system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning 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))
6562017-09-26 23:25:57system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
6572017-09-26 23:25:57system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
6582017-09-26 23:25:57system7debug7212TX-WS087::1m_users::validateprevalidating user
6592017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
6602017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
6612017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
6632017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
6642017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet collection to discoveries, according to URI.
6652017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesinput_helper::inputreadparsing inputSet ID to 5, according to URI.
6662017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet action to read, because GET, id and no action.
6672017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet current to y, because in reserved words.
6682017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
6692017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
6702017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
6712017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
6722017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
6732017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionreading data
6742017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
6752017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_users::get_user_collection_org_permissionretrieving collection orgsretrieving parent orgs
6762017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readreading data
6772017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::readsuccessrunning sql/* m_discoveries::read */ SELECT * FROM discoveries WHERE id = 5
6782017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionreading data
6792017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_orgs::collectionsuccessrunning 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
6802017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionreading data
6812017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_locations::collectionsuccessrunning 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
6822017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcereading data
6832017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_discoveries::read_sub_resourcesuccessrunning sql/* m_discoveries::read_sub_resource */ SELECT * FROM discovery_log WHERE discovery_id = 5 ORDER BY `id`
6842017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionreading data
6852017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_queries::collectionsuccessrunning 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
6862017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
6872017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
6882017-09-26 23:25:57system7debug7212AdministratorTX-WS087::1discoveriesreadm_collection::collectionsuccessrunning 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))
6902017-09-26 23:26:11system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
6912017-09-26 23:26:11system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
6922017-09-26 23:26:11system7debug7212TX-WS087::1m_users::validateprevalidating user
6932017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
6942017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
6952017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
6972017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
6982017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1configurationinput_helper::inputreadparsing inputSet collection to configuration, according to URI.
6992017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1configurationcollectioninput_helper::inputreadparsing inputSet action to collection, because GET, no id, no action.
7002017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1configurationcollectioninput_helper::inputreadparsing inputSet current to y, because in reserved words.
7012017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1configurationcollectioninput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
7022017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1configurationcollectioninput_helper::inputreadparsing inputSet properties to *, because non-devices default.
7032017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1configurationcollectionm_roles::collectionreading data
7042017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1configurationcollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
7052017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1configurationcollectionm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
7062017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1configurationcollectionm_roles::collectionreading data
7072017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1configurationcollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
7082017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1configurationcollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
7092017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1configurationcollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
7102017-09-26 23:26:11system7debug7212AdministratorTX-WS087::1configurationcollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT configuration.* FROM configuration ORDER BY configuration.id LIMIT 1000
7112017-09-26 23:26:12system7debug7212AdministratorTX-WS087::1configurationcollectionm_queries::collectionreading data
7122017-09-26 23:26:12system7debug7212AdministratorTX-WS087::1configurationcollectionm_queries::collectionsuccessrunning 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
7132017-09-26 23:26:12system7debug7212AdministratorTX-WS087::1configurationcollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
7142017-09-26 23:26:12system7debug7212AdministratorTX-WS087::1configurationcollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
7152017-09-26 23:26:12system7debug7212AdministratorTX-WS087::1configurationcollectionm_collection::collectionsuccessrunning 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))
7172017-09-26 23:26:38system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
7182017-09-26 23:26:38system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
7192017-09-26 23:26:38system7debug7212TX-WS087::1m_users::validateprevalidating user
7202017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
7212017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
7222017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
7242017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
7252017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationinput_helper::inputreadparsing inputSet collection to configuration, according to URI.
7262017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationinput_helper::inputreadparsing inputSet ID to 26, according to URI.
7272017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadinput_helper::inputreadparsing inputSet action to read, because GET, id and no action.
7282017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadinput_helper::inputreadparsing inputSet current to y, because in reserved words.
7292017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadinput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
7302017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadinput_helper::inputreadparsing inputSet properties to *, because non-devices default.
7312017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadm_roles::collectionreading data
7322017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
7332017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
7342017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadm_roles::collectionreading data
7352017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
7362017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadm_configuration::readloading data
7372017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadm_configuration::readsuccessrunning sql/* m_configuration::read */ SELECT * FROM configuration WHERE id = 26
7382017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadm_orgs::collectionreading data
7392017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadm_orgs::collectionsuccessrunning 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
7402017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadm_queries::collectionreading data
7412017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadm_queries::collectionsuccessrunning 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
7422017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
7432017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
7442017-09-26 23:26:38system7debug7212AdministratorTX-WS087::1configurationreadm_collection::collectionsuccessrunning 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))
7462017-09-26 23:26:41system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
7472017-09-26 23:26:41system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
7482017-09-26 23:26:41system7debug7212TX-WS087::1m_users::validateprevalidating user
7492017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
7502017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
7512017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
7532017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
7542017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationinput_helper::inputreadparsing inputSet collection to configuration, according to URI.
7552017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectioninput_helper::inputreadparsing inputSet action to collection, because GET, no id, no action.
7562017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectioninput_helper::inputreadparsing inputSet current to y, because in reserved words.
7572017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectioninput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
7582017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectioninput_helper::inputreadparsing inputSet properties to *, because non-devices default.
7592017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectionm_roles::collectionreading data
7602017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
7612017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectionm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
7622017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectionm_roles::collectionreading data
7632017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
7642017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
7652017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
7662017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT configuration.* FROM configuration ORDER BY configuration.id LIMIT 1000
7672017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectionm_queries::collectionreading data
7682017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectionm_queries::collectionsuccessrunning 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
7692017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
7702017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
7712017-09-26 23:26:41system7debug7212AdministratorTX-WS087::1configurationcollectionm_collection::collectionsuccessrunning 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))
7732017-09-26 23:27:28system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
7742017-09-26 23:27:28system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
7752017-09-26 23:27:28system7debug7212TX-WS087::1m_users::validateprevalidating user
7762017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
7772017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
7782017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
7802017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
7812017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logsinput_helper::inputreadparsing inputSet collection to logs, according to URI.
7822017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet action to collection, because GET, no id, no action.
7832017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet current to y, because in reserved words.
7842017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
7852017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet properties to *, because non-devices default.
7862017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionreading data
7872017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
7882017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectionm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
7892017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionreading data
7902017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
7912017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
7922017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
7932017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT logs.* FROM `logs` WHERE logs.type = "access" ORDER BY logs.id LIMIT 100
7942017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectionm_queries::collectionreading data
7952017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectionm_queries::collectionsuccessrunning 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
7962017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
7972017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
7982017-09-26 23:27:28system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning 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))
8002017-09-26 23:27:31system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
8012017-09-26 23:27:31system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
8022017-09-26 23:27:32system7debug7212TX-WS087::1m_users::validateprevalidating user
8032017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
8042017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
8052017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
8072017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
8082017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logsinput_helper::inputreadparsing inputSet collection to logs, according to URI.
8092017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet action to collection, because GET, no id, no action.
8102017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet current to y, because in reserved words.
8112017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
8122017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet properties to *, because non-devices default.
8132017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionreading data
8142017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
8152017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectionm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
8162017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionreading data
8172017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
8182017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
8192017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
8202017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT logs.* FROM `logs` WHERE logs.type = "system" ORDER BY logs.id LIMIT 100
8212017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectionm_queries::collectionreading data
8222017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectionm_queries::collectionsuccessrunning 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
8232017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
8242017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations
8252017-09-26 23:27:32system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning 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))
8272017-09-26 23:28:16system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT NOW() as `timestamp`
8282017-09-26 23:28:16system7debug7212TX-WS087::1m_configuration::loadsuccessrunning sql/* m_configuration::load */ SELECT count(*) as device_count FROM system
8292017-09-26 23:28:16system7debug7212TX-WS087::1m_users::validateprevalidating user
8302017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1m_users::get_orgspreretrieving orgs
8312017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1m_users::get_orgpreretrieving org
8322017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1m_users::get_parent_orgspreretrieving parent orgs
8342017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1input_helper::inputreadparsing input
8352017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1logsinput_helper::inputreadparsing inputSet collection to logs, according to URI.
8362017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet action to collection, because GET, no id, no action.
8372017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet current to y, because in reserved words.
8382017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet format to screen, according to HEADERS.
8392017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet format to html, according to GET.
8402017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1logscollectioninput_helper::inputreadparsing inputSet properties to *, because non-devices default.
8412017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionreading data
8422017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
8432017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1logscollectionm_users::get_user_permissionsuccessrunning sql/* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 1
8442017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionreading data
8452017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1logscollectionm_roles::collectionsuccessrunning sql/* m_roles::collection */ SELECT * FROM `roles`
8462017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM orgs
8472017-09-26 23:28:16system7debug7212AdministratorTX-WS087::1logscollectionm_collection::collectionsuccessrunning sql/* m_collection::collection */ SELECT id, name FROM locations