Tranquil IT Forum

Jarnaud

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 ...`

Jarnaud

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.

Jarnaud

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 ...

Jarnaud

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 ...

Jarnaud

Hello,

I'm adding the link to our documentation to help our clients who might also be taking a well-deserved vacation ^^

You can find it here: https://www.wapt.fr/fr/doc/wapt-console ... ware-names

Best regards

Jarnaud

Hi Stan!

Thanks for the feedback, I'll fix it.

Have a good evening.

Jarnaud

Hello,

Is the waptagent.exe binary present in your Wapt server's web interface?
Is it the same version as the watpsetup.exe binary?

You could also check this forum; the problem seems quite similar.
viewtopic.php?t=4368

Best regards

Jarnaud

Hello,

Yes, indeed, the message indicates that the certificate you are currently using in your console is not recognized by the machine.
You can view the certificate currently used by your console by going to Tools > Preferences and looking at the line...

Jarnaud

Hello,

the "tis-verif-secureboot-uefi-ca-2023" package, once installed on a machine, generates specific audit data.
You can drag and drop this data into your inventory columns to view and sort a large number of machines.

You can use this...

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

The search returned 22 results

Re: files corrupted, SHA not matching

Re: Create a query

Re: Create a query

Re: Create a query

Re: [SOLVED] Adding a column to the main display

[RESOLVED] Re: Correction: minor error in the wording "Using different IDEs for developing WAPT packages"

Re: Bone deployment problem

Re: Inventory problem in Wapt

Re: Audit result report for package tis-verif-secureboot-uefi-ca-2023

Re: Reporting position with dependency