Reporting station with the following dependency

[PA DEQUIDT]

Good morning,

I managed to build the report below so that it returns all the packages that depend on the package PACK-XXX :

Code: Select all

SELECT DISTINCT
    p.package
FROM
    packages p,
    unnest(p.depends) AS dep
WHERE
    dep ILIKE '%%PAQUET-XXX%%';

However, I am unable to build the reporting so that for a PACKET-YYY the reporting returns all the machines on which the package has been added as a dependency.

If you have any ideas for the construction, I'm all ears.

Thank you so much.

Pierre-Alexis DEQUIDT

[jarnaud]

Good morning,

Can you try this query?

Code: Select all

SELECT DISTINCT
    h.computer_name AS hostname
FROM
    hosts h
JOIN
    hostpackagesstatus hp ON h.uuid = hp.host_id
WHERE
    'PAQUET-YYY' = ANY(hp.depends);

Does this answer your question?

Yours sincerely