foreman_nic_cleanup.sql

BEGIN;
DELETE
FROM nics
WHERE identifier LIKE 'tap%'
OR identifier LIKE 'qv%'
OR identifier LIKE 'qbr%';

DELETE
FROM fact_values
WHERE fact_name_id IN (SELECT id
                       FROM fact_names
                       WHERE name LIKE '%_tap%' OR name LIKE '%qv_%' OR name LIKE '%_qbr');

DELETE
FROM fact_names
WHERE id NOT IN (SELECT DISTINCT fact_name_id
                FROM fact_values);
COMMIT;