[SOLVED] SELF-SERVICE: An operation have Failed

[skoizer]

Hello,
even if there are duplicate entries on the PC, the software was transferred to the new one (UUID in lowercase) unless I uninstalled and then reinstalled the agent (a very rare occurrence)

following the upgrade from version 2.2 to 2.5.5. Do you have a server script to remove duplicate entries that have uppercase letters in their UUID?

Not connected: 4C4C4544-0046-5810-8047-B7C04F444C33
Connected: 4c4c4544-0046-5810-8047-b7c04f444c33

[jarnaud]

Good morning,

You can use an SQL query and save it to retrieve the oldest machines that have a common name.
Next, you need to right-click on the query result > Choose as Host UUID.
Return to inventory > more options > Filter with SQL query > query name

Control + A in the console and delete the posts

Code: Select all

WITH HostsRanked AS (
    SELECT
        h.uuid,
        h.computer_name,
        h.last_seen_on,
        ROW_NUMBER() OVER (PARTITION BY LOWER(h.computer_name) ORDER BY h.last_seen_on DESC) AS rank
    FROM
        hosts h
    JOIN (
        SELECT
            LOWER(computer_name) AS computer_name_normalized
        FROM
            hosts
        GROUP BY
            LOWER(computer_name)
        HAVING COUNT(LOWER(computer_name)) > 1
    ) dup ON LOWER(h.computer_name) = dup.computer_name_normalized
)
SELECT
    uuid,
    computer_name,
    last_seen_on
FROM
    HostsRanked
WHERE
    rank > 1
ORDER BY
    last_seen_on ASC;

Yours sincerely