I am trying to create a custom query on a fresh install of this version. I can run the SQL and the query is valid, but when I go through the "create query" page, and click submit, I never see the query appear. Is there something else I need to do?
Here is the query. I took an existing query and wanted some additional information.
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.manufacturer AS `system.manufacturer`, system.model AS `system.model`, system.serial AS `system.serial`, system.os_family AS `system.os_family`, system.memory_count AS `system.memory_count`, system.form_factor AS `system.form_factor`, processor.description AS `processor.description`, system.processor_count AS 'system.processor_count', disk.manufacturer AS 'disk.manufacturer', disk.model AS 'disk.model', disk.serial AS 'disk.serial', disk.size AS 'disk.size', network.mac AS 'network.mac', network.manufacturer AS 'network.manufacturer', network.model AS 'network.model', sound.manufacturer AS 'sound.manufacturer', sound.model AS 'sound.model', user.name AS 'user.name', user.full_name AS 'user.full_name', video.manufacturer AS 'video.manufacturer', video.model AS 'video.model', video.size AS 'video.size' FROM system LEFT JOIN processor ON (processor.system_id = system.id AND processor.current = 'y') LEFT JOIN network ON (network.system_id = system.id AND network.current = 'y') LEFT JOIN disk ON (disk.system_id = system.id AND disk.current = 'y') LEFT JOIN sound ON (sound.system_id = system.id AND sound.current = 'y') LEFT JOIN user ON (user.system_id = system.id AND user.current = 'y') LEFT JOIN video ON (video.system_id = system.id AND video.current = 'y') WHERE @filter ORDER BY system.name
|