Helpful Foreman queries

foreman.sql

-- Find hosts where name doesn't match certname
SELECT name,certname 
FROM hosts 
WHERE name != certname;

-- Find duplicate nics
SELECT count(*), host_id, identifier FROM nics GROUP BY host_id, identifier HAVING COUNT(*) > 1;

-- Cleanup duplicate nics
DELETE FROM nics
WHERE id in (SELECT MAX(id)
             FROM nics 
             GROUP BY host_id, identifier 
             HAVING COUNT(*) > 1);