Solicitud de recuperación de software y paquete por OR

[Gaétano]

Hola a todos, aquí hay dos peticiones:

@Template Computadora con SOFTWARE no instalado por OU

Código: Seleccionar todo

SELECT
    h.computer_name
FROM
    hosts h
WHERE
    h.computer_ad_ou LIKE '%%OU%%'
    AND NOT EXISTS (
        SELECT 1
        FROM hostsoftwares hs
        WHERE hs.host_id = h.uuid
        AND hs.name ilike '%%SOFTWARE%%'
    );

@Plantilla de computadora con PAQUETE no instalado por OU

Código: Seleccionar todo

SELECT
    h.computer_name,last_seen_on,last_logged_on_user
FROM
    hosts h
WHERE
    h.computer_ad_ou LIKE '%%OU%%'
    AND h.uuid NOT IN (
        SELECT
            hs.host_id
        FROM
            hostpackagesstatus hs
        INNER JOIN
            packages p ON hs.package_uuid = p.package_uuid
        WHERE
            p.package LIKE 'PACKAGE'
    );