Hello Denis,

Below is my request to find the TPM version.

WITH cte AS (
SELECT ctid,
host_id,
row_number() OVER (PARTITION BY host_id, value_key ORDER BY value_date) AS rank
FROM HostAuditData
WHERE value_section = 'audit-dmi' AND value_key = 'audit-dmi'
)
SELECT
cte.host_id,
h ...

Hello,
Thank you for this answer, which I was able to adapt to my needs.
Sincerely,
Benoit.

Hello,

since the update to version 2.6, DMI data is no longer in the hosts table. It is now retrieved using DMI auditing.
How can I retrieve this data using a query?
For example, in version 2.5, to retrieve TPM information from PCs, you simply used this method...

Thank you for your reply. Indeed, we hadn't set the upgrade as a dependency because it's not mentioned in the update procedure.
The agents are now showing as connected again.
Thank you very much.

Hello,
Following the update to version 2.5 of our server, the agents on version 2.4 are not updating. The machines appear as Disconnected on the console.
Running `wapt-get install waptupgrade` on the machine resolves the issue. However, running `wapt-get update` fails to detect the package.

Hello,

we have several educational software programs in executable format for which the usual silent installation parameters /s /S /SILENT /VERYSILENT /QN do not work.

The Universal Silent Switch Finder tool, which allows us to find the installation options for an MSI or executable file...