Hello,

could you try this query?

SELECT
hosts.description,
hosts.uuid AS machine,
hosts.last_logged_on_user,
hostpackagesstatus.install_date,
hostpackagesstatus.install_status,
hostpackagesstatus.version,
CASE
WHEN hostpackagesstatus.host_id IS NOT NULL THEN 'Present'
ELSE ...

That's great then.

I wish you a pleasant day.

No worries, the queries can still be useful to others.

So it might be possible, but you'd have to ask someone more skilled than me (probably chatgpt or something similar ^^).
Unfortunately, SQL works line by line.
I'm not capable of creating that type of presentation.
Here's what I've been told...

Hello,

Can you try this?

SELECT
h.dnsdomain,
COUNT(*) AS number_machines,
STRING_AGG(h.computer_name, ', ' ORDER BY h.computer_name) AS machines
FROM hosts AS h
JOIN hostauditdata AS ha
ON h.uuid = ha.host_id
WHERE
h.os_name ~* '^Windows 10'
AND ha.value_section = 'w11 ...

Hello,


could you share your request with me so I can try to adapt it?
I'd like to start with this and add total lines if that works for you.

Best regards

Hello,

you can try this query which will display the number of machines per domain (still in version 10).

SELECT
COALESCE(dnsdomain, 'TOTAL') AS dnsdomain,
COUNT(*) AS nombre_machines,
STRING_AGG(computer_name, ', ' ORDER BY computer_name) AS machines
FROM hosts
WHERE os_name ...

Hello,

the message indicates a SHA not matching error. Could you compare the SHA of the package on the machine with the error and the SHA of the same package on a machine without the error?

On Windows machines, you can check the SHA of the MSI file using PowerShell: `

Get-FileHash .\filename.msi -Algorithm SHA256 | Format-List ...`

Yes, a query displays results at a specific point in time (its execution).
If machines update Cortex to a version higher than 9 in the meantime, then those updates will no longer be displayed in the query results.

Best regards.

This means that an index (a position) in a tuple (or list) does not exist.
Try again with this query:


SELECT hostsoftwares.version,
hostsoftwares.name,
hosts.computer_name,
hostsoftwares.host_id
FROM hosts, hostsoftwares
WHERE hostsoftwares.name ILIKE 'Cortex%%'
AND hosts ...

Hello,

No problem, here's how:

1. Create the query

In the WAPT console, go to Reporting → Design Mode → New Query. This adds an empty query that you can then edit and rename (F2 key).

2. The SQL query

Using the example "Listing hosts with ...