Filtering duplicate serial numbers

Comments

1 comment

  • Colby Bouma

    It is not possible to create Collections for that. However, here is a SQL Report based on one that I created a couple years ago for duplicate AD GUIDs.

    SELECT
    Computers.Name AS "Computer Name"
    , DuplicateSerial.SerialNumber AS "Serial Number"
    FROM
    -- https://stackoverflow.com/a/21980136
    (
    SELECT
    Computers.SerialNumber
    , COUNT(*) AS "Count"
    FROM
    Computers
    WHERE
    <ComputerFilter>
    AND
    Computers.SerialNumber NOT IN (
    ""
    , "Default string"
    , "Not Applicable"
    , "System Serial Number"
    , "To Be Filled By O.E.M."
    )
    GROUP BY
    Computers.SerialNumber
    HAVING
    Count > 1
    ) DuplicateSerial
    INNER JOIN
    Computers USING (SerialNumber)
    WHERE
    <ComputerFilter>
    ORDER BY
    "Computer Name"
    0
    Comment actions Permalink

Please sign in to leave a comment.