Untitled

da404lewzer

Dec 4th, 2012

101

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

MySQL 1.13 KB | None | 0 0

raw download clone embed print report

SELECT UNIQUE
hosts.name, hosts.ip, hosts.environment, fn.name as keyName, fv.value as keyValue
FROM hosts
LEFT JOIN fact_values fv ON (fv.host_id = hosts.id)
LEFT JOIN fact_names fn ON (fn.id = fv.fact_name_id)
WHERE
(
fn.name = "your_key_a" OR
fn.name = "your_key_b" OR
fn.name = "your_key_c"
) AND
hosts.name like '%nos%'
SELECT
hosts.name,
hosts.ip,
hosts.environment ,
(SELECT fv.value FROM fact_values fv LEFT JOIN fact_names fn ON (fn.id = fv.fact_name_id) WHERE fn.name = 'swapfree' AND fv.host_id = hosts.id LIMIT 1) as swapfree,
(SELECT fv.value FROM fact_values fv LEFT JOIN fact_names fn ON (fn.id = fv.fact_name_id) WHERE fn.name = 'netmask' AND fv.host_id = hosts.id LIMIT 1) as netmask,
(SELECT fv.value FROM fact_values fv LEFT JOIN fact_names fn ON (fn.id = fv.fact_name_id) WHERE fn.name = 'processorcount' AND fv.host_id = hosts.id LIMIT 1) as processorcount,
(SELECT fv.value FROM fact_values fv LEFT JOIN fact_names fn ON (fn.id = fv.fact_name_id) WHERE fn.name = 'kernel' AND fv.host_id = hosts.id LIMIT 1) as kernel
FROM
hosts
WHERE
hosts.name like '%nos%'

Add Comment

Please, Sign In to add comment